Import Google Sheets Data into an Excel Workbook on OneDrive
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.
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.
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.
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.
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.
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.
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.
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.
Download Google Sheets as an Excel file for a manual snapshot
Use this method when publishing is not allowed or when you only need a periodic copy rather than a refreshable connection.
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.

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.




