Known Excel Limitations when Exporting Search Results

Be aware of the following limitations when exporting search results to Excel:

• Values with more than 16 digits - When you open a CSV file directly in Excel, it treats long numbers as numeric values and displays them in scientific notation. If the number has more than 16 digits, Excel loses precision and cuts off digits past the 16th. Even if you use apostrophes or double quotes, Excel still treats the value as a number unless you apply additional formatting. This default treatment is called the "General" format.

  To prevent this, always open CSV files using Excel's Text Import Wizard. In the last step, set the column format to "Text" or use another Office suite like LibreOffice, which always shows the import wizard for CSV files.

• Item Detailed Description length - When you export item Detailed Description fields, the exported Excel file limits each field to 1,300 characters.

• Discrepancies between report links results and exported results - If you open a report with period selectors from the Report Links portlet and change the period before running or exporting it, the exported results might not include the new periods you selected. To avoid this issue, adjust the period and export without running the report, or use an advanced search to run and export the report. For more information, see Defining an Advanced Search.

General Notices