Exporting Selected Lists and Reports as CSV Files (CSV Export)

The Full CSV Export option in NetSuite does not currently export all data as CSV files.

This menu option exports the following data:

Note:

On record lists such as Customer and Item, the export mechanism exports the data based on the view you have selected for each list. For more information about options for exporting from record lists, see Exporting Lists.

Known Excel Limitation for Values with More Than 16 Digits

When opening 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 loss of information when digits at 16+ position are truncated. Even if apostrophes or double quotes are used as text qualifiers, the text within them is still recognized by Excel heuristics as a number and an additional formatting hint must be provided. This heuristics is known in Excel as the "General" format. One way to work around this limitation is to always open CSV files using the Excel's multistep Text Import Wizard. The wizard enables you to set column formatting in the last step ("Text" format). Alternatively, you can use a different Office suite, for example LibreOffice, which always displays the import wizard when opening a CSV file.

For suggestions of other methods to export data from NetSuite, see Extracting Data from NetSuite .

To export selected data as a CSV file:

  1. Go to Setup > Import/Export > Export Tasks > Full CSV Export.

  2. Click Submit.

    A progress bar will appear.

    When progress is complete, the File Download window appears.

    Note:

    If the export times out, you can export smaller sets of data by opening pages for the lists or reports listed above and clicking the Export - CSV button.

  3. In the File Download window, select Save this file to disk and then OK.

    The Save As window appears with File Name highlighted.

  4. In the Save As window, enter a file name that means something to you, like your company name and 'listsandrecords', with the extension ZIP.

    For example, you might name your file WOLFELISTSANDRECORDS.ZIP.

  5. Click Save.

  6. Open the ZIP file to see the titles of the generated CSV files.

    For example, when you unzip the exported file, you can choose the file custjobs.csv.

  7. Open the CSV file in a spreadsheet or text editor program.

Note:

The CSV Export function runs your saved searches and saves the results in a CSV file. A saved search that fails may cause the export to fail. So if you encounter errors during the export, review your saved searches to find the problem.

Permissions

Only users who have the Administrator role can use the CSV Export function.

Related Topics

General Notices