ETF analysis, built into Google Sheets and Excel

See what a fund really holds with constituent data, sector and country exposure, live prices on major markets, distributions and 30+ years of history.

4.6(226+ reviews)
61k+ downloads
Google SheetsMicrosoft Excel
A1
fx
ABCDE
1AssetShares NumberWeight (%)Market Value
2AAPL176,234,0007.12%43,602,110,600
3MSFT78,412,0006.48%39,684,205,120
4NVDA214,752,0006.05%37,051,884,900
5AMZN104,505,0003.84%23,515,667,300
6META21,493,0002.51%15,372,410,850
7AVGO61,284,0002.14%13,106,826,600
8GOOGL62,305,0001.96%12,005,962,500
9BRK.B23,164,0001.72%10,535,546,400
10GOOG51,908,0001.65%10,106,689,600

Full constituent holdings with share counts, portfolio weights and market values.

Bitcoin
Ethereum logo
Euronext logo
HKEX
LSE
NASDAQ
NYSE
TSX
BCBA
BET
BMV
JPX
KRX
MIL
PRA
SIX
SGX
Tadawul

From holdings to dashboard

See the whole fund, not just the ticker

Turn raw ETF data into a complete analysis dashboard with holdings, exposure and performance already laid out in the sheet.

ETF analysis dashboard in Google Sheets showing holdings, sector exposure and performance
  • See every constituent, weight and market value in one analysis sheet.
  • Compare sector and country exposure without manually rebuilding fund data.
  • Track price, volume, yield and performance alongside the underlying portfolio.
Get this free ETF template โ†’

Start your 15-day SheetsFinance trial to use it in Google Sheets.

What's included

Everything you need to analyse ETFs

Prices, dividends, holdings, exposure, history and technicals โ€” pulled straight into your sheet.

1000s
of global ETFs
30+ yrs
of historical data
60+
exchanges covered
Constituent holdings
See what's inside any US-listed ETF โ€” every holding, weight and position. Major UK and European funds included.
Sector weightings
Sector exposure breakdowns for supported funds, so you can see the real composition behind a ticker.
Country weightings
Geographic exposure for supported global and international ETFs, weighted by allocation.
Profiles & expense ratios
Asset class, expense ratio, AUM, inception date and issuer details for every fund.
Real-time prices
Second-accurate ETF quotes on major exchanges including US markets, with real-time to 15-minute data across 60+ global markets.
History, dividends & technicals
30+ years of daily and intra-day pricing data, dividends and technical indicators.

Global reach

ETF coverage across 60+ global exchanges

Pricing, dividends, history and detailed ETF data across 60+ exchanges. Holdings and exposure covers US-listed ETFs in full, plus major UK and European funds.

Americas

6 markets
USA Canada Brazil Mexico Argentina Chile

Europe

20 markets
United Kingdom Germany France Netherlands Switzerland Italy Sweden Denmark Norway Finland Belgium Austria Spain Portugal Ireland Greece Poland Czech Republic Iceland Turkey

Asia-Pacific

12 markets
Japan Hong Kong China India South Korea Taiwan Singapore Australia New Zealand Malaysia Thailand Indonesia

Middle East & Africa

5 markets
Saudi Arabia Israel Qatar UAE South Africa

ETF datasets

ETF holdings

US & selected major global funds

Sector exposure

See what drives each fund

Country exposure

Geographic allocation data

Fund profiles

AUM, issuer & expense ratios

Distributions

Dividends and payment history

Prices & technicals

Quotes, history & indicators

Pricing

ETF data is included in every Market Data plan

Every plan starts with a 15-day free trial. No payment details required.

Compare all features in the full pricing matrix

Want to build an ETF analysis dashboard?

Book a 20-minute live demo and we'll build a holdings, exposure and performance view with you.

Testimonials

What our community is saying

โ€œWorth it. Constantly updating the extension. Seems genuinely interested in improving. The extension has helped me streamline my stock watchlists as a value investor.โ€
Matthew Harmon
โ€œVERY USEFUL!SheetsFinance data combined with some handy Google Sheets knowledge is the most flexible and best valuable for money finance tool I have found so far.โ€
Gerard
โ€œSheetsFinance is probably the best Excel add-in one can find for markets data. Democratizes access to pro tools with excellent coverage breadth that continues to grow. Customer support is helpful and responsive. Solid documentation too. Lastly, the pace of product improvement in terms of features or new data coverage is excellent. This vastly improves the value one gets out of the subscription. Can't recommend this enough.โ€
ZQ Ong
โ€œSheetsFinance has proved to be a great solution for the Portfolio. We track about 300 stocks globally so that means a lot of different markets and need a lot of relevant data beyond price and PE. SheetsFinance provides all of this and the company offers super friendly, efficient and helpful support with using the product and integrating it into Google Sheets - even helping with formula and syntax suggestions. โ€ฆ An excellent solution. The different tier of plans make this very affordable.โ€
Erskine Tanner
โ€œJust installed to test out the data I wanted (price, dividend, analyst price estimates, specific option quotes). Works like a charm, I highly recommend you try it out for your needs!โ€
John Romano

FAQs

Frequently asked questions

Yes. Holdings coverage is complete for US-listed ETFs, with major funds from the UK, Europe and other global markets also supported. For a covered fund, etfHoldings returns every constituent with its share count, portfolio weight and market value. We are continuously expanding international holdings coverage.