Merchant
CSV LAB
ALL GUIDES

How to turn a Shopify order CSV into a packing list

An order export can spread one order across several rows. Order Packing Sheet carries the order reference and available shipping details onto each line item so you can review what belongs together.

Open the free tool ↗

Step by step

  1. In Shopify, select the orders you want to work with and export them. Filter cancelled, fulfilled or irrelevant orders before using this tool; the tool does not select orders for you.
  2. Use a UTF-8 CSV up to 10 MB with Name, Lineitem name and Lineitem quantity. Optional columns include Lineitem sku, Shipping Address1, Shipping City and Shipping Country.
  3. Open Order Packing Sheet, select the CSV and choose Create report. A blank order name can continue the preceding order, but the first item must have an order reference.
  4. Check the order references, item quantities and addresses. Download CSV for Excel to print or adjust the sheet for your own workflow.

A small worked example

All data below is synthetic.

Name,Lineitem name,Lineitem quantity,Lineitem sku,Shipping City
#1001,Notebook,2,NOTE,London
,Pen,1,PEN,
#1002,Mug,1,MUG,Bristol

The result contains three item rows across two orders and four units in total. The Pen row belongs to #1001 and inherits London from that order. These are synthetic examples, not customer records.

What to check before using the result

This is an item report, not a shipping label or address validation service. It does not check deliverability, exclude cancelled orders or decide which items have already shipped. Keep the original export and verify the list before packing.

Why does an item with a blank order name appear under the previous order?

Supported Shopify-style exports use continuation rows for additional items. The tool carries forward the preceding order reference. An item without any preceding order is rejected instead of being assigned an invented reference.

See the official export documentation for the source platform.

The online tool is free. Optional offline copies cost $26.99 each and provide the same core analysis.

Try the example ↗

Related guides