Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.
 

Export to Excel


#1

Hi.
I need to export all test cases to Excel spreadsheet to make some analysis.
However I have found that exported CSV has some problems:

  • enters in long text fields are considered as new row
  • tags fields puts every value on a new line - so it is also considered as a new row
  • even Title sometimes has enters (I don’t see them on UI but they have enters in exported CSV) and also produce new row
    I tried on Mac Excel and on Windows Excel with the same results.

What is the right and painless way to export all test cases with all the fields into spreadsheet: one case = one row?


#2

Hello Konstantin,

Thanks for your posting. Could you please send the CSV file via email to contact@gurock.com? We are happy to review the file then.

Regards,
Tobias