Import Cleaner for Xero
Xero exports that work in Google Sheets™, uploads that do not fail. Free to check. Knows it's a Xero file. Dates that sort, amounts that sum, contact names that match — and uploads checked against Xero's import rules before they fail.
Install: Install from Google Workspace Marketplace, or Extensions › Add-ons › Get add-ons, search for “Import Cleaner for Xero”. It is an editor add-on for Google Sheets™ on desktop browsers — it does not run in the Google Sheets™ mobile apps.
Before
Text
Dates Sheets cannot sort, amounts that refuse to sum, and a contact name carrying a stray space.
After
Clean
Same data, the fixes applied with a preview first. Undo is always there if you change your mind.
The one to know about
A contact name that nearly matches — Acme Ltd against
Acme Ltd. — does not fail a Xero import. It creates a duplicate contact
in a live ledger. The check that catches those before upload is the reason this add-on
exists.
Three steps
- Install. Get it on Google Workspace Marketplace, or Extensions › Add-ons › Get add-ons and search for the name.
- Scan. Open a spreadsheet, then Extensions › Import Cleaner for Xero › Open. Pick Clean a Xero export or Check before uploading.
- Fix. Every finding explains what is wrong and why it matters in Xero's terms. The safe ones have a one-click or guided fix, with a preview of the exact cell changes before anything is applied — and every ambiguous date listed before the write, never after it.
What it checks
Every finding carries a rule code, so a report you read again in six months still says which check produced which line.
XE-01 | Dates stored as text, with the ambiguity report |
XE-02 | Numbers stored as text |
XE-03 | Parenthesised negatives |
XE-04 | Stray spaces, including non-breaking ones |
XE-05 | Names to split or join, into new columns |
XE-06 | Comma decimal separators |
XE-07 | Trailing blank rows or a total row below the data |
XE-08 | Not a Sheets Table — convert by hand |
XI-01 | Required columns missing for the import type |
XI-02 | Header spelling or casing Xero will not match |
XI-03 | Dates not in the organisation's regional format |
XI-04 | Bank statement sign convention and Debit/Credit splits |
XI-05 | Decimal separator not a period |
XI-06 | Currency symbols or thousands separators in amounts |
XI-07 | Blank cells that import as zero |
XI-08 | Contact names that will not match |
XI-09 | Line breaks inside cells, and mojibake |
XI-10 | Field length overruns |
See the guide for what each rule means and why it matters in Xero's terms. Not affiliated with, endorsed by or sponsored by Xero Limited.
Free vs Pro
Free
£0
- Unlimited scans and explanations, both directions
- The ambiguity report
- The space fix, applied
- Undo — always, in every tier
Pro
£39 per year, or £4 a month
- Everything in Free
- Every other fix, one-click and guided, with a preview
- Saved settings per import type
- An exportable report, written to its own tab
- 3 activations shared across Excel and Google Sheets™
Your data
Your spreadsheet content never leaves Google. The rules run in the sidebar, in your browser. The only network traffic this add-on makes is to the licence server, and only a licence key, an anonymous install id and which host this is ever cross it. The add-on asks for this spreadsheet only — not your Drive, not your other files. Privacy notice.
FAQ
Does my data leave Google? No. Scanning and fixing both happen in the sidebar, against the Sheets API, without your content going anywhere else.
How should I import a Xero CSV? File › Import › Upload, with “Convert text to numbers, dates and formulas” unticked, so dates arrive as text the scan can read.
What if I want to undo a fix? Every fix saves a hidden copy of the sheet first. Press Undo in the sidebar to restore it, in any tier, at any time.
Is there an Excel version? Yes: the Excel add-in runs the same checks, and the same key works in both. Using Excel? The same key works there.
Is this affiliated with Xero? No. It is an independent add-on by AppGarden, not affiliated with, endorsed by or sponsored by Xero Limited.
Support
Email support@appgarden.co.uk. Say which host (Excel or Google Sheets™) and include which finding looked wrong and, if you can share it, a copy of the sheet with the problem — read the privacy notice first.
Articles
- Xero™ export dates wrong in Google Sheets™
- How to import a Xero™ CSV into Google Sheets™ without breaking dates
- Xero™ bank statement import failed: check your sheet first
- Xero™ import created duplicate contacts
- Numbers from Xero™ won't sum in Google Sheets™
Google, Google Sheets™ and Google Workspace™ are trademarks of Google LLC. Not affiliated with, endorsed by or sponsored by Xero Limited. Xero is a trademark of Xero Limited. Import Cleaner for Xero is not affiliated with or endorsed by Google.