Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 16, 2021 07:45 AM
We are looking to import a large Excel dataset into AirTable, ~500 multi-sheet xlsx files, as individual Bases. The Add a Base > Import data > Excel file selector has a limit for 1 file. Is there a means of creating multiple Bases off of a bulk upload process?
Solved! Go to Solution.
Feb 16, 2021 08:32 AM
Hi @Matthew_McPherson, and welcome to the community!z
No. There is no known way to programmatically create bases through automation processes.
But it’s probably worth asking - what data model requirement swayed you to believe that fragmenting all that data into separate unsearchable, and largely uncommunicative databases was a good idea?
Feb 16, 2021 08:32 AM
Hi @Matthew_McPherson, and welcome to the community!z
No. There is no known way to programmatically create bases through automation processes.
But it’s probably worth asking - what data model requirement swayed you to believe that fragmenting all that data into separate unsearchable, and largely uncommunicative databases was a good idea?
Feb 16, 2021 08:51 AM
Thanks for confirming.
The data is not representing a database, it is a direct migration of a file set with no managed relationship between the files
Feb 16, 2021 09:10 AM
The lack of relationships is not always a good reason against unifying the data in a common management model. Why not aggregate and take advantage of the ability to treat them as logical file sets while enjoying the information management aspects at scale?