Home › Forums › The XBRL API › Dictionary of concepts
- This topic has 2 replies, 2 voices, and was last updated 3 years, 8 months ago by David Tauriello.
-
AuthorPosts
-
-
Monday, January 30, 2023 at 7:43 PM #207986Parker LathropParticipant
Hello,
I have been able to set up my Google Sheet and it is pulling data. Is there a specific dictionary which lists out the naming conventions of various line items? I was able to access this through the above mentioned Google Drives file.
For example, If I want to pull Interest Expenses in Google Sheets, I have typed [Interest Expense]. Is there a way to find a complete dictionary? I am using IXBRLAnalayst add-on in Google.
Thanks,
Parker -
Tuesday, January 31, 2023 at 7:58 AM #208006David TaurielloKeymaster
Hi Parker – thanks for writing. SEC filers create their own dictionary when they submit a filing. It includes importing the chosen base taxonomy (US GAAP or IFRS) and adding any company-specific extension concepts that are not defined in the base taxonomy.
I’m not familiar with features of iXBRL Analyst, so can’t advise you on whether these are accessible in that tool. Our XBRL Filed Data extension lets Member institutions create a simple query (either entire base taxonomies or extensions) to return the entire list of concepts (the dictionary). Anyone can search for concepts from the task pane of the extension.
There’s a Taxonomy Viewer link in the Documentation & Discussion section on the right-side of this page that can be used to search the latest US GAAP Taxonomy. This Taxonomy viewer can be used to search IFRS concepts: https://bigfoot.corefiling.com/yeti/resources/yeti-gwt/Yeti.jsp
These are the latest accepted and supported base taxonomies:
https://xbrl.us/2022-us-gaap (an excel of terms can be downloaded from this page)
https://xbrl.us/sec-ifrs-2022
-
-
AuthorPosts
- You must be logged in to reply to this topic.
Search Forums
Recent Topics
Recent Replies
-
Getting started with the XBRL Google Sheet and add-on 3 weeks, 5 days ago
-
Income Statement data for a company 1 year, 4 months ago
-
Income Statement data for a company 1 year, 4 months ago
-
Using the offset parameter 1 year, 8 months ago
-
Using the offset parameter 1 year, 8 months ago
Documentation & Discussion
- Get started with Google Sheets OR
- Get started with Microsoft Excel OR
- Get access to as-filed data from us for other tools or your own app
- XBRL API Interactive Documentation
- Ten Tips & Techniques
- The XBRL API
- XBRL Data Community
- 2026 US GAAP Taxonomy Viewer
- Live support - Monday, 3:30 - 4:30 PM ET
Who's using this free data?
API Use 2026 || API Use 2025 || API Use 2024 || API Use 2023 || API Use 2022 || API Use 2021 || API Use 2020 || API Use 2019 || API Use 2018
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.





