It seems that when importing a csv flle to the database an error occur when the file has a single quote (’) and exclamation mark (!) I found this when importing thousands of rows (btw adalo can handle importing thousands which is good) but on my initial attempts at a certain row it stops and you will see where it stops the upload and upon checking both characters does the error on the import.
for now I just remove the characters with on my csv file and it just uploaded without any error.
I already sent this as well to the support team but hope this gets fix soon.