Localized Report Formatter
Format numbers and prices in a CSV or JSON table for different regions. Check errors and download your finished report.
How do I format numbers in a CSV report?
Open a CSV or JSON table. Choose each number column and set its input and display formats. Preview the report and check any errors. Download the formatted table or save a project to use the same settings later.
Your report, in the right format.
Choose column formats, review the result and keep the original values. Reports are processed on this device.
Import a CSV or JSON table
CSV keeps cells as text. JSON numbers use their parsed value; quote precise decimals and large integers. Only selected columns are formatted.
Give each column its own format.
Rounding, grouping and signs
halfExpand rounds ties away from zero; halfEven rounds ties to the even digit. ceil and floor round toward positive and negative infinity. trunc rounds toward zero; expand rounds away from zero. Increments use the last decimal place: 5 with two fixed places rounds to 0.05. Increment rounding needs equal minimum and maximum decimal places.
3 of 4 columns have formats. Empty cells stay empty. Each invalid cell is kept unchanged and reported.
Original table
4 rows
| Row | Office | Revenue | Growth | Visits |
|---|---|---|---|---|
| 1 | Toronto | 1234567.895 | 0.1234 | 9007199254740993 |
| 2 | Montréal | 987654.125 | -0.0456 | 10240 |
| 3 | Vancouver | 25000 | 0 | 4800 |
| 4 | Ottawa | pending | 1200 |
50 rows per page. Downloads include the complete report, regardless of this preview filter.
Your report stays in this session. Download a project to resume later.
Three simple steps
How to use Localized Report Formatter
Choose your input number format, then select a display locale and style.
Adjust digits, rounding and signs. Review original values and any invalid cells.
Copy the preview or export the complete report. Keep a project backup before leaving.
Common questions
Good to know
Understand the result.
Keep the original.
Is this tool free, and are my files uploaded?
This tool is free with no account required. The work happens in your browser. Your input and files are not sent to a processing server.
What are the limits and details?
Display formatting only; no currency or unit conversion. Decimal strings retain their exact input digits before display rounding; JSON numbers may already have floating-point rounding, so quote precise values. Up to 200 input digits, 300 characters per numeric cell and exponents/magnitudes between −300 and 300. Canonical input uses a decimal point without grouping; localized input uses the selected locale’s digits and decimal/thousands separators. Currency symbols, percent signs and accounting parentheses are not accepted as numeric input. Decimal-place precision supports 0–20 places; significant precision supports 1–21 digits. Output depends on the browser’s locale data and requires exact-string and rounding-option support. Report imports support 5,000 rows, 30 columns and 1.5 million characters; formatted results support 6 million characters. Empty values remain empty and invalid values remain unchanged, with explicit export acknowledgement. CSV prefixes formula-like text; optional spreadsheet-text mode prefixes every nonempty data cell. CSV loses JSON types and null/empty distinctions; retain the JSON report or project backup. Data stays in this browser session; download a project to resume later.