Invoice Generator
Build a professional invoice in your browser and print, download or export it.
Invoice Data Cleaner
Clean a list of invoice data: whitespace, duplicates, dates, amounts and names.
Or drop a .csv file here
Quick Tool Overview
The Invoice Data Cleaner tidies exported invoice data before import — whitespace, invisible characters, mixed date formats, amounts with symbols, inconsistent supplier names and duplicate rows — and lists every single change it made.
- What it does
- Cleans invoice data for import
- You give it
- A CSV, TSV or pasted range
- You get back
- Clean data and a list of changes
- Best for
- Migrations and messy exports
About the Invoice Data Cleaner
Exported invoice data is dirty in predictable ways: trailing spaces that make two identical supplier names different, non-breaking spaces from a copied web page, dates in three formats in one column, amounts with currency symbols, the same invoice twice, and a supplier written four ways.
Paste or drop the data and choose what to fix. Whitespace is trimmed and invisible characters removed. Dates are recognised in whatever order they were written and rewritten in one. Amounts lose their symbols and separators. Supplier names are tidied for case and legal suffixes, and near-identical ones are grouped so you can see that Acme Ltd and ACME LIMITED are the same customer.
Every single change is listed, row by row, with the before and after — because a cleaner that silently rewrites financial data is a cleaner nobody should trust. Nothing is uploaded.
Key features of the Invoice Data Cleaner
Every change listed
Before and after, row by row.
Names grouped
Acme Ltd and ACME LIMITED, side by side.
Dates unified
Whatever order they were written in.
Duplicates found
On the columns you choose.
Rules optional
Turn off anything you do not want touched.
How to use the Invoice Data Cleaner
-
1
Paste or drop the data
A CSV, TSV or pasted spreadsheet range.
-
2
Choose what to clean
Whitespace, dates, amounts, names, duplicates.
-
3
Read every change
Before and after, row by row.
-
4
Download the clean file
Ready to import.
Frequently asked questions
No. Every change is listed with the original value beside the new one, and you can turn any of the rules off.
By comparing them with case, punctuation and legal suffixes removed. They are grouped for you to confirm rather than merged automatically.
An identical row, or one matching on the columns you choose — usually supplier, invoice number and amount.
No. It is cleaned in your browser.
Reviews of the Invoice Data Cleaner
What people who use the Invoice Data Cleaner think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
- 5 0 reviews rated 5 stars
- 4 0 reviews rated 4 stars
- 3 0 reviews rated 3 stars
- 2 0 reviews rated 2 stars
- 1 0 reviews rated 1 star
0 reviews
Newest first
No reviews yet
Be the first to rate the Invoice Data Cleaner. It takes half a minute and no account.
Write the first reviewMore invoice tools
Electrical Invoice Generator
Labour, materials, testing and certificate references on an electrician’s invoice.
Proforma Invoice Generator
A quotation in invoice form — what it will cost, before you commit to supplying it.
Invoice Adjustment Calculator
Work out what a credit or debit note should be when an invoice needs correcting.
Invoice Discount Calculator
Work out a discount, what it costs you, and whether the customer should take it.
Invoice Debit Note Generator
A debit note for an under-billing, with the reason and the tax on the addition.
Invoice Generator with Stripe
An invoice with a Stripe Payment Link that carries the invoice number back to you.
Debit Invoice
Charge more against an invoice already issued, with the reason recorded.