This UiPath exercise takes you through the most common web automation task you face as an RPA developer: Read an Excel sheet, do a search and write the results back to the Excel.

Learning Objectives

  • Combine Excel with web automation


  • Download the course files
  • Read the Excel sheet
  • Iterate through each row
  • Do a CVR lookup at
    • Make sure to click English in the upper right corner
  • Fill in all the empty columns in the Excel sheet
  • Can you handle errors:
    • Try to create the following entries
      • 12345678
      • 8
    • And combat both exceptions


  • You might want to use a Check App State to make sure, you’re on the correct company page

Video Guide