Spreadsheet tools Free · No sign-up · No upload

Convert Text to Numbers

Fix the green-triangle problem for a whole sheet at once. Text such as 1,250, 45% or $12.50 becomes a true number, and your file stays on your device.

  • Free, no sign-up
  • Files stay on your device
  • Handles %, currency, commas
  • IDs keep leading zeros
Choose spreadsheetsor drop them here · XLSX, XLS, ODS, CSV, XLSM
Sheet name or number (several: 1, 3). Leave empty for every sheet. Not used for CSV.
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: XLSX → OUT: XLSX
How was Convert numbers stored as text?
How it works

Convert numbers stored as text in three steps

No account, no email, no waiting for an upload.

  1. STEP 01

    Add your file

    Add the sheet or CSV you want to change. Keep the sheet box blank to cover all sheets.

  2. STEP 02

    Set the number style

    Choose point or comma as the decimal mark, whether to remove currency signs and whether to protect leading-zero IDs.

  3. STEP 03

    Download

    The note says how many cells became numbers.

What you get

What Convert numbers stored as text does, and what it doesn't

We'd rather tell you up front than surprise you after the download.

What you get

  • Many text stylesReads 1,234.56, 1.234,56, (1,234) as negative, -5, +5, 45% and values with $, €, £, ₹ and similar signs.
  • Percentages done right45% becomes 0.45 with a percent format in Excel, so it still looks like 45%.
  • Thousand separators shownValues written with grouping get a number format with thousands separators.
  • IDs protectedValues like 00123 or PIN codes stay as text unless you turn the protection off.
  • Formulas and dates untouchedOnly text cells are converted.

Good to know

  • Long numbers stay textNumbers with more than 15 significant digits are left alone, because spreadsheets cannot store them exactly.
  • CSV result is plain textA CSV has no number type. Converted values are written plainly, so 45% becomes 0.45 and 1,250 becomes 1250.
  • Pick the right decimal mark1.234 means different things in different countries. Choose the decimal mark that matches your data.
Private by design

Your spreadsheets never leave your device

The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.

Typical online tool upload

Your device→Their server→Your device

Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.

Mediaextractr no upload

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

When people use Convert numbers stored as text

Make SUM work again

Totals that show zero are usually text numbers.

Clean pasted prices

Remove currency signs from web-copied prices.

Handle European number styles

Convert 1.234,56 to a proper value.

Prepare data for import

Make numeric columns truly numeric before loading.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends on their servers

Why numbers turn into text

Data copied from websites, PDFs and exports often arrives as text. A leading apostrophe, a stray space, a currency symbol or a thousands separator is enough for Excel to treat the value as a word. The tell-tale signs are left alignment and a small green triangle in the cell corner.

Settings that matter

Set the decimal mark first. With point selected, 1,234.50 is 1234.5. With comma selected, 1.234,50 is 1234.5. Keep the leading-zero option on for codes and phone numbers.

If stray spaces are the problem, clean them first with Trim Excel whitespace. Remove unwanted words from cells with Find and replace spreadsheet values. Afterwards you can check the columns with Spreadsheet column statistics.

FAQ

Questions, answered

How do I convert text to numbers in Excel for a whole sheet?

Add the workbook, then download what comes out. All text that looks like a number is converted.

Does the file get uploaded to be converted?

No. The conversion is done in your browser.

Will leading zeros be lost?

Not by default. Values like 00123 stay as text. Turn that option off if you want them converted.

Does it understand percentages and currency?

Yes, 45% becomes 0.45 with a percent format, and currency signs can be stripped.

Does it work on CSV files?

Yes, but a CSV can only hold plain text, so numbers are written without formatting.

Does it run on Mac and mobile?

Yes, in current browsers.