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:
- The file is JSON, which Sheets' import functions don't read directly.
- Each 10-K repeats figures for earlier years, and amended filings repeat them again, so you have to pick the one that belongs to the year you want.
- The SEC asks automated tools to identify themselves and to stay under 10 requests a second.
- The same line can have different tag names from one company to the next (revenue alone has several).
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.
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.