+3Importing csv files with 18 digit numbers, doesn't work
The relevant CSV file to import, is below.
name,server id,notes
Ergonomic chair,513267577250775049,
Wooden storage box,,
Wooden pen holder,,
Best answer by ScottWorld
Right, that will need to be your solution for this. Airtable’s number fields can’t handle numbers that large, and you’re not using it as a number anyways (e.g. performing math on it)… you’re using it as an ID.
+35Are you importing into a number field? Import into a single line text field instead.
+3Are you importing into a number field? Import into a single line text field instead.
It works in text fields but not in number fields.
+35Right, that will need to be your solution for this. Airtable’s number fields can’t handle numbers that large, and you’re not using it as a number anyways (e.g. performing math on it)… you’re using it as an ID.
+35Additionally, if you need to automatically import CSV data into Airtable without any manual intervention at all, I demonstrate how to to do that on this Airtable podcast episode. It simply requires using Make's CSV automations & integrations for Airtable.
p.s. If your company has a budget and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
