Export Google Finance to Excel — Stock Data Fast
Google Finance has a wealth of financial data—stock prices, key statistics, income statements, balance sheets. Getting that data into Excel for analysis shouldn't require manual copying.
Fastest method: Install HTML Table Exporter, go to a Google Finance stock page, click the extension, export the financials table to XLSX. Takes 10 seconds.
What data can you export from Google Finance?
Google Finance stock pages contain several useful data tables:
- Key statistics: Market cap, P/E ratio, dividend yield, 52-week range
- Income statement: Revenue, net income, EPS (annual and quarterly)
- Balance sheet: Total assets, liabilities, equity
- Cash flow: Operating, investing, and financing cash flows
- Market indices: S&P 500, Dow Jones, NASDAQ components
Method 1: Browser extension (recommended)
The fastest way to get Google Finance data into Excel is using a browser extension that exports the tables directly.
Install HTML Table Exporter
Add to Chrome (free, no account required).
Go to a Google Finance stock page
Navigate to any stock, e.g., google.com/finance/quote/AAPL:NASDAQ.
Scroll to the data you want
Find the Financials section with income statement, balance sheet, or cash flow data. Click on the table.
Click the extension, export to XLSX
The extension detects the table. Click XLSX to download an Excel file.
Export Google Finance data to Excel →
Export multiple years at once
Google Finance shows multiple years of financial data in expandable tables. Make sure to expand "Show all" before exporting to get the full history.
Method 2: GOOGLEFINANCE function in Sheets
Google Sheets has a built-in GOOGLEFINANCE function that pulls live stock data. You can then export from Sheets to Excel.
Basic stock price
=GOOGLEFINANCE("AAPL", "price")Returns the current stock price for Apple.
Multiple attributes
=GOOGLEFINANCE("AAPL", "all")Returns a table with open, high, low, close, volume.
Historical data
=GOOGLEFINANCE("AAPL", "close", DATE(2025,1,1), DATE(2025,12,31), "DAILY")Returns daily closing prices for 2025.
Available attributes
price— Current pricehigh/low— Day's high/lowvolume— Trading volumemarketcap— Market capitalizationpe— Price-to-earnings ratioeps— Earnings per sharechangepct— Percent change
Limited financial statement data
GOOGLEFINANCE doesn't provide full income statements or balance sheets—just key metrics. For complete financial statements, use the browser extension method.
Exporting to Excel
Once you have the data in Google Sheets:
- Go to File → Download → Microsoft Excel (.xlsx)
- The formulas become static values in Excel
Which method should you choose?
| Need | Best Method |
|---|---|
| Full financial statements | Browser extension |
| Real-time price feeds | GOOGLEFINANCE in Sheets |
| Historical price data | GOOGLEFINANCE in Sheets |
| One-time export | Browser extension |
| Ongoing analysis in Excel | Browser extension + refresh manually |
| Market indices tables | Browser extension |
Bottom line: Use the browser extension for complete financial statements and one-time exports. Use GOOGLEFINANCE for live price tracking and historical time series.
Export financial data quickly
Get Google Finance tables—income statements, balance sheets, market data—directly into Excel. No formulas, no manual copying.
No account required · Works offline · Clean financial data