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

Test Suite export to Excel bug


#1

Not sure if anyone has reported this already.

The export to Excel is saving the file as csv format with a file extension .csv
and
The export to CSV is saving the file as excel format but with file extension .csv


#2

Hello Roy,

We had a report about this before so I investigated this again and I think we found the issue. It looks like Excel uses different separators (sometimes semicolon, sometimes comma) depending on the configured Windows locale (specifically, the List separator value). We weren’t aware of this before. We will look into fixing this for the next TestRail version and will probably use different separator characters depending on the user locale configured within TestRail.

As a workaround, you can just use the Export to CSV option to work with Excel.

Thanks,
Dennis