XBRL to EXCEL - Join Calcbench & Download Our Excel Add‑In

The fastest and easiest way to get SEC filing data in Excel:
  • Hundreds of standardized metrics
  • Raw XBRL tags
  • Entire as-reported financial statements
  • Over 9,000 US listed public companies

Join Calcbench for free and get started in a matter of seconds.

Best Way To Get Started?

Download an example spreadsheet,
or open the formula builder
to create your own model:
Remember, RIGHT CLICK any
Calcbench formula for more options,
like TRACE or Refresh:

Example Spreadsheets

To open the examples, click on the link and save the file (remember where you saved it). Then, go to Excel and open the example spreadsheet.

Excel functions for retrieving data from Calcbench

To retrieve standard (normalized) metrics: =CalcbenchData(metric, ticker, year, period)
=CalcbenchData("Revenue", "MSFT", 2013, "Y")
To retrieve numerical XBRL data by tag: =CalcbenchXBRLTag(XBRLTag, ticker, year, period)
=CalcbenchXBRLTag("CapitalizedComputerSoftwareAmortization", "MSFT", 2012, 0)
To retrieve numerical XBRL data by tag and dimension: =CalcbenchXBRLTag(XBRLTag, ticker, year, period, dimension)
=CalcbenchXBRLTagFiscalPeriod("SalesRevenueNet", "INTC", 2015, "Y", "ChinaincludingHongKongMember")
To retrieve textual XBRL data by tag (will not work with text blocks or policy tags): =CalcbenchXBRLTextTag(XBRLTag, ticker, year, period)
=CalcbenchXBRLTextTag("EntityRegistrantName", "0000789019", 2014, "Q1")
ticker symbol OR 10 digit CIK code
Calendar year
Calendar period - (Q1, Q2, Q3, Q4, Y, 1H, 3QCUM) OR (1, 2, 3, 4, 0, 5, 6), OR (MRQ, MRY) for Most Recent Quarter or Year. Quarterly values can be followed by ttm for trailing twelve months (e.g. Q1 TTM). Also, you can specify -1 for most recent quarter.

More Examples

=CalcbenchData("Revenue", "MSFT", 2013, "Q2 TTM") - Trailing 12 months ending in Q2 2013
=CalcbenchData("Revenue", "MSFT", 0, "MRY") - Most recent full year
=CalcbenchData("Revenue", "MSFT", 0, "MRQ") - Most recent quarter
=CalcbenchData("Revenue", "MSFT", 1, "MRQ") - 1 quarter prior to most recent quarter
=CalcbenchData("Revenue", "MSFT", 0, "MRQ TTM") - most recent trailing 12 months

Using Fiscal Periods Instead Of Calendarized Periods

=CalcbenchDataFiscalPeriod("Revenue", "AAPL", 2013, "Y")
=CalcbenchXBRLTagFiscalPeriod("CapitalizedComputerSoftwareAmortization", "AAPL", 2012, 0)
   (More about fiscal and calendarized periods here)

Using 'As-Originally-Reported' Data

   'As-Originally-Reported' or 'First Reported Values' are available for face and footnote financial metrics. These are 'unrevised' values, captured the first time the company reported the item.
=CalcbenchDataAsOriginallyReported("Revenue", "MSFT", 2013, "Y")
=CalcbenchDataFiscalPeriodAsOriginallyReported("Revenue", "MSFT", 2013, "Y")

To Refresh All Data

   Hitting Ctrl-Alt-F9 will reload all formulas. You may also need to close and reopen your spreadsheet to make sure nothing is cached.

Available Normalized Metrics