Where the clean tables are
Every 10-K on EDGAR (the SEC's free filings website) comes as a long web page. Hidden behind it is a tidier version: the Interactive Data viewer, also called the Financial Report pages. It shows each statement as a simple table you can copy.
Inside the 10-K's tables:
- The income statement and cash flow statement show three years.
- The balance sheet shows two dates (this year end and last year end). For a third, open last year's 10-K.
The Excel button is gone
Older tutorials tell you to click "View Excel Document" to download the report as a spreadsheet. Recent filings don't have it (checked 20 Nov 2026: Microsoft's FY2024 10-K does, its FY2025 and FY2026 10-Ks don't). So copy and paste the tables instead.
A layout that works
- One tab per company. Statement lines down the left, one column per fiscal year, oldest on the left. The SEC tables put the newest year first, so you will need to reorder them.
- Same units everywhere. The SEC tables say "$ in millions" at the top. Keep it that way and write the unit in the top-left cell.
- Raw numbers first, your own rows below. Never type over a reported number. Calculate from it.
- Write the source (which 10-K, which date you copied it) in a cell at the top.