All Collections
Workflows
Google Sheets Basics
How to copy a sheet (tab) to another Google Sheet
How to copy a sheet (tab) to another Google Sheet

Learn how to copy financial reports and sheets between Google Sheets.

Heather Phillips avatar
Written by Heather Phillips
Updated over a week ago

A handy thing about Google Sheets is that you can copy a tab from one Google Sheet into another Google Sheet.

This is especially powerful when you spend time building your own customized financial reports and budgets and decide you want to re-use them in another Google Sheet powered by Tiller's automated bank data feeds.

Try Tiller Free

How to copy a sheet between Google Sheets

  1. Copy the URL of the target Google Sheet

  2. Open the Google Sheet that has the tab you want to copy into the target sheet

  3. Right click the tab you want to copy

  4. Choose "Copy to > Existing Spreadsheet" 

  5. Paste the URL into the top of the window that appears then press ENTER

  6. Select the target Google Sheet when it appears in the search results

  7. Choose "Insert" and close the acknowledgement the sheet has been successfully copied

  8. Rename the tab in the target Google Sheet if desired 

Did this answer your question?