Bulk Import tables from excel

Hi,

thanks for your question, and sorry for the trouble.

No, that’s not directly possible, sorry.
You could bulk import several Excel tables at once (by adding them to a .zip file and importing that), but it’s not possible to give them pre-assigned table IDs this way, sorry.

Regards,
Tobias

Hmmm, Can I change the ID later if i put them in a ZIP file?
And how many files is the limit?
I am talking about ~ 500 files perhaps

Also, what if I converted them to JSON rows and injected the TablePress data in each file

Hi,

yes, you can change the ID of a table later on its “Edit” screen.

500 files per .zip file might be a bit much, so that you might want to split that into smaller batches. I don’t have numbers on how many would work at once, though.
And I strongly recommend using the CSV format from Excel, as that’s the most robust and stable format.

Converting the table to JSON would of course be possible, it would have to be a two-dimensional array, in a special format. I suggest to manually create a table, and then export it to JSON. That way, you can see what fields are necessary in the JSON file.

Regards,
Tobias

Thank you, I will test it and follow up
Many thanks ??

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!