Number Formatter
Clean currency, decimals, percentages and thousand separators.
Convert text that looks numeric — “$1,234.50”, “(500)”, “45%” — into real numbers, then apply a consistent display format across the column. Handles European decimal commas and accounting-style negative parentheses.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Strips currency symbols, spaces and thousand separators before parsing
- Accounting negatives in parentheses parsed to real negative numbers
- Rounding with configurable decimals and half-up or banker’s rules
How to use Number Formatter
- 1
Upload the file and select the numeric columns.
- 2
Set the input convention — decimal point or comma, and how negatives are written.
- 3
Choose the output format: plain, currency, percentage or accounting.
- 4
Apply and download.
Watch a walkthrough
Common problems and fixes
Values still show as text after formatting.
They contain a character the parser did not recognise, often a non-breaking space. Run the Data Cleaner first, then re-format.
Large IDs are converted to scientific notation.
Exclude that column and mark it as text — identifiers should not be numbers. The type override is in the column editor.
Frequently asked questions
More clean & format tools
Remove duplicates, trim whitespace, fix inconsistent dates and numbers, split or merge columns, and validate data quality before it reaches your reports.
Browse Clean & Format