// troubleshooting guide · datawrapper
Datawrapper Not Recognizing Numbers or Dates
- Status
- Workaround available
- platforms:
- Web
- updated:
- November 16, 2026
- reports:
- 2
- Method
- how we research
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
FIX 1Clean the sheet before upload
- 01Delete everything above the header row
- 02Unmerge cells and keep a single header row
- 03Remove thousands separators and footnote markers
- 04Move units into the column name and add them back as prefix/suffix later
Did this fix it?FIX 2Fix dates
- 01Compare dates with Datawrapper's list of recognized date formats
- 02Re-format them, then confirm the date column shows as a date (green) in step 2
Did this fix it?FIX 3Reshape the data
- 01Convert long data to wide with a pivot table in Excel or Google Sheets
- 02If series are in rows instead of columns, use Transpose in step 2
Did this fix it?FIX 4Re-upload and check
- 01Paste or upload the cleaned data
- 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 usOther Datawrapper errors
- Datawrapper Embedded Chart Cut Off or Too Much Space
- Datawrapper Google Sheets Chart Not Updating
- Datawrapper Embed Not Showing Latest Changes
- Datawrapper Map Regions Not Matching Data
- Datawrapper Custom Map Upload Not Working
- Datawrapper Locator Map Not Exporting
- Datawrapper Export PDF or SVG Not Available
- Datawrapper Embed Shows 404 Not Found