Issue Station
Sign In
Tools hereToolbox

n8n - 💡(How to fix) Fix Data Table CSV export & re-import does not recognize boolean columns

Official PRs (…)
ON THIS PAGE

Recommended Tools

×6

Utilities matched from this issue’s tags and category — try them while you read without losing context.

GitHub issue graph ai analysis

Paste a GitHub issue URL. We fetch that issue, discover linked issues from bodies/comments/timeline, collect linked pull requests, and produce a structured English report.

The report is written in English Markdown for sharing and archival.

Helpful · Quick feedback

Loading…

Error Message

  • error: all
RAW_BUFFERClick to expand / collapse

Bug Description

When exporting data tables as CSV in order to re-import them into n8n, boolean columns are exported as 0 and 1 values. When importing that CSV file back into n8n, these columns are recognized as numbers, and n8n doesn't let me change it to boolean - only number and string options are available.

Tested in Version 2.18.7

<img width="503" height="150" alt="Image" src="https://github.com/user-attachments/assets/e94d6dfe-d9b0-482d-bab0-7fd416d3d0e8" /> <img width="255" height="148" alt="Image" src="https://github.com/user-attachments/assets/4ac84bc4-9bf1-43cf-a6d1-af29dd03008d" />

To Reproduce

  1. create a data table
  2. add a boolean field
  3. export as CSV
  4. create new data table
  5. import freshly created CSV
  6. => boolean field is recognized as number, only "string" option is available as other option

Expected behavior

n8n should recognize columns that only contain 0 and 1 values, and offer "boolean" as option as well (or even select it by default)

Debug Info

Debug info

core

  • n8nVersion: 2.18.7
  • platform: docker (self-hosted)
  • nodeJsVersion: 24.14.1
  • nodeEnv: production
  • database: sqlite
  • executionMode: regular
  • concurrency: -1
  • license: enterprise (production)
  • consumerId: 8b7a1458-f2b2-4a4b-bd8b-dae16b38dd96

storage

  • success: all
  • error: all
  • progress: false
  • manual: true
  • binaryMode: filesystem

pruning

  • enabled: true
  • maxAge: 336 hours
  • maxCount: 10000 executions

client

  • userAgent: mozilla/5.0 (macintosh; intel mac os x 10_15_7) applewebkit/605.1.15 (khtml, like gecko) version/26.3.1 safari/605.1.15
  • isTouchDevice: false

Generated at: 2026-05-07T06:59:19.304Z

Operating System

Ubuntu 24.04.4 LTS

n8n Version

2.18.7

Node.js Version

24.14.1

Database

SQLite (default)

Execution mode

main (default)

Hosting

self hosted

Vote matrix · Quick signals

Works
Did the solution work? Tap to confirm.
Easy Fix
Was it a quick fix?
Time Saver
Did it save you time?
Blocking
Was it severely blocking?
Common Issue
Are others likely hitting this too?
Flaky / Intermittent
Is it intermittent?
Verified / Reproducible
Can you reproduce it reliably?
Loading…

FAQ

Expected behavior

n8n should recognize columns that only contain 0 and 1 values, and offer "boolean" as option as well (or even select it by default)

#ssr#cache issue#memory leak#API versioning#request timeout

Still need to ship something?

×6

Another batch ranked right after the header list — different links, same matching logic.

Back to top recommendations

TRENDING