nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

229106_en-US

liliconcom

Importing multiple Excel files that contain multiple tabs

I am working with a customer who has several Excel files that all have the same tabs within. He is interested in concatenating the data from a single tab ("Data" tab) in the Excel files together.

Is the most efficient way to do this using the Excel import wizard? Multiple File Import is unable to handle spreadsheets with multiple tabs, correct?

Re: Importing multiple Excel files that contain multiple tabs

Hello Wendy,

There are two ways that I'd reccomend to achieve your outcome.

First way is to use Open Files menu. And Open each file and then Stack Tables using Tables > Concatenate.

1. Open File.png 2. Open File.png

Second more efficient way is to use the Import Multiple Files menu option. And then bring files in altogether in one file using Stack Similar Files option.

3. Open Multiple.png 4. Open Multiple.png

Take a look at the Source Script for new Data file Book1_Book5. In the future, you can add new data to the MS Excel files and just hit the Source Script to rerun the import.

5. Script.png

If you'd like to try, I have both sets of files and project files for the two methods.

Thanks Bass

Comments

There are no comments yet