Guides

How to get 10-K financial data into Google Sheets

Every U.S. public company files an annual report (the 10-K) with the Securities and Exchange Commission. The numbers in it are public and free. Here are three ways to get them into a spreadsheet.

1. Copy them by hand from the filing

Search for the company on the SEC's EDGAR website, open the 10-K and copy the figures you need. This costs nothing and you see exactly where each number came from. It is slow for more than a few numbers, and a typo is easy to miss.

2. Use the SEC's own data feed

Since 2009 to 2011 (larger companies first) companies have tagged the numbers in their filings in a format called XBRL. The SEC publishes all of a company's tagged numbers as one file, for example data.sec.gov/api/xbrl/companyfacts/CIK0000789019.json for Microsoft.

It is complete but takes work to use in Sheets:

3. Use a formula that does the picking for you

AsFiled adds one formula to Google Sheets:

=FILING("MSFT", "revenue", 2026)

This returns 331,839,000,000: Microsoft's revenue for fiscal 2026 (July 2025 to June 2026), as printed in its 10-K filed on 29 July 2026. A second formula gives the link to that filing:

=FILING_SOURCE("MSFT", "revenue", 2026)

AsFiled picks the figure for the fiscal year the 10-K itself reports, and by default keeps it as first filed. It knows the common tag names for 22 lines such as revenue, net income, total assets and capital spending (see the formula reference).

Try it without writing anything

Our free Google Sheets templates already contain these formulas. Make a copy, type a ticker, and the numbers fill in.

See the templates

Free templates · Guides · AsFiled Pro · Terms · Privacy · Refunds · Support

AsFiled is made by Eagle Eye Insights LLC. Numbers come from companies' own filings with the U.S. Securities and Exchange Commission; AsFiled is not affiliated with the SEC.