How to Get ETF Holdings in Excel

Get etf holdings directly in Excel using custom formulas. Retrieve financial data, automate your workflows, and keep your spreadsheets updated with our Excel add-in.

Install Add-inView Pricing
No VBA/Macros Required
Microsoft Certified Add-in
2-Minute Setup
EXCEL FORMULA
=FDN("EtfHoldings", "SPY", "", 5)

This formula pulls data into your spreadsheet once our Excel add-in is installed.

Formula Result

See exactly how data fills into your sheet when the formula runs. This example shows the actual up-to-date information returned.

ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1central_index_keyregistrant_nameperiod_of_reportetf_nameetf_symbolseries_idclass_idissuer_namelei_numbertitle_of_securitytrading_symbolcusip_numberisin_numberamount_of_unitsdescription_of_unitsdenomination_currencyvalue_in_usdpercentage_value_compared_to_assetspayoff_profileasset_typeissuer_typecountry_of_issuer_or_investmentis_restricted_securityfair_value_levelis_cash_collateralis_non_cash_collateralis_loan_by_fund
20000884394SPDR S&P 500 ETF TRUST2026-06-30SPDR S&P 500 ETF TRUSTSPYN/AN/AAmerican Express CoR4PP93JZOLY261QX3811American Express CoAXP025816109US02581610926449784NSUSD2181639438.00.279271699315LongECCORPUSFalse1FalseFalseFalse
30000884394SPDR S&P 500 ETF TRUST2026-06-30SPDR S&P 500 ETF TRUSTSPYN/AN/AArista Networks Inc635400H1WKBLOQERUU95Arista Networks IncANET040413205US040413205412513436NSUSD2125782507.680.272121452773LongECCORPUSFalse1FalseFalseFalse
40000884394SPDR S&P 500 ETF TRUST2026-06-30SPDR S&P 500 ETF TRUSTSPYN/AN/AAdvanced Micro Devices IncR2I72C950HOYXII45366Advanced Micro Devices IncAMD007903107US007903107819760238NSUSD11478919856.581.469416714247LongECCORPUSFalse1FalseFalseFalse
50000884394SPDR S&P 500 ETF TRUST2026-06-30SPDR S&P 500 ETF TRUSTSPYN/AN/AAmerican Electric Power Co Inc1B4S6S7G0TW5EE83BO58American Electric Power Co IncAEP025537101US02553710176593971NSUSD902121172.510.115480545706LongECCORPUSFalse1FalseFalseFalse
60000884394SPDR S&P 500 ETF TRUST2026-06-30SPDR S&P 500 ETF TRUSTSPYN/AN/AElevance Health Inc8MYN82XMYQH89CTMTH67Elevance Health IncELV036752103US03675210382631924NSUSD1017843968.520.130294222673LongECCORPUSFalse1FalseFalseFalse
ABCDEF
1central_index_key00008843940000884394000088439400008843940000884394
2registrant_nameSPDR S&P 500 ETF TRUSTSPDR S&P 500 ETF TRUSTSPDR S&P 500 ETF TRUSTSPDR S&P 500 ETF TRUSTSPDR S&P 500 ETF TRUST
3period_of_report2026-06-302026-06-302026-06-302026-06-302026-06-30
4etf_nameSPDR S&P 500 ETF TRUSTSPDR S&P 500 ETF TRUSTSPDR S&P 500 ETF TRUSTSPDR S&P 500 ETF TRUSTSPDR S&P 500 ETF TRUST
5etf_symbolSPYSPYSPYSPYSPY
6series_idN/AN/AN/AN/AN/A
7class_idN/AN/AN/AN/AN/A
8issuer_nameAmerican Express CoArista Networks IncAdvanced Micro Devices IncAmerican Electric Power Co IncElevance Health Inc
9lei_numberR4PP93JZOLY261QX3811635400H1WKBLOQERUU95R2I72C950HOYXII453661B4S6S7G0TW5EE83BO588MYN82XMYQH89CTMTH67
10title_of_securityAmerican Express CoArista Networks IncAdvanced Micro Devices IncAmerican Electric Power Co IncElevance Health Inc
11trading_symbolAXPANETAMDAEPELV
12cusip_number025816109040413205007903107025537101036752103
13isin_numberUS0258161092US0404132054US0079031078US0255371017US0367521038
14amount_of_units6449784125134361976023865939712631924
15description_of_unitsNSNSNSNSNS
16denomination_currencyUSDUSDUSDUSDUSD
17value_in_usd2181639438.02125782507.6811478919856.58902121172.511017843968.52
18percentage_value_compared_to_assets0.2792716993150.2721214527731.4694167142470.1154805457060.130294222673
19payoff_profileLongLongLongLongLong
20asset_typeECECECECEC
21issuer_typeCORPCORPCORPCORPCORP
22country_of_issuer_or_investmentUSUSUSUSUS
23is_restricted_securityFalseFalseFalseFalseFalse
24fair_value_level11111
25is_cash_collateralFalseFalseFalseFalseFalse
26is_non_cash_collateralFalseFalseFalseFalseFalse
27is_loan_by_fundFalseFalseFalseFalseFalse
An exchange-traded fund (ETF) is an investment fund holding a collection of assets that trades on the stock exchange just like an individual share. Our Excel add-in provides information on the securities held by exchange-traded funds.

Steps to Get Started

01
Install the Add-in

Open Excel, navigate to the Home tab, select Add-ins, and search for FinancialData.Net.

02
Grab Your Key

Sign in to your account at FinancialData.Net, open the dashboard, and copy your API key.

03
Run Your Formula

Open the task pane in Excel, save your API key, and start typing the =FDN(...) formula.

Formula Reference

Use the formula to retrieve financial data by specifying a dataset, ticker symbol, and additional parameters.

=FDN(dataset, identifier, argument, maxRows)
datasetString
Specifies the dataset to query. Enter the dataset name enclosed in quotation marks, for example "EtfHoldings".
identifierString
Accepts one or multiple identifiers such as ticker symbols (e.g., "AAPL" or "AAPL,MSFT") or other supported identifier types.
argumentString
Filters the dataset output using an additional parameter, such as a date like "2025-01-15" or a reporting period like "year" or "quarter".
maxRowsInteger
Limits the number of records returned by the formula. For example, setting the value to 5 returns the five most recent rows.

Troubleshooting & FAQ

If Excel doesn't recognize the =FDN() formula, the add-in may not have loaded correctly. Restart Excel or reinstall the add-in from the Office Add-ins Store.

Excel displays this error when it does not recognize the =FDN() formula. This means the add-in is either not installed or has been disabled.

The =FDN() formula outputs multiple rows and columns of data, which Excel blocks if any existing text or formatting occupies the surrounding cells. Simply clear these obstructing cells to allow the formula to expand completely.

Install the Excel Add-in

Access 80+ financial datasets directly in Excel using simple formulas.

Install via AppSource
Compatible with Office 365 and Excel for Web
Data Subscriptions for Excel
Standard SubscriptionCore financial data
$29 / mo
Premium Subscription
Full financial data
$69 / mo
Get Started