Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Multiple Excel file import

Topic Labels: ImportingExporting
Solved
Jump to Solution
1401 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthew_McPhers
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Bill_French
17 - Neptune
17 - Neptune

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?

See Solution in Thread

3 Replies 3
Bill_French
17 - Neptune
17 - Neptune

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?

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

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?