Skip to content
CSVTidy
Free tool

Clean and format numbers in a CSV.

Turn $1,234.50, (99.00), and 1.234,56 into consistent plain numbers ready for a database or a sum. Currency symbols and existing separators are stripped before reformatting, and accounting parentheses become proper negatives.

Everything runs in your browser. Nothing is uploaded.

Drop a CSV or Excel file here

Or choose a file — nothing leaves your browser.

Common questions

How does it handle European versus US formatting?

The last separator is treated as the decimal mark when one or two digits follow it, so both 1,234,567.89 and 1.234.567,89 read as 1234567.89.

What about a value like 2.500?

It is read as 2500. Three trailing digits with a single separator is far more often a thousands group than three decimal places, and treating dot and comma the same way keeps US and European input consistent.

What happens to cells that aren't numbers?

They are left exactly as they are. 'n/a' and blanks pass through untouched rather than becoming zero.

Is my file uploaded anywhere?

No. The file is parsed and processed entirely in your browser using JavaScript. It never leaves your device, and nothing is stored on our servers.