There's nothing wrong with @mattb's suggestion, but to go a little further...
You mention Excel yet the file you have selected is a CSV. If it's really a CSV file, then follow @mattb's suggestion and change datasource type to File.
If you want to use Excel spreadsheet as a datasource, then change type to Excel and ensure the file you are selecting is indeed an Excel file (.xls, .xlsx).
Both File and Excel work well as a datasource. I just think you're mixing datasource types and file types. Don't cross the streams! (Bad 80's joke).
Just an update to what @ChrisAdams said.
I dont know the latest, but ReadyAPI didnt used to support xlsx.....it just.supported xls format.
Things mightve changed, but if you have problems using xlsx, save the file as xls instead and you should be good to go
Thanks everyone for the help in this thread!
Hi @Harish2! Could you go ahead and choose the best reply as a solution if it helped? Thank you!
Community and Education Specialist