Skip to main content

Google Sheets for Excel Users

Google Sheets for Excel Users: Beginner's Guide

Google Sheets is a free, browser-based spreadsheet with nothing to install. Basic skills carry over from Excel: cells, formulas, formatting, charts, and filters. The main differences are autosave, sharing, a few function names, and no VBA.

1. Get started

  1. Sign in to a free Google account and go to sheets.google.com (or type sheets.new).
  2. Click Blank spreadsheet and rename it at the top left.
  3. Nothing needs saving. Sheets autosaves to Google Drive.
  4. For offline use, enable offline access in Drive settings (Chrome or Edge).

2. Excel-to-Sheets translation

In Excel In Sheets
Ribbon Menu bar plus a toolbar. Use the menu search (Alt+/) if you can't find a command.
Save / AutoSave Always automatic.
Share via OneDrive Green Share button, top right. Anyone with access can edit at the same time.
Comments and notes Right-click a cell > Comment or Note.
PivotTable Insert > Pivot table. It is more basic than Excel's .
Charts Insert > Chart. A side editor lets you customize it.
Filters / Sort Data > Create a filter, or Data > Sort range.
Macros (VBA) Apps Script (JavaScript), under Extensions. VBA isn't supported .
Power Query / Power Pivot No direct equivalent. The QUERY function covers some uses .

3. Formulas

  • Most common functions work the same: SUM, AVERAGE, IF, VLOOKUP, XLOOKUP, COUNTIF, and SUMIF.
  • Sheets has fewer functions overall. One comparison lists about 200+ in Sheets versus 450+ in Excel .
  • Sheets-only helpers worth learning: QUERY (SQL-like filtering), ARRAYFORMULA (apply a formula to a whole column), IMPORTRANGE (pull data from another sheet), and GOOGLEFINANCE.
  • Array behavior differs from Excel's spilled arrays, and users report Sheets' versions can be less reliable . Test results when you port complex formulas.

4. Working with existing Excel files

  • Edit the .xlsx in place: upload it to Drive, then double-click it to preview. Edits save in the original Excel format .
  • Convert to Sheets: open the file, then File > Save as Google Sheets. The original isn't changed .
  • Import into an existing sheet: File > Import. Choose Create new spreadsheet, Insert new sheet(s), or Replace spreadsheet .
  • Send back to Excel users: File > Download > Microsoft Excel (.xlsx) .
  • Supported import formats include .xlsx, .xls, .csv, .tsv, and .ods .

5. Limits and when to keep Excel

Google recommends converting to Sheets for team collaboration, with datasets of 20 million cells or fewer. It suggests staying in Excel for larger datasets, the Hyperion add-on, or rare chart types such as 3D pyramid or pie-of-pie . Large sheets can also load and edit slowly .

6. First-day checklist

  1. Import one of your real Excel files and check formulas and formatting.
  2. Freeze header rows: View > Freeze.
  3. Apply a filter and try a pivot table.
  4. Share with one person and edit at the same time.
  5. Check File > Version history.
  6. Try =QUERY() and =ARRAYFORMULA() on a small range.

Footnotes

https://plaky.com/blog/google-sheets-vs-excel/ https://www.reddit.com/r/excel/comments/1m5nt8b/in_your_experience_what_are_the_most_important/ https://www.reddit.com/r/googlesheets/comments/1j87wq5/how_did_you_learn_to_use_sheets_and_where_can_i/ https://support.google.com/docs/answer/9331167 https://zapier.com/blog/convert-google-sheets-to-excel/ https://www.geeksforgeeks.org/convert-excel-to-google-sheets/ https://www.adobe.com/acrobat/hub/google-sheets-vs-microsoft-excel.html