Convert decimal commas to decimal points in a CSV of transactions

Exports made with a European locale write amounts with a decimal comma, such as 1.234,56 or 12,5. Software that expects a decimal point reads them as text, or as a different number. Choose the file below: the page works in your browser, rewrites the amounts with a decimal point, 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.

Choose a CSV 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

Licence key

How decimal commas are read

The decimal separator is taken from the amounts of the file. The cleaner looks at every value of the amount, debit, credit, fee and net columns. A value with both separators counts for the one that comes last: 1.234,56 counts for the comma. A value with one separator counts for that separator, unless exactly three digits follow it and the number does not start with a zero. When more values count for the comma than for the point, the file is read as a decimal-comma file. The report states the result in its "Decimal separator" line.
Amounts are written as plain decimals with a point. 1.234,56 becomes 1234.56, 12,5 becomes 12.50 and 0,5 becomes 0.50. Thousands separators are removed, a value with fewer than two decimals is padded to two, and longer decimals are kept as they are.
A single point followed by three digits is a thousands separator in a decimal-comma file. 1.234 becomes 1234.00. In the same file 1,234 becomes 1.234, because the comma is the decimal separator.
Spaces and apostrophes between digits are removed. 1 234,56 becomes 1234.56.
The sign is kept. -45,90 and 45,90- both become -45.90.
Currency signs and codes are taken out of the number. In 12,50 EUR the amount becomes 12.50, and EUR goes to the currency column when the row has no value in a currency column of its own. Amounts are never converted between currencies.
The digits are moved as text. The amount is rewritten character by character and is not passed through a floating-point number.
A value that is not a number is not turned into zero. The row is left out of the output and listed under "Lines not parsed" with its line number and the text found.

One case cannot be settled from the file: when the only separators in the amounts are single ones followed by exactly three digits, such as 1,234 or 1.234, nothing shows which one is the decimal separator. The cleaner then reads the file as a decimal-point file, so 1,234 becomes 1234.00, and says so in a warning. The page has no control to set the decimal separator yourself, so read the warning and the preview.

Decimal-comma files usually put a semicolon between columns; the cleaner detects the delimiter and writes the output with commas. In a comma-delimited file, an amount with a decimal comma has to be inside double quotes in the input to stay one field.

The output is always the same eight columns (date, description, amount, currency, fee, net, reference and source). Columns of your file that are not among them are not carried over, so this is a cleaner for files of transactions and not a general CSV editor.

In a spreadsheet instead: import a copy of the file with the locale of the country it came from, so the amounts arrive as numbers, then switch the locale of the sheet to one that uses a decimal point and save as CSV.

Notices

Privacy: files are read in your browser and never uploaded, stored or logged. Operator: Augeo.
Independent tool, not affiliated with or endorsed by Etsy, PayPal, QuickBooks or any bank.
Check the output before you use it. This is not accounting, tax or financial advice.
Price of the full download: 6 USD one-time. The key is for one buyer. Refunds are requested through the Gumroad receipt.
Only upload data you have the right to process. Choosing a file here does not send it anywhere, but you remain responsible for the data in it.

Convert decimal commas to decimal points in a CSV of transactions

Clean your CSV export

Report

Warnings

Lines not parsed

Lines dropped

Preview of the cleaned rows

Download the full cleaned file

How decimal commas are read

Notices

Other pages