Help

Data validation

Topic Labels: Data
1175 1
cancel
Showing results for 
Search instead for 
Did you mean: 
PmAirtable
4 - Data Explorer
4 - Data Explorer

Hello everyone,

Is there a way to import or reproduce data validation scroll list from excel to Airtable ?

thanks !

 

1 Reply 1
Stephen_Orr1
10 - Mercury
10 - Mercury

Hi @PmAirtable,

Airtable's single-select field type will force editors to pick from a pre-defined list of values similarly to dropdowns via data validation in Excel.

When pasting data from Excel/elsewhere, Airtable will add any new undefined values to a single-select dropdown field as new options for the field.

There might be a faster way but I frequently follow this process to sanitize data pasted into Airtable:

  • Paste values into a grid view with appropriate Airtable field types configured
  • Filter on any predefined fields like dropdowns/dates to only show any new strange values or missing dates
  • Update records manually with the correctly formatted value
  • Finally, when no filtered records are left for strange values, delete the strange option in the field's configuration

It's always best to transform your data as much as possible upstream first before loading into Airtable. You can use the CSV import extension by Airtable in your base to handle these transformations repeatedly as well.

Hope that helps!
-Stephen