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.

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.

HTML Table Exporter

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 price
• high / low — Day's high/low
• volume — Trading volume
• marketcap — Market capitalization
• pe — Price-to-earnings ratio
• eps — Earnings per share
• changepct — Percent change

What GOOGLEFINANCE cannot do

The GOOGLEFINANCE function is useful for basic price data, but it has significant limitations that frustrate many users:

• No income statements — You cannot pull revenue, net income, or operating expenses by quarter
• No balance sheets — Total assets, liabilities, and equity are not available
• No cash flow data — Operating, investing, and financing cash flows are missing
• Limited historical data — Some attributes only return current values, not time series
• Delayed data — Prices are typically delayed 15-20 minutes
• Unreliable availability — Google occasionally breaks or changes the function without notice

If you are trying to build a financial model or compare company fundamentals, GOOGLEFINANCE is not enough. You need the actual tables from Google Finance — which is exactly what HTML Table Exporter exports.

Exporting to Excel

Once you have the data in Google Sheets:

1. Go to File → Download → Microsoft Excel (.xlsx)
2. The formulas become static values in Excel

Which method should you choose?

Bottom line: Use the browser extension for complete financial statements and one-time exports. Use GOOGLEFINANCE for live price tracking and historical time series.