How to copy data from one Google sheet to another automatically?

You've got data in one sheet in your spreadsheet, and you want to use it in another sheet. You could copy it—but then you'd have to manually update the data in each spreadsheet every time the data changed. Who has that kind of time? Not to mention the risk you run of manually inputting incorrect data.

Table of Contents Show

Copy cells from one sheet to another with !
Connect sheets in different spreadsheets
Copy new rows between Excel spreadsheets
Update Google Sheets rows with data from new rows also on Google Sheets
Create Google Sheets rows from new updates to other Google Sheets rows
How do I auto populate information from one tab to another in Google Sheets?

Get more out of your spreadsheets with automation

Learn how

There's a better option: link your spreadsheet cells to keep the data consistent across sheets.

Here are two easy ways to copy data from another sheet in Excel (and the

same trick works for Google Sheets, Numbers, and other popular spreadsheet apps).

Copy cells from one sheet to another with !

To copy data from one sheet to another, all you need to know is the source sheet's name and the name of the cell being copied. Then link them together with an exclamation mark.

From Excel (or any spreadsheet app), open or create a new sheet.
Select the cell you want to pull data into.
Type
= immediately followed by the name of your source sheet, an exclamation mark, and the name of the cell being copied. For example, =Roster!A2.

Here's a detailed example:

Let's say your source sheet's name is "Roster," and you need to copy the data from cell A2 into another sheet named "Names." In the "Names" sheet, click the desired cell, type =Roster!A2, and the data from cell A2 in the source sheet will populate.

Or, there's an easier option.

Type = in the cell where you want to reference data from other sheets.
Toggle to the source sheet.
Click the cell being copied.
Hit enter, and the function will automatically populate.

Now, if you change the data in the original cell that was copied, the data will automatically update in every spreadsheet where that cell is referenced.

Need to calculate values using the data in your source cell? Simply type the rest of your function as normal. For example, if Names!B3 has the value 3, and you type =Names!B3*3, you'll get the result 9 in your new cell, just as you'd expect.

Connect sheets in different spreadsheets

Have data in two different spreadsheets that you want to copy to a new spreadsheet? The best option is to use Zapier's Microsoft Excel workflows (or Google Sheets workflows) to connect your sheets. With these Zaps (what we call our pre-built workflows), Zapier can watch for new or updated data in your source cells and automatically copy it over to your desired spreadsheet.

Copy new rows between Excel spreadsheets

Try it

Microsoft Excel

Update Google Sheets rows with data from new rows also on Google Sheets

Try it

Google Sheets

Create Google Sheets rows from new updates to other Google Sheets rows

Try it

Google Sheets

Now, with your data linked, you can stop manually copying and pasting information—and get peace of mind knowing your data is up to date and consistent across every spreadsheet.

How do I auto populate information from one tab to another in Google Sheets?

To autofill the rest of the values in column C, we can hover over the bottom right-hand corner of cell C2 until a tiny “+” appears. Then click and drag down to all of the remaining cells in column C: What is this? Notice that all of the values from the Points column in Sheet1 have been autofilled into Sheet2.