Here's how our spreadsheet uploading works:
Example address spreadsheet:
You don't need to use a spreadsheet template!
You can upload any type of spreadsheet (supported filetypes include CSV, ODS, XLS, and XLSX) in any custom format, as long as:
- Each part of the address data is separated into multiple columns.
- The first row is a "header" row with titles for each column of data so Pirate Ship knows what it is (like Name, Email, Address Line 1, Address Line 2, City, State, Zip, Country... but you can use any title names you want).
If you're creating the spreadsheet from scratch using software like Microsoft Excel, Google Sheets, or Apple Numbers, you can name the columns whatever you'd like, just make sure you have separate columns for each part of the data. When you first upload a new spreadsheet format into Pirate Ship, you’ll get the opportunity specify what’s in each column (which is called field mapping).
If you’re exporting the spreadsheet from your ecommerce or order management platform, generally whatever format the export is in by default should work, and you shouldn't need to edit it at all, just drag’n’drop it into Pirate Ship.
You can have different sizes and weights for each address
If you won't be sending the same size of package to each address in your spreadsheet, you can add columns for:
- and Weight (specified in either Pounds or Ounces, but not both)
Just enter the numerical values for each of those fields (and they can include decimals, like 3.5)
When you upload the spreadsheet, you can map those size and weight fields to "override" the default size and weight that you enter into Pirate Ship when creating the batch of labels.