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?