Others

How to Fix Unknown Function Errors Generating XBRL Files in Excel

John Wilson Sep 28, 2026 868 views

Question details

The user needs to resolve unknown function errors that occur during the generation and validation of an XBRL file.

How to Fix Unknown Function Errors When Generating an XBRL File

Product: Excel XBRL Add-in
Device & OS: not provided
Scenario: Generating and validating an XBRL file for financial reporting using a third-party add-in or software.
Observed behavior: The XBRL validation process produces multiple errors stating that specific functions (e.g., xfi:isQNameDimensionItem, xfi:getInstanceDB, xfi:period, xfi:is-numeric) are unknown.

Before you start

Ensure you have a stable internet connection, as some XBRL add-ins need to fetch taxonomy schemas and validation rules online.

Solution 1Recommended

Contact Support for Your XBRL Software

Since these functions are specific to third-party reporting tools and not native to Excel, reaching out to the vendor and verifying the taxonomy is the most effective solution.

Functions with the 'xfi:' prefix (such as xfi:isQNameDimensionItem or xfi:getInstanceDB) are not built into Microsoft Excel. They belong to specialized XBRL add-ins or standalone reporting software used for financial data validation.

When these errors appear, it usually indicates that the add-in is outdated, missing components, or referencing an incorrect XBRL taxonomy.

Identify your XBRL software

Check your Excel ribbon to find the name of the XBRL add-in you are currently using (e.g., Altova, CoreFiling, or a regulator-provided tool).

Verify taxonomy and version

Open the add-in settings and ensure you have downloaded and applied the latest XBRL taxonomy required by your reporting authority.

Contact vendor support

Visit the official website of your XBRL software provider and submit a support ticket mentioning the specific 'xfi:' function errors.

XBRL Format Fact: XBRL is a standardized business reporting language, not a native Excel file extension. All generation and validation strictly rely on the third-party tool.

Solution 2

Verify and Re-enable the XBRL Add-in in Excel

Sometimes the add-in fails to load its custom functions properly. Re-enabling it can refresh the connection and clear the errors.

Free Microsoft Office alternative

A Lightweight, Highly Compatible Spreadsheet Alternative

While specialized XBRL generation requires specific vendor add-ins, WPS Office provides a completely free, highly compatible alternative for all your standard financial data preparation and Excel file management with zero learning curve.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
2. Install the software: Run the installer and follow the on-screen instructions to set up WPS Spreadsheet on your device.
3. Open financial spreadsheets: Launch WPS Spreadsheet and easily open your existing Excel workbooks to prepare your financial data seamlessly.

Seamless compatibility with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight and incredibly fast performance for large financial spreadsheetsFamiliar user interface ensuring a seamless migration for Office usersBuilt-in PDF conversion tools to easily share finalized financial reports

microsoft office alternative - wps office

Frequently Asked Questions

What are xfi functions in Excel?

Functions prefixed with 'xfi:' (like xfi:is-numeric or xfi:period) are custom functions introduced by XBRL validation add-ins. They are not built-in Excel formulas and will show as unknown errors if the corresponding add-in is not functioning correctly.

Why does Excel say an XBRL function is unknown?

Excel throws an 'unknown function' error because it does not natively understand XBRL validation rules. The error occurs when the third-party XBRL add-in is either disabled, outdated, or lacking the correct taxonomy schema to interpret those specific functions.

Can I open an XBRL file natively in Microsoft Excel?

No, XBRL files are typically XML-based documents. While you can open the raw XML code in Excel, reading and validating the financial data structured within it requires a dedicated XBRL reporting software or specialized Excel add-in.

How do I update my XBRL taxonomy?

Taxonomy updates are managed through your specific XBRL software. You typically need to download the latest taxonomy package from your local financial regulator's website and import it into your XBRL add-in's configuration settings.

Office Quick Solutions