Learn more

Export Data (Spreadsheet Sequences)

Import Data (Spreadsheet Sequences)

You use this window to import a list of spreadsheet sequences from a Microsoft Excel file that you exported previously.

The import process:

  • Adds lines for spreadsheet sequences item prices that do not already exist.
  • Updates values for spreadsheet sequences item prices that already exist. (Values from the import file overwrite existing values.)
  • Does not delete spreadsheet sequences item pricesthat exist in the list, but not in the import file. The import process leaves existing lines intact if they do not exist in the import file.

Note: The file format must be valid before you can import the spreadsheet sequences into the Edit Default Spreadsheet Sequences window. For example, you must use the same columns as the exported values, any rows that you added in Excel must be complete, and the sequence name must not exceed 8 alphanumeric characters.

To import spreadsheet sequences, you click the [Import] button in the Edit Default Spreadsheet Sequences window.

When the import process is complete, the Import Data window displays a [View Log] button. Click the button to view a report of the import details, which includes the number of records processed, updated, and added, as well as a list of any errors encountered during the import.