Incorrectly Displayed Data In Export File

When opening a file exported from the QAlity Plus app containing Test Cases, there may be an issue with displaying the data correctly. It can look like that first row is squished in one column or the column names are mixed up. Example below:

This is caused by the wrong separator selected.

Solutions

Solution depends on the program you use to open CSV format files.

1. LibreOffice Calc

   1. When opening the file, a window should appear where you can select the appropriate separator.

   2. Make sure a “comma” is selected as in the image below:

2. Microsoft Excel

   1. Open an empty Microsoft Excel program (Not within the exported file)

   2. Go to the Data tab

   3. Choose From Text/CSV

   4. Find the export file from QAlity Plus, click on it, and choose import

   5. A pop-up window will appear → Make sure that Delimiter is set up as a “comma”

   6. Click on the Load button
      

New version of Microsoft Excel

Old version of Microsoft Excel

3. If the issue still exists then try opening the file using Google Drive Sheets:

Still having trouble displaying the data correctly in the file containing the test cases? Contact us through the customer portal and we will help.