How to Open, Edit, and Convert Excel Files in Google Docs and Sheets (2026 Full Guide)

If you’ve ever tried to open an Excel file in Google Drive and ended up confused about whether to use Google Docs or Google Sheets — you’re not alone. It trips up a lot of people. The short answer: Excel files belong in Google Sheets, not Google Docs. Here’s everything you need to know to open, edit, convert, and work with Excel files using Google’s tools.

Google Docs vs Google Sheets: Which One Do You Actually Need?

People search “how to open Excel in Google Docs” all the time, but the real answer is: you almost never want Google Docs for an Excel file. Here’s the difference:

Use Google Sheets when you want to:

• Edit rows, columns, and cells in your spreadsheet
• Use formulas like SUM, VLOOKUP, or IF
• Work with charts and graphs from your Excel data
• Share and collaborate on a live spreadsheet
• Download the file back as .xlsx when you’re done

Use Google Docs when you want to:

• Write a report or proposal that references spreadsheet data
• Paste a table or chart from your spreadsheet into a document
• Create an invoice or summary using Excel numbers

If you need to actually work with spreadsheet data — edit it, calculate things, or share a live sheet — Google Sheets is always the answer.

How to Open an Excel File in Google Sheets

This is the most common thing people need to do, and it only takes a few steps.

Step-by-Step: Upload and Open in Google Sheets

1. Open Google Drive at drive.google.com and sign in to your Google account.
2. Click the + New button in the top-left corner.
3. Select File upload and choose your Excel (.xlsx or .xls) file from your computer.
4. Once it uploads, right-click the file in Google Drive.
5. Hover over Open with and click Google Sheets.

Your Excel file will open in Google Sheets. At this point, you’re viewing it as a Google Sheets file, but the original .xlsx file is still saved in Google Drive separately.

Option: Convert the File Permanently to Google Sheets

If you want to fully convert it (so it’s saved as a Google Sheets file, not just viewed as one), do this after it opens:

1. Click File in the top menu.
2. Select Save as Google Sheets.

This creates a new Google Sheets version of your file. Both files will exist in your Drive — the original .xlsx and the new Google Sheets version. The Google Sheets version is fully editable and doesn’t require Excel at all.

How to Edit an Excel File in Google Sheets Without Converting

You don’t have to convert the file to edit it. Google Sheets lets you open and edit .xlsx files directly, and save them back as .xlsx when you’re done. This is useful if you need to keep the Excel format — for example, if colleagues use Excel and you’re collaborating on a shared file.

1. Upload the .xlsx file to Google Drive (as above).
2. Open it with Google Sheets.
3. Make your edits.
4. Click File → Download → Microsoft Excel (.xlsx) to save it back as an Excel file.

The file will download to your computer with your changes, in the original Excel format. No conversion, no format loss.

How to Use Excel Formulas in Google Sheets

Good news: most Excel formulas work exactly the same in Google Sheets. Functions like SUM, AVERAGE, IF, VLOOKUP, COUNTIF, and IFERROR all carry over directly. You can open an Excel file with these formulas and they’ll continue to work.

A few things to know:

• XLOOKUP is supported in Google Sheets as of 2023.
• Array formulas work slightly differently — Google Sheets uses ARRAYFORMULA() where Excel uses Ctrl+Shift+Enter.
• Power Query and Power Pivot don’t exist in Google Sheets. If your Excel file uses these, that data won’t transfer.
• Conditional formatting mostly transfers, but complex rules may need to be set up again.

How to Insert Excel Data into Google Docs

If you want to include spreadsheet data inside a written Google Doc — for a report, proposal, or document — here’s how to do it properly.

Method 1: Copy and Paste a Table

1. Open your Excel file in Google Sheets.
2. Select the cells you want to include.
3. Copy them (Ctrl+C or Cmd+C).
4. Open your Google Doc and paste (Ctrl+V or Cmd+V).
5. Google will ask if you want to Link to Spreadsheet or Paste Unlinked. Choose Linked if you want the table to update automatically when the spreadsheet changes.

Method 2: Insert a Chart from Sheets

1. Create or open your chart in Google Sheets.
2. Click the three-dot menu on the chart and select Copy chart.
3. Open Google Docs and paste it in.
4. Again, choose whether to link it to the original spreadsheet or paste it as a static image.

Linked charts and tables are one of the best features of Google’s suite — when you update the numbers in Sheets, you can refresh the chart in Docs with one click.

How to Share an Excel File in Google Sheets

Once your file is open in Google Sheets, sharing it works the same way as any Google Sheets file:

1. Click the Share button in the top-right corner.
2. Add email addresses or copy a shareable link.
3. Set permissions: Viewer, Commenter, or Editor.

Anyone you share it with can view or edit the file directly in their browser — no Excel licence needed.

Common Problems When Opening Excel Files in Google Sheets

Formatting looks different

Fonts, cell sizes, and colors sometimes shift slightly when moving from Excel to Sheets. This is usually cosmetic. Check custom fonts especially — if you used a font that isn’t available in Google Sheets, it will substitute a different one.

Formulas show errors

If you see #NAME? or #VALUE! errors after opening, the formula uses an Excel function that Google Sheets doesn’t support. Common culprits are WEBSERVICE, CUBE functions, and certain legacy analysis add-ins. You’ll need to rewrite these using Google Sheets equivalents.

Merged cells cause layout issues

Heavily merged cells from Excel sometimes lose their formatting in Sheets. If layout is critical (like a formatted invoice), you may need to reapply the merges after opening.

File won’t open

If Google Drive shows an error opening the file, try downloading it again from its source — the upload may have been corrupted. Also check that the file isn’t password-protected; Google Sheets can’t open password-locked Excel files.

Frequently Asked Questions

Can I open an Excel file directly in Google Docs?

Not in the way you’d expect. Google Docs will show the raw XML of an .xlsx file, which is unreadable. You should always open Excel files in Google Sheets. If you need the data in a Doc, open it in Sheets first, then copy what you need into the Doc.

Will Google Sheets mess up my Excel formulas?

Most common Excel formulas — SUM, AVERAGE, IF, VLOOKUP, INDEX/MATCH, COUNTIF, SUMIF — are fully supported in Google Sheets and will work correctly. Complex Excel-specific functions, macros, or add-ins may not transfer perfectly.

How do I download a Google Sheets file back as Excel?

Click File → Download → Microsoft Excel (.xlsx). This works for both files you converted and files you opened without converting.

Can multiple people edit an Excel file at the same time in Google Sheets?

Yes. Once it’s open in Google Sheets and shared, multiple people can edit simultaneously — just like a native Google Sheets file. You’ll see each person’s cursor in a different colour in real time.

Does Google Sheets support Excel’s conditional formatting?

Basic conditional formatting rules transfer over. Complex multi-condition rules or rules using custom VBA-based triggers may not carry across and will need to be recreated in Sheets.

For most people, the switch between Excel and Google Sheets is smoother than expected. Once your file is uploaded and open in Sheets, you get the full power of a spreadsheet editor — in your browser, free, with live collaboration built in. And if you need it back in Excel format, one download takes care of it.

If you found this guide useful, you might also want to check out how to use the best Chrome extensions for productivity or our round-up of free AI tools for writing.

Open Google Sheets ↗
Go to Google Drive