Number Column Formatter

Format one CSV number column with decimal or currency display settings.

On-device No sign-up Free to use

Format number column controls

Showing an example. Edit to see your own.

?

The first line is the header row. The whole file must stay under 1 MiB and 5,000 data rows.

?

The exact header name of the column to format. It must appear once.

?

Leave this on the target format unless the importing system expects one fixed decimal mark.

?

Leave this on the target format to keep the locale grouping, or remove grouping for a plain number.

?

Used only when the style is Currency.

?

Adds an apostrophe in front of copied cells that a spreadsheet could run as a formula. The formatted number column is never prefixed, because a leading minus is just a sign.

More options

Processed in your browser. Your inputs stay on this device.

Result

Showing an example.

Format a decimal amount for English display.

The amount is displayed as 1,234.50. The item value A stays unchanged.

Loading the tool. Your result will appear here.

https://usefreetools.net/number-column-formatter · 20 November 2026

Was this helpful?

How to use Number Column Formatter

  1. Paste a CSV table with a header row and enter the exact numeric column name.
  2. Choose the source decimal and grouping marks, then the target locale, decimal places and plain-number or currency style.
  3. Run the formatter and review changed, blank and unparsed cells in the report. Invalid values stay as supplied.
  4. 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.

You add
CSV: item,amount followed by A,1234.5. Column: amount. Output: en-US decimal with 2 places.
You get
The amount is displayed as 1,234.50. The item value A stays unchanged.

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.

Page updated · Project managed by Tony Hines · Report a problem with Number Column Formatter