I’m trying to upload a set of data using the CSV import block - wondering if when you get the warning of ‘2 cell values couldn’t be mapped’ there’s any way to see which cells that is referring to. Does anyone know?
Solved
CSV Block Error
Best answer by Pamela_Hannon
@ScottWorld Thanks! I actually just figured it out - when you hit ‘save records’, it tells you what the error is before you continue.
+35Just curious: how big is the CSV file that you’re trying to import? Airtable’s limit on importing CSV files is a 5 MB CSV file.
Just curious: how big is the CSV file that you’re trying to import? Airtable’s limit on importing CSV files is a 5 MB CSV file.
Pretty small (large data set was misleading) - less than 100 rows and maybe 15 columns
+35Pretty small (large data set was misleading) - less than 100 rows and maybe 15 columns
Ah, gotcha, thanks.
I suppose that the CSV import block doesn’t give very helpful error messages as to which cells have failed, so you might need to email support@airtable.com about this.
However, here are a few possible ideas to look into:
-
It’s possible that you might be trying to import 2 of your columns into single-select fields or multi-select fields, which might not accept imported data that doesn’t meet the already predefined options that you’ve defined for those fields in Airtable.
-
It’s possible that you might be trying to import into date fields, but the dates aren’t formatted in a way that Airtable can understand.
-
It’s possible that you might be trying to import into a formula field, which can’t accept imports.
@ScottWorld Thanks! I actually just figured it out - when you hit ‘save records’, it tells you what the error is before you continue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.