How to use Number Column Formatter
- Paste a CSV table with a header row and enter the exact numeric column name.
- Choose the source decimal and grouping marks, then the target locale, decimal places and plain-number or currency style.
- Run the formatter and review changed, blank and unparsed cells in the report. Invalid values stay as supplied.
- Download formatted-numbers.csv for the table and format-report.csv for the original/formatted comparison. Check the receiving application's import settings.
Example: Number Column Formatter
Format a decimal amount for English display.
Options
- CSV text
- The first line is the header row. The whole file must stay under 1 MiB and 5,000 data rows.
- Numeric column name
- The exact header name of the column to format. It must appear once.
- Target decimal separator
- Leave this on the target format unless the importing system expects one fixed decimal mark.
- Target thousands separator
- Leave this on the target format to keep the locale grouping, or remove grouping for a plain number.
- Currency
- Used only when the style is Currency.
- Guard spreadsheet formulas
- The number formatting CSV export can prefix formula-like source text, including after leading whitespace. This changes the stored text; review the downloaded cells before using them.
Supported inputs and limits
- CSV input is limited to 1 MiB and 5,000 data rows.
- Only the named column is formatted; blank or unparsed values stay as supplied and are reported separately.
- Decimal and currency styles change presentation, not exchange rates or the underlying currency.
- Accounting negatives are supported under the chosen source rules.
- Formula protection can prefix risky copied text in both downloads; generated numeric output keeps its sign.
More details
Review the files after importing them into a spreadsheet.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved 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.