/
Data Displayed Incorrectly In The Export File

Data Displayed Incorrectly In The Export File

Owned by Michał Kowalewski
Last updated: Nov 29, 2024 by Kinga -SolDevelo-
2 min read

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

MK Documentation Updates.png

This is caused by the wrong separator selected.

What to do about it?

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

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:

image (5).png

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.

The new version of Microsoft Excel:

 

The old version of Microsoft Excel:

If the issue still exists, 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’ll help!