Accessing multiple excel files in a folder, Merging the data in them to one excel

SureshBurra1982

Hello All,

I have multiple excel files(1.xlsx,2.xlsx etc) in a folder. Each and every excel file will have the data in the same format. Need to extract one keyword from A3 cell. Based on this I need to merge the data of excels.

Ex. If first two excel files keywords are same, then both the excels data need to be merged into one excel with keyword as a naming convention, in the same way if next excel file has same keyword we need to update that data also into the same excel. If new keyword we need to merge that data in respected keyword sheet if created else need to create.

Could you please help on this?

Topic of Interest

Accepted answers

grazitti_sapna

Hi @SureshBurra1982 , I have used a little bit different approach as discussed but the output is what you desire. Same accounts merged into single file. Please refer to the screenshot below.

You just need to change input and render tool path, try on the given file below and let me know in case you need any help.

I hope this helps , kindly mark this post as solution.

Thanks.

splitting and formating excel-GS.yxmd

Test (2).xlsx

All comments

joshuaburkhow

Hi @SureshBurra1982

I think you can do this by using the directory tool to the dynamic input tool (remember to keep file name in the data as an identifier) then some formula logic to identify the groups of files to be merged together then use the output tool with the ability to split files by the identifier you create in the logic to group them.

grazitti_sapna

Hi @SureshBurra1982 , I have used a little bit different approach as discussed but the output is what you desire. Same accounts merged into single file. Please refer to the screenshot below.

You just need to change input and render tool path, try on the given file below and let me know in case you need any help.

I hope this helps , kindly mark this post as solution.

Thanks.

splitting and formating excel-GS.yxmd

Test (2).xlsx

FláviaB

Hello, @SureshBurra1982. I am moving your post to our Designer Discussions board for more visibility.

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157