How to Export SEC Filings to Excel with Active Formulas.

Updated 2026 • ~6 min read • Institutional Financial Modeling Workflow

Equity research analysts and private equity associates spend countless hours transcribing SEC filing data into Excel. While the SEC publishes XBRL structured tags, getting from an EDGAR HTML filing to an audit-ready multi-sheet workbook has historically required either painful copy-pasting or expensive $30,000/year terminal add-ins.

Option 1 — Financial_Report.xlsx in the Filing Archive

Many 10-K and 10-Q submissions include a raw Excel workbook in the submission's archive directory (often named Financial_Report.xlsx). You can find this by navigating to the company CIK archive folder on sec.gov rather than using the standard document viewer.

• Pros: Contains standard financial statements when the SEC compiler succeeds.
• Cons: Lacks dynamic formulas (values are hardcoded), contains hundreds of redundant footnote sheets, and does not support 8-K events or Form 4 insider transactions.

Option 2 — data.sec.gov CompanyFacts REST API

The SEC exposes raw JSON payloads containing tagged concept histories for every reporting issuer. While powerful for quantitative developers building Python scrapers, it requires manual JSON parsing, fiscal calendar alignment, and currency unit transformations before producing a usable Excel model.

Option 3 — CALIO Client-Side Multi-Sheet Generator

CALIO operates directly inside your Chrome browser next to SEC EDGAR. With a single click on any company page or filing, CALIO parses the XBRL tags and compiles an audit-ready .xlsx workbook containing:

• Sheet 1: 3-Statement Model — Income Statement, Balance Sheet, and Cash Flows with YoY variance deltas and active summation formulas.
• Sheet 2: 5-Year DCF Engine — Working formulas for WACC discounting, free cash flow conversion, and terminal value sensitivity.
• Sheet 3: Peer Benchmark Matrix — Sector peer comps, operating margins, Beneish M-Scores, and Altman Z-Scores.
• Sheet 4: Segment Revenue — ASC 280 disaggregated business line and geographic revenue.