Google Docs and Excel Sheets: Open, Convert, Link and Export

If you searched “google docs excel sheet,” you most likely want to do one of two things: open or edit an Excel spreadsheet with Google’s tools, or get spreadsheet data into a Google Doc. The short answer is that Excel files open in Google Sheets (not Google Docs), and from Sheets you can paste a linked table or insert a linked chart into any Google Doc.

Below are the official ways to handle each step, plus the limits that tend to catch people out. Menu names are accurate as of November 2026, but Google adjusts its interface regularly, so labels may shift slightly.

Google Docs vs. Google Sheets: which one handles Excel?

“Google Docs” is often used as a catch-all name for Google’s editors, but each Office format has its own counterpart:

So an Excel sheet never becomes a Google Doc. It becomes, or is edited as, a Google Sheets file. If your end goal is a document with a table or chart in it, you go through Sheets first and then bring the data into Docs.

Option 1: Edit the Excel file as-is (Office editing)

Google’s Work with Office files help page explains that you can edit, comment on and collaborate on Office files directly in Docs, Sheets and Slides. With this approach, called Office editing, your changes are saved back to the file in its original Office format.

1. Upload the .xlsx file to Google Drive.
2. Double-click the file in Drive. It opens in Google Sheets.
3. Edit as normal. Changes auto-save to the original Excel file.

This is the best choice when the file has to stay an Excel file, for example because a colleague or client will open it in Excel afterwards.

Limits of Office editing

According to Google’s Office editing help page:

• Password-protected files aren’t supported and open in preview only.
• Macros aren’t supported. Google suggests reimplementing them in Apps Script if you need them.
• Some features aren’t available while you edit in Office format, so a complex workbook may behave differently than it does in Excel.

Option 2: Convert the Excel file to a Google Sheet

Converting creates a new, native Google Sheets file. You get the full set of Sheets features, but the new file is no longer an Excel file, and the original stays untouched.

1. Open the Excel file from Drive (it opens in Sheets, as above).
2. Go to File > Save as Google Sheets.
3. A new Sheets copy opens. Work in that copy from now on.

If you regularly move Excel files into Google’s tools, Drive also has a Convert uploads setting under Settings (the gear icon). Third-party guides describe it as a checkbox on the General tab; once enabled, Office files you upload afterwards are converted automatically, while files already in Drive are left alone. Check your own Drive settings, as the exact wording and placement may differ by account type.

Office editing or convert?

Google’s own documentation for linking describes it in terms of Google Sheets files, which is why converting first is the cautious route if you plan to link the data into a Doc.

Putting spreadsheet data into a Google Doc

Once your data lives in Google Sheets, Google Docs can show it as a linked table or a linked chart. Google’s Link a chart, table, or slides help page covers both.

Insert a linked table

1. In Google Sheets, select the range of cells you want.
2. Copy it (Ctrl+C on Windows or ChromeOS, Cmd+C on Mac).
3. In your Google Doc, click where the table should go and paste.
4. When asked, choose Link to spreadsheet to keep it connected, or paste unlinked for a static table.

There is a size limit. Google states that tables with more than 400 cells paste unlinked, and you can’t expand a previously linked table beyond 400 cells. If your data is bigger, link a summary range instead of the whole sheet.

Insert a linked chart

1. Build the chart in Google Sheets first.
2. In your Doc, go to Insert > Chart > From Sheets.
3. Pick the spreadsheet, then select the chart you want and confirm the import. Leave the link option on if you want it to stay connected.

Keeping linked content current

Linked tables and charts don’t refresh silently. When the source data changes, an Update button appears on the object in your Doc, and you click it to pull in the new numbers. If you want to freeze a chart as it looks today, use the linked chart options menu and choose Unlink, which turns it into a static image.

What about pasting straight from Excel?

You can copy cells in desktop Excel and paste them into a Google Doc, but that gives you a plain, unlinked table with no connection back to the workbook. If the numbers will change, it’s worth the extra minute to open the file in Sheets and paste a linked version instead. A screenshot is another fallback, but as ClickUp’s walkthrough notes, it can’t update at all.

Getting your sheet back into Excel

If you converted a file and now need an Excel copy again:

1. Open the spreadsheet in Google Sheets.
2. Go to File > Download > Microsoft Excel (.xlsx).
3. Open the downloaded file in Excel.

Guides such as Smartsheet’s describe this same menu path. Third-party testers also report that the download includes every tab in the workbook; to export a single tab, copy it into a new spreadsheet first. Keep in mind the download is a separate copy, so edits you make in Excel won’t sync back to the Google Sheet unless you upload the file again.

Formula and formatting fidelity is where sources are least consistent. Some third-party testers report that common formulas carry over fine while a few functions or features come through as static values or are dropped. Google doesn’t publish a complete compatibility list in the pages we checked, so if a workbook matters, open the exported file and spot-check key formulas before you send it on.

Common problems and quick fixes

• File opens in preview and won’t edit: it’s probably password-protected. Remove the password in Excel (if you’re permitted to) and re-upload.
• Macros are missing: expected. Sheets doesn’t run Excel macros; keep that workbook in Excel or rebuild the logic in Apps Script.
• Pasted table isn’t linked: check whether the range is over 400 cells, and make sure you chose “Link to spreadsheet” when pasting.
• Chart in Doc shows old numbers: click the Update button on the chart.
• Someone edited the .xlsx in Excel and Sheets didn’t change: a downloaded copy doesn’t sync. Agree on one working copy, either the Office-edited file in Drive or a converted Google Sheet.

Which workflow should your team use?

For teams that live in Google Workspace, the long-term friendly setup is simple: convert incoming Excel files to Google Sheets, keep one source of truth in Sheets, and link tables or charts into Docs so reports update with a click. If some colleagues or clients stay on Excel, use Office editing so the file keeps its .xlsx format, and accept that a few Excel-only features, like macros, won’t be available in the browser.