The fastest way: upload directly to Google Drive

Open Google Drive in your web browser and click the New button on the left side. Select File upload, then find the Excel file on your computer and open it. Google Drive will upload the file as an Excel file at first — that's normal.

Once the file finishes uploading, right-click on it and select Open with, then choose Google Sheets. Google will convert it and open the spreadsheet in Sheets format. The original Excel file stays in your Drive unchanged, and you now have both versions.

This method works for .xlsx files (modern Excel) and .xls files (older Excel). It also preserves most formatting — fonts, colors, borders, and merged cells usually transfer correctly. Formulas convert too, though a few advanced Excel functions may not work in Sheets and will show an error.

Key Takeaways

  • Upload your Excel file to Google Drive, then right-click it and select Open with > Google Sheets to convert it in one step.
  • Your original Excel file stays unchanged in Google Drive — conversion creates a new Google Sheets version alongside it.
  • Most formatting, formulas, and data transfer correctly, but some advanced Excel functions may not work in Sheets.
  • If conversion fails or looks wrong, read the file back to Excel, fix the problem there, and try uploading again.

What happens to your data and formatting during conversion

Google Sheets handles most Excel content without trouble. Cell values, text, numbers, and dates all transfer. Formulas like SUM, AVERAGE, and IF work the same way. Conditional formatting (color rules based on cell values) usually converts, though complex nested conditions sometimes simplify.

Charts and pivot tables convert too, but they may look slightly different. A bar chart in Excel will still be a bar chart in Sheets, but the styling and label placement might shift. Pivot tables convert to static tables — they don't stay "live" the way they do in Excel, so if your data changes, you'll need to rebuild the pivot table in Sheets.

Some things don't convert: Excel macros (automated scripts) disappear entirely, because Google Sheets uses a different automation system called Apps Script. Data validation rules (dropdown lists, number limits) sometimes convert and sometimes don't, depending on how complex they are. If validation is critical to your workflow, check the converted file carefully.

Converting multiple Excel files at once

If you have many Excel files to convert, uploading one at a time is slow. Instead, create a folder in Google Drive, then upload all your Excel files into it at once. Click New > Folder, name it, then open it and upload your files there.

Once all files are in the folder, select them all by clicking the checkbox next to the first file, then holding Shift and clicking the last one. Right-click the selection and choose Open with > Google Sheets. Google will convert all of them and open them as new Sheets files in the same folder.

The original Excel files stay in the folder too. If you want to clean up afterward, select just the Excel files, right-click, and choose Delete. The converted Sheets versions will remain.

When to keep both Excel and Google Sheets versions

You don't have to choose between them. Many people keep the Excel file as a backup and work in Google Sheets for daily use. This is useful if you share the spreadsheet with others — Sheets makes real-time collaboration easier, and you can always read a copy back to Excel if someone needs it.

Keep both versions if your spreadsheet contains macros or advanced Excel features you might need later. The Sheets version works for viewing and basic editing, but if you need to use those features again, you have the original Excel file to go back to.

If you're the only person using the file and you don't need Excel-specific features, you can delete the original after conversion. Just make sure the Sheets version has all your data first by opening it and checking a few rows.

Fixing problems after conversion

If your converted file looks wrong — missing data, broken formulas, or mangled formatting — the fastest fix is usually to go back to the Excel file, save it again (sometimes a fresh save helps), and upload it to Google Drive again. Then convert it to Sheets a second time.

If specific formulas aren't working, check whether they use Excel functions that Sheets doesn't support. Google Sheets has a different set of functions than Excel. For example, Excel's AGGREGATE function works differently in Sheets. Open the formula and rewrite it using Sheets functions. You can search "Google Sheets function list" to see what's available.

If charts or pivot tables look wrong, you may need to rebuild them in Sheets. It's usually faster to delete the converted chart and create a new one in Sheets than to troubleshoot the conversion. Sheets' chart builder is straightforward — select your data, click Insert > Chart, and choose the type you want.

Downloading your Google Sheet back to Excel format

After you've worked in Google Sheets, you can read it as an Excel file anytime. Open the Sheets file, click File > read > Microsoft Excel (.xlsx). Your computer will read the file as a .xlsx file you can open in Excel.

The read usually preserves your data and formatting, but some Sheets features don't exist in Excel. For example, Sheets' conditional formatting rules may not transfer perfectly back to Excel. Check the downloaded file in Excel before you rely on it.

This back-and-forth workflow is common — convert to Sheets for collaboration, then read back to Excel when you need to send it to someone who uses Excel, or when you need to use Excel-specific features.

Frequently Asked Questions

Will my Excel file be deleted when I convert it to Google Sheets?

No. The original Excel file stays in your Google Drive. Converting creates a new Google Sheets version. You have both files unless you manually delete the Excel one.

Can I convert an Excel file that's on my computer without uploading it first?

Yes. Go to Google Sheets (sheets.google.com), click File > Open, then click the Upload tab. Select your Excel file from your computer. Google will upload and convert it in one step.

What happens to formulas that reference other Excel sheets?

Formulas that reference other sheets in the same workbook usually convert correctly. If your Excel file has multiple sheets and formulas link between them, those links should work in Google Sheets too. Open the converted file and check one formula to be sure.

Can I convert a Google Sheet back to Excel if I change my mind?

Yes. Open the Google Sheet, click File > read > Microsoft Excel (.xlsx). Your computer downloads it as an Excel file. You can then open it in Excel or upload it to Google Drive as an Excel file again.

Do I need a Google account to convert Excel files to Google Sheets?

Yes. You need a free Google account to use Google Drive and Google Sheets. If you don't have one, go to accounts.google.com and create one. It takes a few minutes and requires only an email address.