

To add the contents of that another sheet after your existing table, pick Append to current sheet: Once the file is uploaded, you'll see a window with additional options for importing the sheet.Hit Select a file from your device and find the sheet you've downloaded just now.This time, pick File > Import from the menu and go to the Upload tab in the Import file window:.Then open another spreadsheet – the one you'd like to add the sheet to.The file will be downloaded to your computer. Go to File > Download > Comma-separated values (.csv):.Make the sheet of interest active by selecting it.Open the spreadsheet that contains the sheet you'd like to pull the data from.

It will instantly get you to another spreadsheet with the first sheet already there:Īnother way to import data from multiple Google Sheets is to export each sheet first, and then import them all to a necessary file:

Keep the mouse pressed and drag the cursor to as many columns to the right as you need to fill them with new records: The mouse cursor will turn into a big black plus sign. Make sure the cell with the reference is selected and click on that little blue square at its bottom right corner.Otherwise, it will return incorrect data. Use relative cell reference so it changes itself when copied to other cells.
