Add Commas to Numbers

Format numbers with thousands separators — clean, consistent, instant

A raw number like 1234567 is hard to read. Format it as 1,234,567 and you can tell at a glance that it is roughly 1.2 million. Thousands separators are one of the simplest visual aids in numeric presentation, and yet adding them by hand to a column of figures is slow and error-prone. This Add Commas to Numbers tool inserts the separator of your choice (comma, period, space, apostrophe) into every number it finds in your input — preserving everything else exactly as it was.

How to use it

Drop your raw number column or financial figures into the editor. Choose your separator: comma (the English-language standard, e.g. 1,234,567), period (used in many European countries, e.g. 1.234.567), space (the SI scientific standard, e.g. 1 234 567), or apostrophe (the Swiss convention, e.g. 1'234'567). Choose whether decimals should be preserved exactly or also formatted. Click Apply. The output is your text with every number cleanly separated.

Why thousands separators matter

Human number perception breaks down past about four digits. Without separators, you have to count digits to know if "10000000" is ten million or one hundred million. With separators, "10,000,000" is instantly readable as ten million. This is why every typeset book, financial statement, and government report uses them. The only contexts where you would not use a separator are computer source code (where it would be a syntax error) and certain identifier fields (phone numbers, account numbers, ZIP codes — where the digits do not represent a quantity).

Regional conventions

Different countries use different separators, and the choice matters when communicating internationally. Most English-speaking countries (US, UK, Canada, Australia) use commas for thousands and periods for decimals: 1,234,567.89. Most of continental Europe (Germany, France, Spain, Italy, the Netherlands, much of Latin America) does the opposite: 1.234.567,89. Some countries — notably Switzerland and France in scientific contexts — use spaces for thousands (1 234 567,89 or 1 234 567.89). The International System of Units (SI) recommends thin spaces, not commas or periods, for thousands separators in scientific publications. The Swiss often use an apostrophe (1'234'567). This tool supports all four common separators so you can format for any audience.

Real-world uses

Financial reports. Revenue, expenses, and balance figures in a report should always be formatted with thousands separators for readability. Pasting a column of raw numbers from a database export and formatting them in one pass is faster than configuring Excel cell formatting.

Population statistics. Numbers like 1,400,000,000 (China's population) are far easier to read than 1400000000. Stripping the separators when needed and adding them when needed is a two-direction conversion this tool handles.

Data journalism. When a journalist pulls raw figures from a government dataset and prepares them for publication, formatting them with separators is a non-negotiable step before they go into copy.

Scientific writing. SI guidelines recommend space-separated thousands in published papers, with no separator for four-digit numbers (so "1234" but "12 345"). This tool can be configured to follow that convention.

Spreadsheet preparation. If you are pasting data into a spreadsheet that does not auto-format numbers, pre-formatting them as text with separators makes them human-readable from the moment they appear.

Localising content. If you have content written for an English-speaking audience and you are localising it for German or French readers, the thousands separator needs to be swapped from comma to period (or to space). Find & Replace can do this if your numbers are isolated, but for mixed text this tool is more precise.

What the tool does and does not touch

The tool only formats numbers it recognises as such — sequences of digits that look like numeric values. It preserves decimal points (or commas) correctly: a number like 1234.5 becomes 1,234.5, not 1,234,.5. It does not modify dates, phone numbers, ZIP codes, or other digit sequences that should not have separators. If your input is ambiguous, double-check the output before using it.

Negative numbers and numbers with leading signs (+/-) are handled correctly: -1234567 becomes -1,234,567. Scientific notation (1.5e10) is left alone, since adding separators to scientific notation would be incorrect.

Privacy

All number formatting runs in your browser. Your data — whatever sensitive figures it contains — never leaves your computer. Safe for financial reports, internal metrics, customer-level data, or anything else that should not sit on a third-party server.