// troubleshooting guide · datawrapper

Datawrapper Not Recognizing Numbers or Dates

Status
Workaround available
platforms:
Web
updated:
November 16, 2026
reports:
2
Method
how we research
Share

RUNBOOK · datawrapper/data-not-recognized4 FIXES

// quick answer

Symbols, separators, footnotes, merged headers or extra rows turn number columns into text. Clean the data so each cell holds only a plain number and there is one header row.

Most likely fix: Clean the sheet before upload

How to fix it

// try these in order, the most common fix is first

  1. FIX 1Clean the sheet before upload

    1. 01Delete everything above the header row
    2. 02Unmerge cells and keep a single header row
    3. 03Remove thousands separators and footnote markers
    4. 04Move units into the column name and add them back as prefix/suffix later
    Did this fix it?
  2. FIX 2Fix dates

    1. 01Compare dates with Datawrapper's list of recognized date formats
    2. 02Re-format them, then confirm the date column shows as a date (green) in step 2
    Did this fix it?
  3. FIX 3Reshape the data

    1. 01Convert long data to wide with a pivot table in Excel or Google Sheets
    2. 02If series are in rows instead of columns, use Transpose in step 2
    Did this fix it?
  4. FIX 4Re-upload and check

    1. 01Paste or upload the cleaned data
    2. 02In step 2 confirm numeric columns are recognized before going to Visualize
    Did this fix it?

Symptoms

Columns show as text instead of numbers, the chart is empty or wrong, date axes have no nice intervals, or empty cells appear as 0 in tooltips.

Why it happens

  • C-01Currency, percent or unit symbols inside cells
  • C-02Thousands separators (commas, periods or spaces)
  • C-03Footnote markers next to values
  • C-04Titles or notes above the header row
  • C-05Merged cells or two-row headers
  • C-06Dates in an unrecognized format
  • C-07Long-format data (one value per row)

// this guide also covers

  • datawrapper numbers not recognized
  • datawrapper data wrong
  • datawrapper csv upload problem
  • datawrapper dates not recognized

Still not working?

If Datawrapper keeps failing, you're not alone. See every Datawrapper problem users report or the alternatives people switch to.

Have an app idea? Our small team builds any software: web and mobile apps, games, desktop, AI tools. Price agreed together.

Talk to us

Watch Datawrapper Get an email when its price changes, it has an outage, or we publish a new fix. No spam.

Fixed it? Share this guide

Other Datawrapper errors

All 12 Datawrapper errors and fixes →