How to Import Items for a Client from an XLSX File [Step-by-Step Guide]

Modified on Mon, 13 Oct at 11:56 AM

You can import an item table for a specific Client from a Microsoft Excel Spreadsheet (XLSX) file to immediately use them.

WARNING: The XLSX file must be in the correct format with the correct columns. You can ensure this by exporting an items table and use it as a template, as detailed in How to Export Items for a Client to an XLSX File [Step-by-Step Guide].

If you are creating or editing your import file using Microsoft Excel, you must ensure the CUSMA Certificate base64 string does not exceed Excel's cell character limit of 32,767. Attempting to save a file with a longer string in Excel will corrupt the data and will cause the import to fail.

NOTE: It is important to note that the 32,767 character limit is specific to Microsoft Excel. The techSHIP import process itself can successfully handle longer base64 strings. Therefore, files generated directly by an external system can exceed this limit and will be imported correctly, provided they are not opened and saved in Excel beforehand.

To import an items table for a specific client from an XLSX file:

1. Find the desired client by clicking on Clients from the left menu under the Clients section.

2. Edit the desired client by clicking the Settings button.

3. Click Items tab.

4. Press Import.

5. Click Files to select the file you would like to import.

6. Set the Replace Existing Items field to:

Checked: To replace all existing records in the items table with the imported ones.
Unchecked: To add the imported records to the items table.

WARNING: As this option does not check for any conflicts, ensure the imported records do not overlap with the existing ones. Overlapping records may lead to unexpected behavior.

7. Press Import.

As a result, a pop-up window will confirm the successful import, and the imported items will be immediately available. Click OK to close.

To learn more about what you can do next, refer to the Items folder in our knowledge base.