CSV Upload Issue – Boolean Fields Default to true Even When Set to false or Left Blank

Get Help
1

Hi everyone,

I’m running into an issue when uploading a CSV file to update my Adalo collection.

The collection has a True/False field (Boolean). In my CSV, I tried updating several rows by changing the field value to false, and I also tried leaving it blank for some rows. But after uploading, Adalo is setting all of those fields back to true, even though I clearly entered false or left them empty.

I’ve made sure the column is in lowercase (false) and even formatted the column as text in Excel, but Adalo still converts it back to true.

Is there a specific format Adalo expects for boolean values in a CSV upload? Any ideas on how to fix or work around this?

Thanks!

2

Hi @ProvmanRI,

Usually putting “true” (without quotes) imports as TRUE, and leaving field blank imports as FALSE.
I’ve just tested and it works perfectly (again, no quotes " " ).

Best,
Victor.

3

I never added the quotes and its not working. it’s converting it back to True