Guides
Getting numbers from SEC filings into Google Sheets.
How to get 10-K financial data into Google Sheets
Three ways to bring revenue, net income and other numbers from a company's SEC 10-K into Google Sheets, and what each one involves.
How to get quarterly revenue from 10-Q filings into Google Sheets
Quarterly figures come from 10-Q filings, but there is no 10-Q for the fourth quarter. How to work out Q4 and year-to-date cash flow numbers in Google Sheets.
How to calculate free cash flow in Google Sheets from SEC filings
Free cash flow is operating cash flow minus capital spending. How to pull both from a company's 10-K into Google Sheets and calculate it for ten years.
How to compare companies' financials side by side in Google Sheets
Build a peer comparison in Google Sheets with revenue, margins, free cash flow and return on equity for several companies, straight from their 10-K filings.
AsFiled formula reference: FILING and FILING_SOURCE
Syntax, line names, periods and options for the AsFiled =FILING() formula in Google Sheets.
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.