Editor order · Top 10 tools
Best Tools to Pull Stock Data into Excel and Google Sheets
Compare stock data connections for valuation models, price histories, and watchlists.
Start with what your workbook needs. For a valuation model, check whether the connection supplies full statements, historical periods, and the metrics you use. For a watchlist, start with exchange coverage, quote delays, and how often your sheet can refresh. Each pick can pull stock data directly into Excel, Google Sheets, or both.
Editor-ranked · Global vote totals · Not financial advice
Choose by spreadsheet workflow
Build a valuation model
Wisesheets
Use formulas for historical statements and metrics in either app. The add-on has refresh controls and its own annual subscription.
Pull data for several tickers at once
Financial Modeling Prep (FMP)
Sign in with an FMP account. Use its refresh control and range formulas for larger pulls. Data access varies by plan.
Trace workbook figures to SEC filings
Calcbench
Trace Excel figures to source filings with Premium or Professional. Calcbench offers the full add-in for Windows and a limited Microsoft 365 version for Mac and the web.
Build a simple watchlist
Google Finance
Use the built-in GOOGLEFINANCE function in Sheets. Quotes can be delayed by up to 20 minutes, and many international exchanges are unavailable.
Top 10 Tools
| # | Tool | Snapshot | Score | Actions |
|---|---|---|---|---|
| 1 | 0 | |||
| 2 | 0 | |||
| 3 | 0 | |||
| 4 | 0 | |||
| 5 | 0 | |||
| 6 | 0 | |||
| 7 | 0 | |||
| 8 | 0 | |||
| 9 | 0 | |||
| 10 | 0 |
Connector setup and documentation
Compare stock data connections
Choose the data you need in your workbook, then check how the tool updates it. We checked the providers’ documentation for setup and access.
Start with Excel’s built-in Stocks data typeUse formulas for historical statements and metrics in either app. The add-on has refresh controls and its own annual subscription.
Refresh fundamentals, valuation metrics and institutional holdings from formulas or templates. Check the regions and query allowance on your plan.
Sign in with an FMP account. Use its refresh control and range formulas for larger pulls. Data access varies by plan.
Insert financial statements and ratio tables or build custom formulas across tickers. Add a ROIC.ai API key to unlock full ticker coverage.
Use an Alpha Vantage key with the add-ons. Installing the Excel add-in requires an active Microsoft 365 subscription. It runs on compatible Office versions, including newer perpetual releases.
Use spreadsheet formulas for prices, historical fundamentals and options data. Google Sheets requires a separate subscription and offers delayed quotes.
Use an API key to bring historical prices and fundamentals into Excel or Google Sheets. In Sheets, choose the dataset and insert it into a new tab. The free plan limits end-of-day history and API calls.
Pull end-of-day prices, report data and KPIs with a Pro or Pro+ API key. Pro+ adds global data. The Excel plug-in requires Windows, and Google Sheets has its own add-on.
Trace Excel figures to source filings with Premium or Professional. Calcbench offers the full add-in for Windows and a limited Microsoft 365 version for Mac and the web.
Use the built-in GOOGLEFINANCE function in Sheets. Quotes can be delayed by up to 20 minutes, and many international exchanges are unavailable.
Best Tools to Pull Stock Data into Excel and Google Sheets FAQ
Can I pull stock data into Excel without an add-in?
Excel has a built-in Stocks data type for quotes and company information. Use STOCKHISTORY for historical prices if your Microsoft 365 plan supports it.
Can I pull stock data into Google Sheets for free?
The built-in GOOGLEFINANCE function can pull prices and historical data for supported securities. Quotes may be delayed, and many international exchanges are unavailable. Use a dedicated add-on if your model needs full statements or wider coverage.
How is a spreadsheet connector different from a CSV export?
A connector fetches data in your workbook through a formula or add-on. Depending on the tool, it may refresh on demand or when the spreadsheet recalculates. A CSV gives you a snapshot that you have to import again to update.
What should I check before buying a stock data add-in?
Check that the add-in supports your version of Excel or Google Sheets, the exchanges you follow, and the financial fields your model needs. Verify which plan unlocks those fields and whether each ticker or refresh counts toward a request limit.
Keep Exploring
Feedback
Spot something off, stale, or missing? Tell us how this list, vote tallies, or a tool listing could be better.
Curation & Accuracy
This directory blends AI‑assisted discovery with human curation. Entries are reviewed, edited, and organized with the goal of expanding coverage and sharpening quality over time. Your feedback helps steer improvements (because no single human can capture everything all at once).
Details change. Pricing, features, and availability may be incomplete or out of date. Treat listings as a starting point and verify on the provider’s site before making decisions. If you spot an error or a gap, send a quick note and I’ll adjust.