Help

Re: Bug on csv import

539 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Zac_Traeger
4 - Data Explorer
4 - Data Explorer

Certain pieces of data (cells are empty) are disappearing on a csv import in airtable. About 10 cells of dates are empty out of 700 record but still appear in excel immediately prior to import on airtable . Can replicate and makes me a bit nervous about importing large amounts of data.

2 Replies 2

Hi @Zac_Traeger,

Do these cells contain the same type data as the fields you are importing them to?

Meaning, if you try to import Text into a field that is defined as a Number, the text will not come. I have imported thousands of cells via CSV with no issue.

BR,
Mo

Zac_Traeger
4 - Data Explorer
4 - Data Explorer

Ok after some more investigation. It appears that certain fields are disappearing (10 of 700 or so) whenever the text fields from the csv (which are a date) are being converted to date as field type in airtable. There isn’t anything I can tell upon first glance that those dates are any different than the other ones that are changing over the field type with no problems.