Data Import & Export

Import Google Sheets Data into an Excel Workbook on OneDrive

Khadija KhanKhadija Khan Nov 13, 2026 868 views

Question details

The user wants an Excel workbook stored on OneDrive to display data entered by a team in Google Sheets during a transition to Microsoft services.

Product
Microsoft Excel for Windows, Google Sheets, and Microsoft OneDrive
Device & OS
not provided
Scenario
The team continues editing Google Sheets while an Excel workbook provides a copy of that data for Microsoft-based workflows.
Observed behavior
The desired result is a refreshable copy of Google Sheets data in an Excel workbook, with the workbook stored and synchronized through OneDrive.
Before you start

Check whether your Excel for Windows version includes Data > Get Data > From Other Sources > From Web. Before using a published Google Sheets link, confirm that your organization permits publishing the selected data; do not publish confidential information.

Solution 1Recommended

Connect Excel for Windows to a published Google Sheets CSV feed

Use this approach for data that can be published safely and should be updated in Excel through a repeatable query.

Excel supplies the query and refresh capability; OneDrive supplies file storage and synchronization. This is a one-way import, not a two-way sync: edits made to the imported Excel table do not update Google Sheets.

A published CSV feed makes the selected data accessible outside the sheet's normal sharing controls. If publishing is prohibited or unavailable, use a downloaded Excel snapshot instead.

1
Publish the required Google Sheets tab

Open the source spreadsheet in Google Sheets and select File > Share > Publish to web. Under Link, select the required sheet tab and choose Comma-separated values (.csv), then click Publish and copy the generated link. Where available, leave automatic republishing enabled so changes can reach the published feed.

2
Import the feed into Excel

Open Excel for Windows and select Data > Get Data > From Other Sources > From Web. In some versions, select Data > From Web directly. Paste the published CSV link and confirm. If prompted for credentials for this public feed, choose Anonymous.

3
Check and load the data

In the import preview, check the delimiter, column headings, and data types. Choose Transform Data if adjustments are needed, then select Close & Load; otherwise, choose Load to create a table in the workbook.

4
Save the workbook on OneDrive

Select File > Save As and choose your OneDrive account or a local OneDrive-synced folder. Save the workbook as an Excel Workbook (.xlsx) and allow OneDrive to finish synchronizing it.

5
Refresh the query in desktop Excel

When the Google Sheets data changes, open the OneDrive-stored workbook in Excel for Windows and select Data > Refresh All. After the refresh completes, save the workbook so OneDrive can synchronize the updated results.

OneDrive synchronization is not query refresh: OneDrive synchronizes the saved workbook; it does not itself run the Google Sheets query. For this workflow, refresh in Excel for Windows. Excel for the web refresh support varies by connection type and should not be assumed for this feed.
Free Microsoft Office alternative

Work with exported Google Sheets data in WPS Spreadsheet

WPS Office is a free, lightweight, easy-to-use alternative for opening and editing Google Sheets exports. Its familiar spreadsheet interface and Microsoft Excel format compatibility help ease migration. WPS does not fix Excel's external-query refresh behavior or make OneDrive refresh a Google Sheets connection; use it for manually exported workbook snapshots.

Open Google Sheets data downloaded as a Microsoft Excel workbook.Supports Microsoft Excel .xlsx and .xls formats for straightforward file exchange.Use a familiar spreadsheet interface to review, edit, and organize imported data.Work with exported files in a local OneDrive-synced folder and let OneDrive synchronize saved changes.
microsoft office alternative - wps office

Frequently Asked Questions

Do I have to choose between Excel for Windows and OneDrive?

No. Excel for Windows opens, edits, and refreshes the workbook, while OneDrive stores and synchronizes the file. Save it with File > Save As > OneDrive, then refresh its query in desktop Excel using Data > Refresh All.

Will Google Sheets changes appear in the workbook automatically?

Not simply because the workbook is on OneDrive. The published feed must reflect the source changes, and Excel must refresh its query. For a manual update, open the workbook in Excel for Windows, select Data > Refresh All, and save it.

Can I connect to a private Google Sheet by pasting its normal sharing link into Excel?

A normal Google Sheets sharing link is not the same as a CSV data feed, and Excel's web connector may not authenticate to a private sheet through that link. If you cannot publish the data safely, use Google Sheets > File > Download > Microsoft Excel (.xlsx), or ask your administrator about an approved authenticated integration.

Will changes in the Excel table be written back to Google Sheets?

No. The query imports data in one direction, from Google Sheets into Excel. Continue editing the source in Google Sheets, and avoid treating the query output as an independent editable master because a refresh can overwrite local changes.

What should I do if Excel does not show the From Web command?

Check Data > Get Data > From Other Sources > From Web and Data > From Web in Excel for Windows. Availability depends on the Excel version and edition. If the command is unavailable, download the Google Sheet through File > Download > Microsoft Excel (.xlsx) and store that snapshot on OneDrive.