Goal: I want to be able to import a CSV that has blank values for some rows in a nullable number column Steps: create a retool datase. add a column with a number type and let it be nullable. Create a csv which contains that column, add two rows, one with a value in the column and one without a …

[image] jg80: Saw something similar before here I think @Kabirdas workaround from the same thread is the simplest Band-Aid to this problem. [image] Importing CSV into Retool Database Table with null values Passing an empty value for a particular cell (i.e. ,, ) should read as null for "da…

Import CSV to retool database gives error on null columns

💬 App Building

jg80 June 11, 2024, 4:16pm 4

Saw something similar before here - In your CSV to you have ,, or ,"", for the column (you need to have ,,)?

Topic		Replies	Views
Error importing numerics in CSV file 💬 App Building table	6	1312	May 12, 2025
Importing CSV into Retool Database Table with null values 💬 Queries and Resources	20	2939	May 21, 2025
Need help importing CSVs in Retool Database 💬 Queries and Resources	3	156	January 20, 2025
Retool Database - Insert From Form - Primary Key Errors 💬 Queries and Resources	6	1490	November 14, 2024
Retool DB Import Data 💬 Feature Requests	3	422	February 27, 2025

Import CSV to retool database gives error on null columns

Related topics