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

Bug: Export as Excel exports as CSV


#1

In the Test Suites view, ‘Export as Excel’ exports the file as CSV

The link looks like
https://testrail.sv.splunk.com/index.php?/suites/export/16&format=excel

but the results download file has a csv extension

Thanks

Ali


#2

Hello Ali,

Thanks for your posting. The Excel export currently also generates a CSV file. The difference to the CSV export is that it automatically suggests Excel as the viewer for the download and that the export uses the correct CSV limit character, depending on the locale of the TestRail user. The CSV always uses a comma whereas the Excel export may use a comma or a semi colon, depending on the locale and how Excels expects this (Excel on a German Windows would expect a semi colon, for example). Do you see any issues with Excel displaying the content?

I hope this helps and please let me know in case you have any further questions.

Regards,
Tobias