https://community.blueprism.com/t5/Product-Forum/Data-comparision-with-the-Excel-spread-sheets/m-p/68219#M20824 It sounds like you need to spend a bit of time getting familier and playing about with with the MS Excel VBO.  The actions that will be your friends most will be the read worksheet as collectdion and write collection actions - especially the range versions of them.   Wed, 07 Feb 2018 17:17:00 GMT Denis__Dennehy 2018-02-07T17:17:00Z https://community.blueprism.com/t5/Product-Forum/Data-comparision-with-the-Excel-spread-sheets/m-p/68218#M20823 Hi All, I have 2 spreadsheets and I need to compare both the spread sheets based on the match[coumn1 in both the sheets] I need to write some of the columnar details into new spread sheet. Final output spread sheet3 will hold the Column1 & Column2 from spread sheet1 , Column5, Column 8 from spread sheet2. Now I am dumping both the sheets into 2 different collections but when I go for the match I have a problem as I both the input spread sheets has 1000 rows which is consuming lot of time - can you please let me know how can I overcome this latency. Regards, Ram Wed, 07 Feb 2018 16:35:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-comparision-with-the-Excel-spread-sheets/m-p/68218#M20823 Rama_RajuGK 2018-02-07T16:35:00Z https://community.blueprism.com/t5/Product-Forum/Data-comparision-with-the-Excel-spread-sheets/m-p/68219#M20824 It sounds like you need to spend a bit of time getting familier and playing about with with the MS Excel VBO.  The actions that will be your friends most will be the read worksheet as collectdion and write collection actions - especially the range versions of them.   Wed, 07 Feb 2018 17:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-comparision-with-the-Excel-spread-sheets/m-p/68219#M20824 Denis__Dennehy 2018-02-07T17:17:00Z https://community.blueprism.com/t5/Product-Forum/Data-comparision-with-the-Excel-spread-sheets/m-p/68220#M20825 Thanks Denis for the reply - in my case I am reading the both the worksheets as 2 different collections but when the comparison takes place it is minting lot of time as both the spreadsheet data will not be same always - here I need to compare data every time from both the sheets.   Wed, 07 Feb 2018 17:35:00 GMT https://community.blueprism.com/t5/Product-Forum/Data-comparision-with-the-Excel-spread-sheets/m-p/68220#M20825 Rama_RajuGK 2018-02-07T17:35:00Z