How to use Number Column Formatter
- Paste a CSV table and enter the exact numeric column header.
- Choose the source number convention, output locale and decimal or currency settings.
- Inspect the changed-cell report and download the formatted CSV.
Example: Number Column Formatter
Format a decimal amount for English display.
Options
- Source separators
- Choose the decimal and grouping separators used in the numeric source column. A comma-delimited CSV value containing a comma must still be quoted correctly.
- Target locale, style and decimal places
- The locale controls output separators and grouping. Currency style adds the chosen currency label; it does not convert exchange rates. Only the named number column is formatted.
Supported inputs and limits
Where your input is processed
This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.
Parsing and display are separate decisions
The source convention determines how a value is read; the target locale determines how it is displayed. A source value with ambiguous separators can be refused. Formatting 1234.5 as en-US decimal with two places gives 1,234.50 without changing its numeric value.
Formatted text can need a new import convention
The exported column is display text. A later system must use a compatible locale to read it as numbers again. Other columns retain their values, apart from the selected formula protection. Preserve identifiers and leading zeroes rather than formatting every numeric-looking column.
Questions about Number Column Formatter
Will a formatted amount remain numeric in a spreadsheet?
A localized string may import as text depending on the spreadsheet’s settings. Keep the original file if you need raw numeric values.
Does the tool convert currency values?
No. A currency choice changes display formatting and the currency label; it does not fetch or apply an exchange rate.
Why do source separators need a separate choice?
The same punctuation can mean a decimal mark or a thousands separator. An explicit convention avoids guessing which value you intended.