Who is this article for?

All Ideagen Quality Management Users with reporting permissions.

Ideagen Quality Management site accessis needed.

To make answering this question easier, this article is split into three sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are looking for:

1. Question
2. Answer
3. Further Reading

1. Question

Why would reports exported from Ideagen Quality Management look different in Excel? 

2. Answer

The reports are written in text only, with commas delimiting the columns and Excel processes that data differently upon import/open. To correct this you can set up a document with specific format types before opening the downloaded report.

1. Open Excel and create a new blank document.
2. Go to the Data tab, and select Text as the document type to import.
3. Browse to your exported report file and begin the import wizard.
4. When you reach the section where you can specify a data type for each column, select Text as the type. (instead of general, date, etc.)

3. Further Reading

This section will provide important links to further troubleshooting and resources.