How to import multiple file with different sheets

[VaishnaviGinni]

Hi,

I have 12 months files and in all the files there are 6 sheets and data are starting from 3rd row. So how to import the files in one go.

Thanks, 

Reeta Gour

[messi007]

@VaishnaviGinni,

Please take a look on those links :

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-spreadsheet-import-multiple-shee...

Hope this helps,

Regards,

[ShankerV]

Hi @VaishnaviGinni 

I am splitting your questions to two and answer one by one.

To answer 1st question:

How to read from 3rd row?

Change the highlighted to 3, so the data's will read from row 3.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @VaishnaviGinni 

Please find a sample use case for reading from Row 3.

Input file:

Output: 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @VaishnaviGinni 

To answer 2nd question:

I have created a macro for you to read 6 sheets from all 12 files.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @VaishnaviGinni 

Detailing how my workflow works:

Step 1:  I assume you have all the files in one folder like 2022, 2023 and so on based on year.

Directory tool helps to source the file names first.

Step 2:  I assume you have all the files have same sheet names Sheet 1,  Sheet 2, Sheet 3, Sheet 4, Sheet 5 and so on.

I read the sheet names in below.

Step 3: I append the Path of file name and Sheet names together.

[grazitti_sapna]

@VaishnaviGinni , Try using the below workflow for your files.

[ShankerV]

@VaishnaviGinni 

Step 4: Using formula tool, I join the filename and sheet name

Step 5: Macro helps to read the data's from each file and sheet one by one.

I have made the output file name as field: Full path for understanding purpose to know which data has been read from which file and sheet.

Hope this helps!!! Let me know if you have any more questions!!!

Happy new year in advance!!!!

[Felipe_Ribeir0]

Hi @VaishnaviGinni 

You can use this adapted version of the batch macro input (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...) to do it. This will give you the sheetnames of each file and then import them all to the workflow. Just follow the instructions inside of workflow.

[BrandonKO]

This is one of the better macros floating around if your data is all over the place. https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-All-Exc...