The Adalo CSV Import spec seems unusual, different from what my Excel exports, anyway.
Others have had issues. I lost hours today on importing 25 listings, even though I do a LOT of database management.
Here is what I figured out so far:
Commas, no quotes in the header
Commas and quotes in the data rows
Date of 0000-00-00 seems to cause “unknown error”
Lines need to end with a \n (newline, I think)
Manually entering a data row and exporting the file helped, but didn’t solve the “unknown error”
Overall, data onboarding seems to be a real weakness. Please support my FR.for functional data migration