Skip to main content

Maximum fields in Airtable?


Forum|alt.badge.img+10
  • Known Participant
  • 28 replies

Hi guys! I was just wondering what is the maximum fields in Airtable (Enterprise or Pro)? I heard that the number is 500, but this is too small for me. I would like to import more than 100.000 products (in records) and for each record I want around 1,200 fields (columns). Does anyone know if this is possible?

 

6 replies

Forum|alt.badge.img+18

500 is the limit for fields per table. If you're exceeding this, you may want to think about pivoting your data or using linked record relationships to normalize it into joined tables instead of one wide table.

https://support.airtable.com/docs/airtable-plans


Forum|alt.badge.img+10
  • Author
  • Known Participant
  • 28 replies
  • June 13, 2023

Yeah, I was thinking of breaking the data in more tables but I was really hoping to have all data in one place (in a one big table) 🙂 Thanks


Forum|alt.badge.img+18

There are some good reasons to do so when using Airtable. Unlike a spreadsheet app, records will not be able to access surrounding records in the same table via formulas in Airtable. You must build relationships to create aggregated data points as field values to actually use/output and not just view in a group by summary function. Airtable can be a database for spreadsheet folks but it doesn't shine when used only like a spreadsheet.


Forum|alt.badge.img+10
  • Author
  • Known Participant
  • 28 replies
  • June 13, 2023

Yeah, I understand.. I'm getting used to this but it's hard sometimes when you were using spredsheets for years 🙂 I'm slowly getting there. 


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8786 replies
  • June 13, 2023

@SpelaU 

Note that Airtable is not a professional enterprise-grade database app. It is a basic, entry-level database app (that doesn't even have 20% of the functions that Excel has).

However, if you are looking for a professional database app with no limitations at all (up to 256 million fields, up to billions of records, up to 8 TB worth of attachments, full design canvas, enterprise-grade security, encryption, etc.), you will want to look at FileMaker Pro.

I was a certified FileMaker developer for 30 years before becoming an Airtable consultant, so if you need a referral to some great FileMaker developer, feel free to contact me through my website.


Forum|alt.badge.img+10
  • Author
  • Known Participant
  • 28 replies
  • June 13, 2023

Thanks, I will check it out.


Reply