Excel tool

Convert Text to Numbers

Convert text amounts to numeric values in chosen columns without guessing their regional separators.

Private by designRuns in your browser
Recent tools
Ctrl / ⌘ + Enter to run

Loading workspace…

Preparing the controls for this tool. Your files have not been selected or uploaded.
QUICK START

How to use Convert Text to Numbers

  1. Upload XLSX or CSV, inspect the workbook and choose a sheet with a header row.
  2. Enter one-based column numbers and select thousands and decimal separators. They must be different.
  3. Process, review skipped-cell warnings and download the XLSX values.
BEFORE YOU BEGIN

What to expect

Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.

Local processing

Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.

Separator example

With comma thousands and dot decimal selected, the text 1,234.50 becomes the number 1234.5. With space thousands and comma decimal, 1 234,50 is parsed using the chosen convention.

Precision and identifiers

Invalid numeric text, malformed grouping and strings exceeding 15 digits of precision remain unchanged and are reported. Converting 00123 to a number removes the leading zeros. Keep account numbers, SKUs and other identifiers as text even when they contain only digits.

HELP & TROUBLESHOOTING

Frequently asked questions

Will currency symbols be removed?

No. Values that do not match the supported numeric syntax are skipped. Clean currency labels deliberately before converting.

Why are long numbers left unchanged?

The guard avoids silently converting long digit strings to imprecise JavaScript numbers. Treat long identifiers as text.

Where is my input processed?

Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.