Airtable Field Type Mapper
Paste a sample of your data and get the Airtable field type for every column, the reasoning behind each one, and a suggested primary field — before you create the table.
Suggested Airtable fields
| Column | Airtable field type | Fill | Distinct | Why |
|---|
Ready to automate?
Once the base is set up, Simple Data Foundry keeps it current — map your source columns to these fields once and every scheduled run appends, overwrites or upserts for you.
Frequently Asked Questions
Why does the field type matter?
Airtable will happily accept almost anything into a single line text field, and then none of it sorts, filters or groups the way you expect. Numbers compare as strings, dates cannot be filtered by range, and select fields lose their colours. Getting the type right at table-creation time is much cheaper than converting a populated field later.
How does it decide between text and single select?
By cardinality. A column with a handful of distinct short values repeated across many rows behaves like a category, so it suggests Single select. A column where most values are unique is suggested as text. You can always overrule it — the counts it reports are there so you can judge.
What makes a good primary field?
Airtable primary fields cannot be checkboxes, selects, or attachments, and they should identify the record. The tool suggests the first fully-populated column whose values are all unique — the same column you would want as an upsert key for a recurring sync.
Does it create the table for me?
No. This tool reads your sample and tells you what to create; you still set the fields up in Airtable. It does not connect to your account and never asks for an API key.
Is my data safe?
Yes. Parsing and analysis happen entirely in your browser. Nothing is uploaded and no request is made to any server.