// troubleshooting guide · flourish

Flourish Not Recognizing Numbers or Dates

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

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

  1. FIX 1Change the number input format

    1. 01Open the Data tab
    2. 02Click the data-type icon at the top of the column
    3. 03Choose the correct decimal/thousands separator format
    Did this fix it?
  2. FIX 2Set the date format manually

    1. 01Click the column's data-type icon
    2. 02Pick the matching date format, or type a custom one in d3-time-format syntax (e.g. %d %B %Y)
    Did this fix it?
  3. FIX 3Translate month names

    1. 01Convert non-English month names to English or numeric dates in your spreadsheet before uploading
    Did this fix it?
  4. FIX 4Override the column type

    1. 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 us

Watch Flourish 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 Flourish errors

All 10 Flourish errors and fixes →