Import CSV Incomplete or error

[Jerry_Lan]

Hi @Phil,

I am having importing CSV issues. From the screenshot above, why I can import until Key 6507 but cannot import key 6508 onwards. I deleted 6508 and 6509 to try importing, but sill i get the error 6510 cannot be imported (see screenshot). The column is type Date in appsheet too. I could import 12 records successfully.

Thanks
-j- erry

[Steve]

It appears that your dates are in DD/MM/YYYY format, but AppSheet expects MM/DD/YYYY format. Either reformat your dates, or make sure your localization settings are all set properly and the spreadsheet column format is set to Date.

[Jerry_Lan]

Thank you Steve! Yes as I was walking back home, I thought it might be related to this. Let me try as soon as I can and feedback!