Normalize decimal and grouping separators in numbers
The values 1,234 and 1.234 can represent different numbers under different source conventions. Identify decimal and grouping separators before removing punctuation or interpreting the amounts.

How to use this tool
- Add the spreadsheet and name its numeric columns.
- Choose the source dot or comma decimal convention.
- Run the task and compare normalized and unresolved values, including decimals and negative amounts.
- Download the spreadsheet and report.
Choose the right settings
Specify the numeric columns and choose whether the source uses a dot or comma for decimals. Separate records with mixed conventions before applying one interpretation to all values in a column.
- Supported input
- CSV,TSV,XLSX
- Available settings
- Number columns
- Decimal delimiter
Before you start
Establish the meaning of the input
Before converting or arranging data, identify what a row or value represents and keep a source copy. In tabular files, review headers, separators and text encoding; in structured files, inspect the required object or array shape. Identifiers, dates and amounts should not be interpreted solely from how a spreadsheet happens to display them.
Where the tool offers matching columns, type rules or output fields, choose them according to the destination’s requirements. Test a sample with a blank, a repeated value and a value containing punctuation. For labels, charts or personalized documents, check which column supplies each displayed value and whether the source units and wording are correct.
Define a few checks before processing: an identifier that must retain its spelling, a value with a known interpretation and an expected relationship between records. If the tool offers type conversion or matching rules, distinguish a source value from the program’s display of it. Test ambiguous dates or differently written keys before accepting a broad rule. Keep the chosen rules and destination requirements with the result; this makes a discrepancy traceable to input, interpretation or the requested transformation.
Verify values, structure and exceptions
Reopen or import the result using the destination’s settings. Compare headers, record counts and several values with the source, allowing for the operation you requested. A summary, split or duplicate-removal task can legitimately change the count; verify why it changed rather than expecting every transformation to keep identical rows.
Inspect any exception or validation report before continuing. If columns shift, characters are garbled or a key is not found, check delimiters, encoding and exact header spelling first. Encoding data does not encrypt it, and formatting a value does not confirm its meaning. For printed codes or labels, test the actual output before making the full set.
Example input and output
1.234,5 + decimal comma → 1234.5Examples describe the workflow. Results depend on the source file and settings.
Check the saved result before using it
Compare decimal amounts, large values and negative records with their original meanings after conversion. Review unresolved entries separately so unchanged source values are not mistaken for successfully normalized numbers.
If the result is different from what you expected
Currency symbols or malformed digit grouping leave records unresolved for review rather than being silently guessed. Check the decimal convention and remove only wording or symbols whose meaning you understand.
Limits to keep in mind
- Decimal/grouping separators are checked strictly. Currency symbols are reported as unresolved.
Continue with a related tool
This guide explains the public browser tool. Keep a copy of the original and inspect the result before sharing it.