How to Automatically Import Google Sheets Data into Excel Without VBA
Question details
The user wants to link Google Sheets data into Microsoft Excel and refresh it automatically without writing VBA code.

- Product
- Microsoft Excel and Google Sheets
- Device & OS
- not provided
- Scenario
- The user keeps source data in Google Sheets and wants that data to feed an Excel workbook automatically.
- Observed behavior
- The user wants to avoid VBA and manual copy-paste; the expected result is a refreshable query that updates from Google Sheets.
Have the Google Sheets file ready and make sure you can share it or publish it to the web. Use desktop Excel for the full Get Data > From Web flow, because refresh options may be limited in Excel for the web.
Import Google Sheets Data with Excel's From Web Connector and Set Up Automatic Refresh
Use this when you want a native, no-VBA connection between Google Sheets and Excel, with manual or automatic refresh controls.
Excel's From Web connector treats a published or shared Google Sheets URL as a web data source. The query is saved in the workbook, so you can refresh it without re-entering the source.
In Google Sheets, open the file and either use File > Share > Publish to web and copy the published table URL, or create a shareable link with at least View access. Confirm the URL opens in a browser where you can see the data.
In desktop Excel, go to Data > Get Data > From Other Sources > From Web. Paste the Google Sheets URL into the address field and select OK.
If prompted, sign in to Google and allow access. In the Navigator preview, select the table or worksheet that contains your Google Sheets data, then choose Load or Load To.
When you load the data, store the credentials with the connection by choosing the appropriate authentication and saving the workbook so Excel can reuse them for future refreshes.
Select Data > Queries & Connections, right-click the connection, choose Properties, and on the Usage tab enable Refresh every and Refresh data when opening the file. Use Data > Refresh All to update immediately.

Try WPS Office Spreadsheets as a Free Alternative for Excel and Google Sheets Workflows
WPS Office gives you a free, lightweight spreadsheet application with an Excel-like ribbon, strong .xlsx compatibility, and familiar data import tools. If you want to move away from Excel or need a no-cost way to open, edit, and manage Google Sheets exports, WPS Spreadsheets makes migration simple.
- 1. Download and install WPS Office: Go to the official WPS Office download page, download the free installer for your device, and complete the setup.
- 2. Open your Excel workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open the .xlsx file that contains or will receive the Google Sheets data.
- 3. Reimport exported Google Sheets data: In Google Sheets, download or publish the sheet as .xlsx or CSV, then use WPS Spreadsheets' Data tab to import the file and continue working without VBA.

Frequently Asked Questions
Will the From Web connector refresh Google Sheets data automatically if the Excel file is closed?
No. In desktop Excel, refresh on open runs when the workbook opens, and a refresh interval runs while the workbook is open. Closed-workbook scheduled refresh is not a built-in Excel-only feature; it requires platforms such as Power BI or Microsoft 365 connections that support scheduled refresh.
What Google Sheets URL format works best with Excel's From Web connector?
Use a published-to-web URL for a specific sheet or range, or a shareable link that returns an HTML table. The normal editor URL may not expose a table to Excel.
Why does Excel ask for credentials every time I refresh?
You may not have saved the credentials with the connection. In the connection or data source settings, choose the option to save credentials, then save the workbook before refreshing again.
Can I use this method if the Google Sheet is private?
Yes, but you must share it with the Google account you use in Excel or publish it to the web. Publishing makes data publicly accessible, so avoid it for sensitive content.
Does WPS Office have the same From Web connector?
WPS Spreadsheets can import web, CSV, and Excel files, but the exact Power Query-style From Web/Refresh All workflow is an Excel feature. WPS is a free alternative for opening, editing, and managing spreadsheets.




