Many friends say that they still don’t know how to export tables in batches using the essential toolbox for excel? Then the editor will share with you how to export tables in batches with the essential toolbox for excel. I hope it can help everyone.

First, download and install the necessary excel toolbox on your computer. It will then be displayed in the excel toolbar. Click "Split Document" in the toolbox.

​ ​​The path to the exported file, you can create a new folder, click OK, as shown in the figure

Remember to choose not to retain the formula (retaining the formula is prone to problems)

If you don’t need to rename it, just click Cancel and start exporting the file.

The above is the method of exporting tables in batches from the essential excel toolbox shared by the editor. Friends in need can take a look.