Free · No signup · Runs in your browser

Clean number formatting in yourCSV

Strip currency symbols, thousands separators, and percent signs to get plain, math-ready numbers, without uploading a single row.

01 · How it works

Three steps, then done.

Pick the columns to clean (or let the tool auto-detect numeric-looking ones), choose whether percents become fractions, and run. Everything happens client-side in your browser.

1

Load your CSV

Drop in a file with prices, percentages, or any numbers wrapped in currency symbols, commas, or spaces. Your data stays in the browser and is never uploaded.

2

Choose columns and options

Select the columns to clean, or leave the picker empty to auto-detect columns that look numeric. Toggle percent-to-fraction if you want 50% to become 0.5 instead of 50.

3

Export plain numbers

Download a CSV where ,234.50 becomes 1234.5 and EUR 9,99 becomes 9.99. The tool reports how many cells it cleaned so you can verify the result.

02 · Why ours

Why clean number formattingbefore analysis

Spreadsheets love to dress numbers up with symbols and separators. Those decorations break sorting, summing, and importing. This tool strips them back to plain values.

  • 01

    Math actually works

    A value like ,234.50 is text to most tools, so sums and averages silently fail. Stripping it to 1234.5 makes every column a real number again.

  • 02

    Clean database imports

    Databases reject 'EUR 9,99' in a numeric column. Plain values import without type errors or manual find-and-replace passes.

  • 03

    Consistent decimals

    Mixed European and US formatting (1.234,50 vs 1,234.50) is normalized to a single decimal style, so the same column parses the same way everywhere.

  • 04

    Private by design

    Financial figures and revenue numbers never leave your machine. The whole transform runs in client-side JavaScript with no server round trip.

" ,234.50 is text to a spreadsheet. 1234.5 is a number you can actually add up."
Why formatted numbers break analysis
03 · FAQ

clean numbers questions.

Which currency symbols and separators are removed?
Common currency symbols ($, EUR, GBP, JPY, INR, and others), currency letter codes, percent signs, spaces, and thousands separators are stripped. The sign and decimal point are preserved.
When a value contains both commas and dots, the last separator is treated as the decimal point. So 1.234,50 becomes 1234.5 and 1,234.50 also becomes 1234.5. Single-separator values are interpreted using their position and length.
Off by default, the tool just removes the % sign so 50% becomes 50. Turn it on and 50% becomes 0.5, which is the correct decimal form for rate calculations.
Non-numeric values are left exactly as they were. The tool only rewrites cells it can confidently parse as a number after stripping formatting, so labels and notes stay intact.
No. The entire conversion runs locally in your browser using JavaScript. No rows are sent to any server, which makes it safe for financial and other sensitive data.
Related tools
CSV Validate
Check column types and flag rows that still contain non-numeric junk after cleaning.
Open →
CSV Profiler
See per-column stats and spot which columns carry currency or percent formatting.
Open →
CSV Sort & Filter
Sort and filter on the freshly cleaned numeric columns now that they parse as real numbers.
Open →
CSV Pipeline
Chain number cleaning with other transforms into one repeatable, client-side workflow.
Open →
CSV Dedupe
Remove duplicate rows once values are normalized to a consistent numeric format.
Open →