Tips to add & import data

Get the Analytics add-on

1. If you haven’t already, sign up to start using Analytics.
2. Open Sheets.
3. Click ExtensionsAdd-onsGet add-ons.
4. Search for the Google Analytics add-on and click Install.
5. Click Continue.

1. Open a spreadsheet in Sheets.
2. Click ExtensionsGoogle AnalyticsCreate new report.
3. Enter your information and click Create Report. Your analytics data appears in a new spreadsheet.

Track stock prices or earnings

1. In Sheets, open a spreadsheet.
2. In an empty cell, type =GOOGLEFINANCE.
3. In parenthesis, add any of the following, separated by a comma:
   • A ticker symbol in quotation marks.
   • (Optional) The attribute you want to show, such as price, in quotation marks.
   • (Optional) A start and an end date preceded by DATE and followed with the numerical date in parenthesis.
   • (Optional) Daily or weekly frequency in quotation marks.
4. Press Enter.

Find and update data

1. In Sheets, open a spreadsheet and click EditFind and replace.

2. Next to Find, enter the text or numbers that you want to find.
3. Next to Replace with, enter the new data.
4. Next to Search, choose the sheets that you want to search.
5. (Optional) To refine your search, select additional options.
   You can make your search case-sensitive, find exact matches, use regular expressions, or search within formulas.
6. Choose an option to replace the data:
   • To replace instances one at a time, click FindReplace.
   • To replace all instances, click Replace all.

Protect data from being updated

1. Open a spreadsheet in Google Sheets.
2. Click Data  Protect sheets and ranges. A box will open on the right.
3. Click Add a sheet or range or click an existing protection to edit it.
4. To protect a range, click Range. To protect a sheet, click Sheet.
   • Range: To change or enter the range you’re protecting, click the spreadsheet icon and highlight the range in the spreadsheet.
   • Sheet: Choose a sheet to protect. If you want a set of cells to be unprotected in a sheet, check the box next to "Except certain cells."
5. Click Set permissions or Change permissions.
6. Choose how you want to limit editing:

• To show a warning when anyone makes an edit: Select "Show a warning when editing this range." It doesn’t block people from editing, but they’ll see a message asking them to confirm if they really want to make an edit.
• To choose who can edit the range or sheet: select "Restrict who can edit this range." Choose:
  • Only you: Only you (and the owner if you’re not the owner) can edit the range or sheet.
  • Only domain: If you use Google Sheets for work or school, only people in your domain can edit the range or sheet. This option is only available when everyone in your domain can edit the spreadsheet.
  • Custom: Only the people you choose can edit the range or sheet.
  • Copy permissions from another range: Reuse the same permissions you set up on a different set of cells or sheet.

7. Click Save or Done.

Automate tasks with macros

1. On your computer, open a spreadsheet at sheets.google.com.
2. At the top, click Extensions  Macros  Record macro.
3. At the bottom, choose which type of cell reference you want your macro to use:

• Use absolute references: The macro will do tasks on the exact cell you record. For example, if you bold cell A1, the macro will only ever bold cell A1 regardless of which cell you clicked.
• Use relative references: The macro will do tasks on the cell you select and its nearby cells. For example, if you record bolding cells A1 and B1, the macro can later be used to bold cells C1 and D1.

4. Complete the task you want to record. When you’re done, click Save.
5. Name the macro, create a custom shortcut, and click Save.

• Note: When you create a macro in Google Sheets, an Apps Script is created. To edit this Apps Script, at the top, click Tools  Script editor.

To perform a macro, click Extensions Macros  the macro you want.

Do more with add-ons & scripts

Install an add-on

1. On your computer, open a document, spreadsheet, or presentation.
2. Click Extensions  Add-ons  Get add-ons.
3. Point to an add-on to find a short description. To find a full description, click the add-on.
4. To install the add-on, click Install  Continue.
5. For most add-ons, a message will appear requesting access to data that the add-on needs to work. Read the message, then click Allow.
6. After the add-on installs, click Done.

Create a script

1. In Docs, Sheets, Slides, or Forms, open a document, spreadsheet, presentation, or form.
2. If you’re using Docs, Sheets, or Slides, click ExtensionsApps Script.
3. If you’re using Forms, in the top-right corner, click MoreScript editor.
4. Create your script.