Data Import & Export

How to Automatically Import Google Sheets Data into Excel Without VBA

Camila MilosovichCamila Milosovich Nov 13, 2026 868 views

Question details

The user wants to link Google Sheets data into Microsoft Excel and refresh it automatically without writing VBA code.

How to Automatically Import Google Sheets Data into Excel Without VBA
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.
Before you start

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.

Solution 1Recommended

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.

1
Publish or share the Google Sheet

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.

2
Open the From Web connector

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.

3
Authenticate and select the table

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.

4
Save the connection securely

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.

5
Enable automatic refresh

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.

Import Google Sheets Data with Excel's From Web Connector and Set Up Automatic Refresh
Refresh works without VBA: The query refreshes directly from the saved connection. If the connector does not show the refresh interval option, use refresh on open or check whether the Google Sheets URL requires authentication.
Free Microsoft Office alternative

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. 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. 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. 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.
Free spreadsheet app that opens and saves .xlsx files with high Microsoft Office format compatibilityFamiliar ribbon interface and functions make it easy to switch from ExcelLightweight installation and lower resource usage than many Office suitesSupports web and CSV data imports for Google Sheets exported tables
microsoft office alternative - wps office

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.