NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Import and export›Import data from another sheet

Google Sheets · Verified tutorial

Import data from another sheet in Google Sheets

Import the amounts from the Source data tab. In B2 enter exactly ='Source data'!B2, then fill that formula down through B4.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Import the amounts from the Source data tab. In B2 enter exactly ='Source data'!B2, then fill that formula down through B4.

Step-by-step

1

Select the targetImport the amounts from the Source data tab.

2

Complete the next actionIn B2 enter exactly ='Source data'!B2.

3

Apply the changefill that formula down through B4.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

B2:B4 links to the Source data tab and displays 125, 180, and 240.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select B2 and repeat the final action. B2:B4 links to the Source data tab and displays 125, 180, and 240.

Example spreadsheet data

This is the clean fixture used for the verified run.

Order	Imported amount
A-100
A-101
A-102

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Import the amounts from the Source data tab.
Complete the next action. In B2 enter exactly ='Source data'!B2.
Apply the change. fill that formula down through B4.
B2:B4 links to the Source data tab and displays 125, 180, and 240.