Guide

How to Copy and Use a Google Sheets Template

How to open any of our Excel templates in Google Sheets, make your own copy, keep the formulas working and share it with others.

Updated November 19, 2026In Spreadsheets

All of our spreadsheet templates download as Excel (.xlsx) files, and they work perfectly in Google Sheets. Here is how to get started.

  1. Download the template by clicking the Excel button on any template page.
  2. Go to Google Drive and sign in.
  3. Click New › File upload and choose the downloaded .xlsx file.
  4. Double-click the file in Drive, and it opens in Google Sheets.
  5. To convert it to a native Google Sheet, click File › Save as Google Sheets. Google creates a converted copy alongside the original.

Method 2: Import into an existing sheet

  1. Open Google Sheets and create a blank spreadsheet, or open an existing one.
  2. Click File › Import › Upload and choose the .xlsx file.
  3. Choose Replace spreadsheet, Insert new sheet(s) or Create new spreadsheet.
  4. Click Import data.

Keep a clean master copy

Before you start entering data, make a copy you can reuse:

  1. Open the sheet and click File › Make a copy.
  2. Name it clearly, for example Monthly Budget – MASTER.
  3. Each month, make a new copy from the master, for example Monthly Budget – March 2027.

Using the template

  • Type in the table rows and light yellow cells. These are where your numbers go.
  • Leave formula cells alone. Totals and calculated columns update automatically.
  • Insert rows within tables (right-click a row number › Insert 1 row above) so totals include the new row.
  • Undo mistakes with Ctrl+Z (Cmd+Z on Mac), or restore an earlier version from File › Version history.

Sharing your sheet

  1. Click the Share button in the top-right corner.
  2. Enter the email addresses of people you want to share with.
  3. Choose their access:
    • Viewer: can only look
    • Commenter: can add comments but not change data
    • Editor: can make changes
  4. Click Send.

For budgets and other personal data, share only with people you trust, and avoid “Anyone with the link” access.

Troubleshooting

Problem Fix
Formulas show as text Make sure the cell format is not set to Plain text (Format › Number › Automatic)
Dollar signs missing Select the cells and choose Format › Number › Currency
Dates look wrong Check File › Settings › Locale is set to United States
Print layout looks off Use File › Print and set “Fit to width” and Letter paper

Browse our best free Google Sheets templates to get started.

Frequently asked questions

Will Excel formulas work in Google Sheets?

Almost always. Common functions such as SUM, IF, COUNTA, MAX and ROUND work the same in both. Our templates use only standard formulas, so they work in Sheets without changes.

Should I convert the file to Google Sheets format?

Converting (File › Save as Google Sheets) gives you every Google Sheets feature, including comments, version history and the best sharing options. You can also edit .xlsx files directly in Sheets without converting.

Can I use Google Sheets on my phone?

Yes. Install the free Google Sheets app for iPhone or Android. Editing is easiest on a tablet or computer, but the app works well for quick updates such as logging an expense.

Related templates and guides