1 |
Use Forms for automatic data entry
Instead of manually entering survey responses in a spreadsheet, use Forms. Create your survey in Forms and send responses instantly to a spreadsheet in Sheets. The spreadsheet is linked to your survey, so new responses appear in real time. Learn how
Create a survey in Forms:To create a survey, see Get started with Forms. Send survey responses to a new spreadsheet:
Send survey responses to an existing spreadsheet:
To open your spreadsheet from Forms, click View responses in Sheets |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 |
Restrict data entry with lists
Reduce the chance of data-entry errors by limiting choices in Sheets. For example, if you have a status column, you can give choices, such as Done, In Progress, and Not Started. You specify the options and they appear in a drop-down list in each cell in the column. Learn how
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 |
Validate email addresses
If your data involves entering email addresses, reduce entry errors by validating the email format in Sheets. Learn how
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4 |
Combine data from several sheets into a single sheet
If you have data in separate spreadsheets, you can copy a range of data from one spreadsheet to another. For example, you can track quarterly sales data for a product in a different spreadsheet for each region. To combine all the quarterly sales data, copy the data from each region's spreadsheet into a single spreadsheet in Sheets. Learn how
For example: To import cells A1 through C10 from sheet 1 of the abcd123abcd123 spreadsheet, you enter: =IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10") |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5 |
Find and update data
Searching for data and updating it doesn’t have to be time-consuming. You can quickly find and update text or numbers in Sheets. Learn how
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
6 |
Split data into columns
You can split clearly defined data, such as text separated by commas, into separate columns in Sheets. For example, a single column with Last name, First name data can be split into 2 columns: Last name and First name. Learn how
Paste and split data:
Split existing data:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
7 |
Swap rows and columns
If you want to rotate what you have in columns to rows, or vice versa, you can do that using the TRANSPOSE function in Sheets. For example, you might want to swap column headings with row headings. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
8 |
Remove duplicate data
Duplication errors are a common problem that can be costly and easy to miss, especially in big data. Use Sheets to remove any unwanted, duplicate data. Cells with identical values but different letter cases, formatting, or formulas are considered duplicates. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
9 |
Remove extra spaces
When you copy and paste data, sometimes extra spaces are accidentally pasted. Extra spaces can cause problems when searching for data strings. Remove extra leading spaces, trailing spaces, or excessive spaces from your data in Sheets. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
10 |
Clean up data faster with keyboard shortcuts
Instead of using your mouse, work faster with keyboard shortcuts. For example, you can quickly select, group, or hide rows or columns or format data in cells. Learn how
|
Related topics