Comparing multiple excel files

Hello All,

I have a use case where I have two folders Old_Folder and New_Folder

New_Folder has three files (a.xlsx,b.xlsx,c.xlsx)

Old_Folder has same three files (a.xlsx,b.xlsx,c.xlsx)

What i need to do is to compare each file(Eg: a.xlsx in new and old folder) in both folders and see if there are any records that got changed overtime. In similar way once if i run the workflow it should compare the data for all the files in the two folders and give an overall report where i can see all the records that got changed overtime.

Regards,

Naveen.

Data Investigation

Accepted answers

kelsey_kincaid

Hi @npeddagorla ,

Without knowing the details of your data, I put together a workflow that should work for you once you tweak it to match your specific use case. It pulls the file paths and feeds those into a batch macro for comparison. The output shows each file, the original value, the new value and whether or not the two match. From there the sky is the limit - you can summarize mismatches by file, filter to which ones do/don't match, etc. Let me know if you have any questions.