Hundreds of labels from one spreadsheet
Upload a spreadsheet of up to 500 parcels. ProtonShip prices every row at every carrier. You check the picks, pay once and print every label in one PDF.
order_ref,to_name,to_company,to_street1,to_street2,to_city,to_province,to_postal_code,to_phone,to_email,residential,weight_lb,length_in,width_in,height_in,box,signature,declared_value,from_address
#1043,Amira Haddad,,48 Rue Rachel E,Apt 3,Montreal,QC,H2W 1C9,514-555-0142,[email protected],Y,2.4,12,9,4,,N,,
#1044,Callum Boyd,Boyd Outfitters,2207 4 St SW,,Calgary,AB,T2S 1X2,403-555-0188,,N,6,16,12,8,,Y,250,From file to labels in four steps
- 1
Fill in the template
One row per parcel: the recipient, the weight and either a box size or the name of a saved box.
- 2
Choose how to pick
Cheapest, fastest, or one carrier for every row. ProtonShip prices each row at all four carriers and picks by that rule.
- 3
Check every row
Change the service on any row. Rows with a problem, such as a missing postal code, are flagged so you can fix or delete them.
- 4
Pay once and print
One payment covers the whole file. Every label comes in a single PDF, 4 × 6 or letter, plus a CSV of tracking numbers.
What goes in each column
The template has these columns. Download it from Bulk upload in your account.
| Column | What to put in it |
|---|---|
| order_ref | Your order number. It goes with the shipment as its reference, and into the tracking export. |
| to_name | The recipient's name. |
| to_company | Company name, if it's a business. Optional. |
| to_street1 | Street address. |
| to_street2 | Apartment, suite or unit. Optional. |
| to_city | City. |
| to_province | Province or territory: the code (ON, QC) or the name in English or French (Ontario, Québec). |
| to_postal_code | Postal code, with or without the space (M5V 2T6 or M5V2T6). |
| to_phone | Phone number, 10 digits, with or without dashes or spaces. Optional, but carriers use it when there's a delivery problem. |
| to_email | Email. Optional; some carriers use it to contact the recipient about delivery. |
| residential | Y for a home, N for a business; blank means Y. Homes cost more with some carriers. |
| weight_lb | Weight of the packed box, in pounds. |
| length_in | Length in inches. Leave the size blank if you use the box column. |
| width_in | Width in inches. |
| height_in | Height in inches. |
| box | The name of a saved box, or a standard size: Padded mailer, Small box, Medium box or Large box. |
| signature | Y to require a signature on delivery. |
| declared_value | Value of the goods in dollars, for coverage above the basic amount. Optional. |
| from_address | The name of a saved ship-from address, for a parcel that ships from somewhere other than the address you pick when you upload. Optional; leave it blank to use that one. |
Standard box sizes
- Padded mailer13 × 10 × 1 in
- Small box12 × 9 × 4 in
- Medium box16 × 12 × 8 in
- Large box20 × 16 × 12 in
Write one of these names in the box column, or the name of a box you saved. The box sets the size; the weight column is still the packed weight.
Bulk upload questions
How many parcels can one file hold?
Up to 500 rows, in a CSV or Excel (.xlsx) file up to 900 KB. For more, split the list into several files.
Can I upload an Excel file?
Yes. Upload the .xlsx as it is; the first sheet is read. A CSV works too. If Excel offers CSV UTF-8 when you save, choose it, so accented names like Montréal come through on a Mac as well.
Can I use my own spreadsheet layout?
Use the template's column names in the first row. The columns can be in any order, and optional ones can be left empty.
Where do the parcels ship from?
From the ship-from address you choose when you upload. A row can name another saved ship-from address in the from_address column, such as a second warehouse.
What if a row has a mistake?
It's flagged with the reason before you pay. Fix it on the page, delete it, or fix the file and upload again.
Can I void some labels from a batch later?
Yes. Each label is its own shipment, so you can void any one the carrier hasn't scanned and its amount goes back to your card.
Do bulk labels cost more or less than single labels?
The same. Each row gets the same price it would get on its own.
Get early access for your next big send
Price a whole order list at four carriers and print every label at once.