CSV Cleaner

Trailing minus in a CSV: turn 12.50- into a negative amount

Some accounting and banking systems write a negative amount with the minus sign at the end: 12.50- instead of -12.50. Many importers read that as text. Choose the file below: the page works in your browser, moves the sign to the front, shows the first 20 cleaned rows and lists every line it left out, with the reason.

Clean your CSV export

The cleaner detects the delimiter (comma, semicolon or tab), looks for a header row with a date column and an amount column, and writes eight fixed columns, comma-delimited: date, description, amount, currency, fee, net, reference and source. It recognises common header names in English, Spanish, German and French, such as Date, Fecha, Buchungstag, Amount, Importe, Betrag and Montant.

Your file is read in your browser and is never uploaded, stored or logged. It is held in the memory of this tab only, and closing or reloading the page discards it. Operator: Augeo. See the privacy notice.

Exports do not share one layout, and this page makes no promise about yours: the free preview shows what it does to your file.

The cleaning logic is checked by an automated test script that runs the engine file of this site over six synthetic sample files and a set of checks of the parsing rules; it ran in a sandbox before this site was published and finished with no failed check. The script does not open this page in a browser, does not test the licence key step, and nothing was tested against a real export from any provider. Use the free preview to check your own file.

Download the full cleaned file

  • Price: 6 USD, paid once on Gumroad. No subscription. You receive a licence key.
  • What the key unlocks: the download of every cleaned row of the file you chose, as one CSV named after your file with -cleaned.csv at the end, instead of the first 20 rows on screen. The report and the way files are read stay the same.
  • The key is for one buyer. Runs are not counted and no number of runs is promised. The key is kept in the memory of this page only, so you enter it again after closing or reloading the page.
  • Refunds are requested through your Gumroad receipt and follow Gumroad's refund policy.
  • Try the free preview first. If the preview cannot read your file, the full download cannot either.

Get a licence key on Gumroad for 6 USD

How a trailing minus is read

Amounts in a file read with a decimal point
In the exportamount in the cleaned file
12.50--12.50
1,250.00--1250.00
$45.10--45.10
0.00-0.00
(182.40)-182.40
-12.50-row left out: amount is not a number

In a decimal-comma file the same rule applies: 45,90- becomes -45.90. The report shows which separator was found in its "Decimal separator" line.

The output is always the same eight columns (date, description, amount, currency, fee, net, reference and source). In a file with separate debit and credit columns, the two are merged into one signed amount, and a debit is written as negative whichever way its sign is given.

Notices

Other pages