Convert Text to Numbers in Excel Online — Free, No Upload, 1 Click

How to Convert Text to Numbers in Excel Online

1. Drop one .xlsx, .xlsm, or .xls workbook — parsing and converting both run locally in your browser; the file is never uploaded.
2. Pick the thousands separator used in the file: comma (1,234.56, the default), dot (1.234,56), or none for plain integers and decimals with no grouping.
3. Keep “Convert percent values” on when cells such as 50% should become 0.5, then click Convert to numbers.
4. Review the per-sheet report — converted cells become real numbers, and anything that cannot be parsed is counted as unparsed.
5. Download the result as your-file-name-as-numbers.xlsx.

Conversion Rules: What Text Becomes What Number

Leading and trailing spaces are removed first, so “ 42 ” becomes 42. Currency markers are always stripped automatically with no separate switch, and every rule is applied in order before the value is tested as a number.

Why Do Numbers Become Text in Excel?

• CSV and text imports: when Excel cannot confidently guess a column’s locale — mixed grouping, currency signs, or percent marks — it imports the whole column as text.
• A leading apostrophe: typing ‘123 forces the cell to text. The apostrophe is hidden, but the value stays left-aligned.
• Leading or trailing spaces (including the invisible NBSP copied from web pages) make Excel treat “123 ” as text.
• Exports from databases, ERPs, and banking sites often write amounts on purpose as formatted text strings.

The two classic symptoms are a small green triangle in the cell corner carrying a “Number stored as text” warning, and values that hug the left edge of the cell even though they look numeric. SUM and AVERAGE silently skip such cells, VLOOKUP and XLOOKUP fail to match them, and charts show gaps where they appear.

What Stays Unconverted

A cell is rewritten only when its text parses to a finite number under the rules above. Everything else — product codes like 12A, headings, phone numbers, mixed text — is kept exactly as-is and counted in the unparsed column of the report, so nothing is ever destroyed. Date serial numbers are never guessed: a date or date-like text is not converted to a number, because there is no safe way to tell 45292 (a date serial) from a genuine six-digit code. Cells that already contain numbers, booleans, dates, or blanks are never touched.

Limitations

• The output is a value-level .xlsx rebuilt from your data: cell styles, column widths, merged cells, and charts are simplified.
• Pick the separator mode that matches the file — in Dot mode the comma is the decimal mark, and in Comma mode the dot is.
• Encrypted workbooks (password required to open) cannot be read.
• Legacy .xls files are supported, but are converted to .xlsx on output.