How to Bulk Import New Items/Folders in Sortly via CSV or Excel

Easily upload NEW ENTRIES into your Sortly inventory via a CSV or Excel file using our basic import or advanced import templates.

Note: You cannot use the CSV/Excel import feature to update your existing items.

Importing your inventory in bulk will save you valuable time and effort if your inventory is organized in Excel, Numbers, Google Sheets, or another type of spreadsheet. 

Please follow the steps below to import your data into Sortly.

Quick Upload Import

Go to Settings > Bulk Import:

Sortly.png

Select "Quick Import" from the options, as seen below.

Sortly.png

Next, you will be prompted to upload a file. With quick import, Sortly reads the information, so you don't need to use our pre-formatted template (shown in the steps above). You can upload a CSV or XLSX to generate the import, and you'll need to include at least the item name and a quantity.

Once you've added the file, select "Continue."

Sortly.png

Once your information has been processed, you'll be given the opportunity to map the data Sortly finds to the default fields available and the custom fields you've already set up within Sortly.

mceclip0.png

 

If you have any error messages, we'll ask if you want to go back and correct them or "Skip Errors and Import."

mceclip3.png

After clicking "Skip Errors and Import" or just "Import" if no errors appear, your information will begin to import into your Sortly account.

Please note, that this could take a few minutes depending on the number of items you are trying to import.

mceclip4.png

When your items have successfully imported, you'll see this screen:

mceclip5.png

You can click "GO TO IMPORTED ITEMS" to visit your Sortly items page and view the information you've added, or you can click "DOWNLOAD REPORT" to generate a confirmation spreadsheet of the items and their import statuses.

 

Advanced Upload Import

Navigate to the Bulk Import within the Settings tab here:

Sortly.png

 

You will then land on the following page, and you will want to select the Advanced Import option seen here:

Sortly.png

 

Next, Download the Sortly import template (BASIC or EXPERT OPTION; templates are at the bottom of this page)

Suggestion: If you are a new user unfamiliar with the Sortly import process, we recommend starting with the BASIC template.

Sortly.png

 

Next, add your data to the template

Important Tips:

1. The templates are dynamic and will always reflect the fields you currently have in Sortly. You need to create all the fields within the Sortly system before downloading the template.

2. Please view the SAMPLE or HELP tabs in the template if you are unsure of what data to enter in each field. 

3. Please do NOT change the column names, add new columns, or change the order of these columns.

4. If you don't see the columns you need, please add custom fields within the Sortly system first and then re-download the template.

 

Then, Save the template as CSV or XLSX 

Saving tips:
Excel:
  1. File
  2. Save as..
  3. Choose CSV or XLSX

Google Docs:

  1. File
  2. Download as
  3. CSV or XLSX

Numbers:

  1. File
  2. Export to
  3. CSV or XLSX

You can now import the CSV or XLSX file into Sortly

Sortly.png

 

Error Messages for Template Import

Sometimes, the Sortly system cannot read the information you have attempted to import. Please review the error messages, make appropriate updates to your CSV, and attempt to re-upload.

Please note: If you only receive error messages on some items, the others have likely been imported into the Sortly system. If you want to re-upload the entire CSV, please go to your Sortly account and delete the items that did upload; otherwise, you will receive a duplicate error message the next time you try to upload.

You can find detailed instructions on deleting items from your Sortly inventory here.

Upload Failure for Template Import

If you attempt to upload more items and folders than your plan can support, you will be prompted to upgrade your plan. To upgrade your plan, please visit your Manage Plan section in Settings > Billing > Manage Plan.

mceclip0.png

Note: If your import fails without a clear error message or takes over 5 minutes, please contact us at support@sortly.com and provide a copy of the CSV or XLSX file you are attempting to upload. 

 

Video Walkthrough

The video and instructions below show you how to use the Sortly template to import items directly into Sortly. If you continue scrolling, we'll also provide steps on using the "Quick Import" feature that does not require the use of a template to upload new inventory.

Was this article helpful?
44 out of 89 found this helpful