Exporting Reports, Searches, and Lists
You can export reports, searches and lists into various formats. Exporting provides you with more flexibility to review and analyze your business's data.
For information about exporting, see the following sections.
Comparing Export Formats
Each export format has its own advantages and limitations, listed below:
Exporting to Word
-
Supported Versions – Reports are exported in Word 97 - 2003 format.
-
Expand/collapse – Settings are maintained. The report will be displayed as it is currently viewed on the screen. If you have collapsed a section of the report (hiding some rows), then those rows won't be available in the word document. You won't be able to expand and view hidden rows.
-
Company Logo – The logo will display in the exported Word report if you've set it as a preference in the Analytics subtab at Home > Set Preferences.
Exporting to PDF
-
Expand/collapse – Settings are maintained. The report will be displayed as it is currently viewed on the screen. If you have collapsed a section of the report (hiding some rows), then those rows won't be available in the word document. You won't be able to expand and view hidden rows.
-
Company Logo – The logo will display in the exported Word report if you've set it as a preference in the Analytics subtab at Home > Set Preferences. However, the uploaded image is not resized to fit the PDF layout, it's used as is.
-
Formatting – By default, a PDF of an exported report/search has a font size of 8 and a portrait orientation. You can change these settings by updating the PDF Page Orientation and PDF Font Size preferences on the Analytics subtab at Home > Set Preferences. See Setting Formats for Reports Exported to PDF.
-
Size Limitations – Exported PDFs currently have some output limitations. You may encounter issues if your report results include a large number of rows or columns, or extremely long field values. You can't export reports with more than 30 columns and NetSuite limits records for reports with more than 10 columns. To get around these issues, try adding criteria to reduce the number of rows and columns, or remove fields with long values. For details, see Limitations on Exports to PDF.
Exporting to Excel
-
Supported Versions - Only XLS files are supported. XLSX files aren't supported.
-
Expand/collapse - Settings aren't maintained. All rows in the report will be exported, any collapsed rows will appear fully expanded in Excel.
-
Company Logo - The company logo is not displayed in Excel exports, even if you've enabled the Print Company Logo option on the Analytics tab at Home > Set Preferences.
-
Unicode - Supported.
-
Decimal precision - Excel keeps the same high decimal precision you see in the report or search.
-
Limitations - For item records with the Detailed Description field, the length of this field is limited to 1,300 characters in search results.
Exporting to CSV
-
Expand/collapse - Settings aren't maintained. All rows in the report will be exported, any collapsed rows will appear fully expanded in Excel.
-
Company Logo - The company logo isn't exported.
-
Unicode - Not supported.
-
Decimal precision - All decimal numbers are limited to 2 decimal places. If you need more precision, you should export to Excel first, then save it as a CSV file.
-
Handling Special Characters - If you open a CSV file in Excel that has data in languages other than English, some special characters may not show correctly. If that happens, export to Excel instead, then save it as a CSV file. For more information, see Limitations on CSV Exports of Data with Special Characters.
Exporting to Tableau
-
Supported Versions - Tableau Desktop 8.3 or later.
-
Expand/collapse - Settings aren't maintained. All rows included in the report or search results will be exported.
-
Company Logo - The company logo is not displayed when the report or search is exported as a Tableau workbook.
-
Unicode - Supported.
-
Decimal precision - Tableau Desktop keeps the same precision you see in each report or search.
-
Limitations - Sort settings may not be kept when you export search or report results as a Tableau workbook.
See the following topics for export limitations:
Related Topics
- NetSuite Basics
- NetSuite Basics Overview
- Getting Help
- Navigating NetSuite
- Logging in to NetSuite
- Logging out of NetSuite
- Setting Personal Preferences
- Using SuiteAnalytics Workbook
- Working with Records, Transactions, and Lists
- Working with Your Calendar and Activities
- Working with Email
- File Cabinet Overview
- Permission to Export Report & Search Results