Yes, you can bring Google Finance figures into Excel by routing through Sheets or by using Excel’s own market data tools.
Here’s the gist. You want live quotes, history, or fundamentals inside a workbook you already use. Pull market info in Google Sheets with its built-in function and hand it off to Excel, or skip Google’s feed and rely on Excel’s native sources. Both routes work for different jobs.
Using Google Finance Data With Excel: Practical Paths
You have three main options. Pick one based on refresh needs, how clean you want the table, and whether you prefer desktop Excel or the web app.
| Method | What You Get | Best For |
|---|---|---|
| Sheets → Excel export | Free quotes or history from Sheets, saved as .xlsx | One-time handoff with minimal setup |
| Power Query “From Web” | Direct import of a web table into a refreshable Excel table | Repeatable refresh and shaping steps |
| Excel market data | Linked “Stocks” data type and the STOCKHISTORY function | Clean, backed data without any Google step |
Route 1: Pull To Sheets, Then Download As .xlsx
In Google Sheets you can fetch quotes, currency rates, and historical bars with a simple formula. After that, download the file as Excel and open it in your desktop app or Excel for the web. The feed won’t keep updating inside Excel, but you’ll have a tidy table you can refresh by repeating the download in Sheets. See Google’s help on the GOOGLEFINANCE function for syntax and attributes.
Quick Setup In Sheets
Open a blank Sheet, list tickers in column A, and write a GOOGLEFINANCE formula beside them for price, close, or volume. To collect history for a date range, include start and end dates. Sheets spills a neat array with headers. Tweak formats there, then save a copy for reuse.
Export To Excel Cleanly
Use File → Download → Microsoft Excel (.xlsx). Open the file in Excel and save it in a project folder. When you need a fresh cut, reopen the Sheet, let the feed recalc, and download a new .xlsx.
Route 2: Use Power Query To Pull From The Web
Power Query (Get & Transform) imports and shapes data from many sources, including web pages with tables. It turns a messy page into a structured query you can refresh. Filter dates, remove columns, split fields, and load straight to a table. Microsoft’s guide to the web connector walks through each step and the “Suggested Tables” picker.
Steps: From Web To A Refreshable Table
- In Excel, go to Data → From Web, paste a page URL that shows a real table of prices, then press OK.
- In Navigator, pick a detected table or use “Add Table Using Examples” if the page lacks clean table markup.
- Click Transform Data. Trim columns, filter the date span, set types.
- Load to a table. Use Data → Refresh to pull updates later.
When A Site Blocks Scraping
Some finance pages render data with scripts or block automated pulls. If the connector can’t see a stable table, use the Sheets export route or switch to Excel’s native sources below.
Route 3: Rely On Excel’s Built-In Market Data
Excel ships with linked data types for tickers and an array function for history. Convert text tickers to linked cards that expose fields like price, 52-week high, and market cap. For longer histories, use the STOCKHISTORY function to return bars for a range and interval.
Pros And Limits Of Excel’s Feed
- Pros: Clean fields, refresh on demand, no scraping headaches, clear licensing.
- Limits: Coverage and timing vary by exchange; some tickers appear with a delay.
Tip: standardize symbols and currency early. Use the small card icon next to a linked ticker to change the match (for instance, picking the right exchange), and set workbook currency formats before you build charts. That saves time when you refresh later and keeps dashboards consistent across sheets.
Which Path Should You Choose?
Pick based on refresh needs and control. If you want a free pull shaped exactly like you prefer, Power Query gives repeatable steps and a refresh button. If you already track watchlists in Sheets, export to .xlsx when you need a snapshot in a project. If you want the least friction and steady fields, stick with Excel’s built-in feed.
Setup Walkthroughs For Each Approach
Sheets → Excel Workflow
Goal: get a tidy price table into Excel for analysis.
- Open Sheets. In cell A1, add a ticker like “NASDAQ:GOOGL”. In B1, write a GOOGLEFINANCE call for “price” or “close”.
- Fill down for a list of tickers. Add headers with plain text so the export reads cleanly.
- Optional: a second tab for historical data with a start date and end date.
- Use File → Download → Microsoft Excel (.xlsx). Open in Excel and start charting or pivoting.
Power Query Web Pull
Goal: bring a website table into Excel as a refreshable query.
- Data → From Web. Paste a URL that shows an HTML table of prices or listings.
- Pick a suggested table. If none is listed, try “Add Table Using Examples,” then type a sample name and price.
- In Power Query, rename columns, change types, and keep only what you need.
- Close & Load. Click Refresh whenever you want to update.
Excel Market Data
Goal: use backed, linked data without any scraping.
- Type tickers as text (one per cell). Select the range and choose Data → Stocks.
- Click the insert data button and pick fields like Price, Previous Close, or Volume.
- For long history, write STOCKHISTORY with a start date, end date, and interval.
Refresh Behavior After A Sheets Export
The export is a snapshot. To refresh, open the original Sheet, let it recalc, and download a new .xlsx.
When A Page Lacks A Clean Table
The web connector can infer a table with the examples tool, but pages that render data only in scripts tend to resist clean pulls. In that case, use Excel’s native feed or the Sheet export method.
Skip Manual Cleanup With Recorded Steps
Power Query records each shaping step. The next refresh repeats those steps automatically, so your table lands clean.
Sample Build: Portfolio Sheet Handed Off To Excel
Here’s a simple pattern that balances speed with clarity. Use Sheets to pull a watchlist with live prices and a history tab. Add a returns column and a weight column. When you want deeper modeling or a Power Pivot view, export to .xlsx and load that file in Excel. Keep both versions so you can refresh the Sheet later and produce a fresh extract for the model.
| Task | Do It In Sheets | Do It In Excel |
|---|---|---|
| Live quote panel | GOOGLEFINANCE for price and change | Stocks data type fields |
| Daily history table | GOOGLEFINANCE with dates | STOCKHISTORY with range |
| One-click refresh | Spreadsheet recalculation | Refresh All, or query refresh |
| ETL shaping | Array formulas and QUERY | Power Query steps |
| Deep models | Basic charts | Pivot, Power Pivot, measures |
Reliability, Coverage, And Caveats
Feeds differ. Sheets pulls from Google’s service and offers a list of attributes with delays that vary by venue. Excel’s linked data comes from Microsoft’s providers, with real-time on some venues and delayed quotes on others.
Security And Good Habits
Vet the sites you connect to. Stick to official pages for web pulls, avoid unknown download links, and save files in trusted folders. Keep backups of your queries and your Sheets files. If you share a workbook, store credentials safely and set privacy levels when connecting with Power Query. Keep Office and your add-ins updated to avoid breakage after provider changes.
Decision Guide
Need a quick export of a watchlist and a month of daily closes? Use Sheets and save to .xlsx. Need a repeatable pull from a page that lists tickers in a clean table? Build a web query with Power Query and refresh it daily. Want clean fields that drop into charts, plus an array function for long spans? Use Excel’s native feed and STOCKHISTORY. Each choice gets you market data in the workbook you prefer with low friction.