All of our spreadsheet templates download as Excel (.xlsx) files, and they work perfectly in Google Sheets. Here is how to get started.
Method 1: Upload to Google Drive (recommended)
- Download the template by clicking the Excel button on any template page.
- Go to Google Drive and sign in.
- Click New › File upload and choose the downloaded .xlsx file.
- Double-click the file in Drive, and it opens in Google Sheets.
- 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
- Open Google Sheets and create a blank spreadsheet, or open an existing one.
- Click File › Import › Upload and choose the .xlsx file.
- Choose Replace spreadsheet, Insert new sheet(s) or Create new spreadsheet.
- Click Import data.
Keep a clean master copy
Before you start entering data, make a copy you can reuse:
- Open the sheet and click File › Make a copy.
- Name it clearly, for example Monthly Budget – MASTER.
- 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
- Click the Share button in the top-right corner.
- Enter the email addresses of people you want to share with.
- Choose their access:
- Viewer: can only look
- Commenter: can add comments but not change data
- Editor: can make changes
- 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
Best Free Google Sheets Templates
Our most useful spreadsheet templates for Google Sheets, from budgets and invoices to project trackers, all free and with the formulas already set up.
GuideHow to Make a Gantt Chart in Google Sheets
Two easy ways to build a project timeline in Google Sheets, a quick conditional formatting grid or a stacked bar chart, with step-by-step instructions.
TemplateMonthly Budget Template
Plan your month and track where your money actually goes. The Excel version totals income and expenses and shows the difference for every category.
TemplateSimple CRM Spreadsheet Template
A lightweight CRM for freelancers and small businesses. Track every lead and customer, deal stage, value and next follow-up, without paying for software.