// troubleshooting guide · flourish
Flourish Not Recognizing Numbers or Dates
- Status
- Workaround available
- platforms:
- Web
- updated:
- November 16, 2026
- reports:
- 2
- Method
- how we research
RUNBOOK · flourish/numbers-dates-not-recognized4 FIXES
// quick answer
Flourish auto-detects column types and decimal separators and sometimes gets them wrong. Override the input format on the column in the Data tab; translate non-English month names first.
Most likely fix: Change the number input format
How to fix it
// try these in order, the most common fix is first
FIX 1Change the number input format
- 01Open the Data tab
- 02Click the data-type icon at the top of the column
- 03Choose the correct decimal/thousands separator format
Did this fix it?FIX 2Set the date format manually
- 01Click the column's data-type icon
- 02Pick the matching date format, or type a custom one in d3-time-format syntax (e.g. %d %B %Y)
Did this fix it?FIX 3Translate month names
- 01Convert non-English month names to English or numeric dates in your spreadsheet before uploading
Did this fix it?FIX 4Override the column type
- 01Switch the column type (text, number, date) in the Data tab when Flourish guesses wrong
Did this fix it?
SANDBOX · flourish RUNS IN YOUR BROWSER
Try it: design and hand off a screen
A hands-on Flourish-style sandbox, including the spots where users get stuck. See where problems like this one start. 1-2 minutes, nothing is saved.
Symptoms
Numbers appear as text, values are wrong by a factor of 1,000, or dates show as text or in the wrong order.
Why it happens
- C-01Comma used as decimal separator (or as thousands separator) detected wrongly
- C-02Month names in a language other than English
- C-03Years detected as dates or numbers instead of text
- C-04The template doesn't support automatic data typing
// this guide also covers
- flourish date format
- flourish number format
- flourish decimal comma
- flourish data not showing
Still not working?
If Flourish keeps failing, you're not alone. See every Flourish 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 Flourish errors
- Flourish Embed Cut Off or Wrong Height
- Flourish Chart Not Showing When Embedded
- Flourish Embed Not Showing Latest Changes
- Flourish Google Sheets Data Not Updating
- How to Remove "Made with Flourish" From Embeds
- Flourish Download Video Not Available or Failing
- Flourish Map Regions Not Showing or Not Matching
- Flourish App in Canva Asking to Upgrade