How to get and compare two excel files from a folder, and create a new sheet for the differences?

Help Studio
, , , , , ,
1

Hi all, I’m stuck to get the following done, hope to get help from any one of you :pray:

Background:
Download the excel files from chrome for different companies a few times per week, move the files to folders that belongs to the companies respectively, so basically the files in that particular folder will continuously be updated.

Steps:

  1. When I download the new excel from the website, I need to get the previous updated excel file in that particular folder (?what activity should I use)
    2.Compare the current excel and the previous updated
  2. Extract the differences(new rows) to a new sheet/workbook
2

Hi @RPA_Innovation,

This video will help.

Thanks