Excel to iXBRL: How to Convert Spreadsheets into Compliant Accounts
Why Convert Excel to iXBRL?
Most accountants prepare accounts in Excel. But HMRC and Companies House require iXBRL. Converting Excel to iXBRL saves you from re-typing everything.
What Is Excel to iXBRL Conversion?
It’s the process of mapping each Excel cell (e.g., “Turnover”) to an XBRL tag (e.g., uk-core:TurnoverRevenue). The software then generates an iXBRL file ready for filing.
3 Ways to Convert Excel to iXBRL
Method 1: Dedicated Excel-to-iXBRL Add-in
QuickXBRL and DigiAccounts offer Excel plugins. You tag cells directly inside Excel.
Method 2: Upload Excel to Web Software
Upload your Excel file to a platform like Taxfiler. The software auto-detects numbers and asks you to confirm tags.
Method 3: Manual iXBRL Tagging Software
You re-enter numbers into a tagging interface. More work but very accurate.
Best Excel to iXBRL Tools
| Tool | Excel Plugin? | Auto-Tagging |
|---|---|---|
| QuickXBRL | Yes | Yes |
| IRIS | Yes | Partial |
| Taxfiler | No (upload) | Yes |
| Arelle (free) | No | No (manual) |
Step-by-Step: Excel to iXBRL with QuickXBRL
- Open your Excel file
- Click “Convert to iXBRL”
- Review auto-suggested tags
- Fix any red errors
- Export iXBRL
- Validate before filing
Common Excel to iXBRL Mistakes
- Leaving blank rows – can confuse tagging
- Using merged cells – tags may attach incorrectly
- Forcing the wrong taxonomy – use FRS 102 for UK small companies
- Not tagging comparative year – both years must be tagged
FAQ
A: Arelle is free but requires manual tagging. Most professional tools cost £50–£200/year.
A: Yes, good software preserves fonts, bold, italics, and table layout.
A: 15 minutes for a small company with auto-tagging.