Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 12, 2023 11:15 PM
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?
Jun 12, 2023 11:39 PM
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.
Jun 13, 2023 12:35 AM
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
Jun 13, 2023 01:17 AM
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.
Jun 13, 2023 03:45 AM
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.
Jun 13, 2023 03:59 AM
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.
Jun 13, 2023 05:36 AM
Thanks, I will check it out.