Exporting Lists

You can export NetSuite lists as files that you can open in external applications. The toolbar at the top of the list has icon buttons to support the following file export types:

Note:

If your account administrator enabled the Tableau® Workbook Export feature and assigned you the corresponding permission, your list toolbar also contains the Export to Tableau Workbook icon Export to Tableau Workbook icon.

For results exported to a CSV or XLS file, you may save the file or open it immediately in Microsoft Excel. For results exported to a PDF file, the file opens immediately.

Internal ID field values are generated by the NetSuite system for each record. These values, which serve as unique identifiers, are always included as a results column in the list to be exported.

Each export format has advantages and limitations. Review the limitations before selecting a preferred format. The format you select can affect data accuracy and report readability. For details on the export formats and their limitations, see Comparing Export Formats.

Note:

If exported lists and files are marked as encrypted or read-only, you need to know your password for such files.

Known Excel Limitation for Values with More Than 16 Digits

When you open a CSV file directly, Excel treats long numeric sequences as numbers and displays them using scientific notation. This treatment leads to a loss of precision when the number has more than 16 digits and to lost information when digits beyond position 16 are truncated. Even when the text is qualified by apostrophes or double quotes, it is recognized by Excel as a number. To avoid this limitation, open CSV files using the Excel multistep Text Import Wizard. The wizard enables you to set column formatting in the last step ("Text" format).

Related Topics

Working with Lists
Using Inline Editing
Using the Recent Records Menu
Working with List Views, Sublist Views, and Dashboard Views

General Notices