There is often a need to load parameters from an excel file into a test. Here is an easy way to convert all the data into a json format and then feed it into our tests. It is done as follows-

  • Step 1 - Convert the excel file with parameters into a json format. You can do this using free third party tools like convertcsv or  codebeautify
  • Step 2 - Copy the generated json and paste it in the "Test Data" section of the setup step. Then add a return statement

Check out the below video for more detailed explanation of how to import excel data into Testim IDE

Did this answer your question?