PapiralPapiralPixelForgePixelForgeTabularTabular
TabularTabular
HomeCSV ToolsFormat Numbers

Format Numbers in CSV — Add Decimals, Currency & Commas

Standardize numeric columns: set decimal places, add thousands separators, prepend a currency symbol.

Pro feature

Upgrade to Pro to use the Format Numbers tool and process files up to 50 MB.

See Pro plans

What this tool does

Numeric data in CSVs is often inconsistently formatted — some rows have two decimal places, others have none; some have currency symbols, others don't. Tabular's number formatter standardizes selected columns to a consistent format: fixed decimal places, optional thousands commas, and an optional currency prefix like $ or €. Unparseable cells are left unchanged.

Problems it solves

  • Inconsistent decimal places across a price or amount column
  • Missing thousands separators in large number columns
  • Currency symbols mixed into some cells but not others
  • Raw numbers that need formatting before inclusion in a report
  • Normalizing financial data before importing into accounting software

Example

Prices formatted to 2 decimal places with thousands separator and $ prefix.

Before

ProductPrice
Widget1299.5
Gadget49
Doohickey12345.678

After

ProductPrice
Widget$1,299.50
Gadget$49.00
Doohickey$12,345.68

Frequently asked questions

What happens to cells that aren't numbers?

Non-numeric cells are left exactly as-is. Tabular only reformats values it can successfully parse as a number.

Can I strip '$' or '%' before formatting?

Yes. Enable 'Strip non-numeric characters first' and Tabular will remove $, %, and commas before parsing, then reformat the result.

Is this a Pro feature?

Yes. Number formatting is available on Pro and Business plans.

Can I format multiple columns at once?

Yes. Use the column selector to pick multiple columns — the same formatting rules apply to all selected columns.

Related tools

Find & Replace

Pro

Find any text in your CSV and replace it across an entire column or the whole file — bulk editing made easy.

Open tool

Format Dates

Pro

Convert inconsistent date formats in any column to a single consistent format — ISO, US, EU, or custom.

Open tool

Trim Whitespace

Strip leading and trailing spaces from every cell in your CSV or spreadsheet with one click.

Open tool