Comparing two different Excels

I’m new to Uipath. Can anyone please explain how to compare the columns in one excel with the respective columns in another excel.

Hello @sanju_RPA ,

Have you tried to read both files with the read Rangel activity storing the values in a dataTable.

Once you have the two datatables you only have to compare them row by row or maybe using a filter. It is depends on what you need to achieve.

Can you give us more detalles?

Best regards,


Hi @Susana
I had read the two excel files using read range activity and stored into a two datatables. But I’m getting trouble to iterate those datatables and compare each column.