How to reorder warehouse pick list csv columns
- Step 1Export the pick list from your WMS or 3PL — Download the pick list as a CSV from your warehouse management system or 3PL portal. It will usually lead with order/shipment IDs and customer fields, with
Location,SKU, andQuantityfurther along. - Step 2Decide the picker-friendly column order — For most floors that is
Location,SKU,Quantity, thenDescription, with order/customer/carrier columns last (or removed). Confirm what your pickers actually scan so the front columns match their workflow. - Step 3Drop the pick list onto the tool — Accepted inputs are
.csv,.tsv, and.txt; the delimiter is auto-detected. The tool reads the header row and lists each column with its current position number. - Step 4Move Location, SKU, Quantity to the top — Use the up arrows to lift
Locationto position 1,SKUto 2, andQuantityto 3. Use the down arrows to push order IDs, customer names, and carrier codes toward the end. - Step 5Apply the order and check the preview — Click Apply order and read the first-10-rows preview to confirm the picker columns are first and the data lines up. Re-drop the original file if you want to start over — the export is untouched.
- Step 6Download, then print or open for picking — Click Download CSV and open the file in Excel, Google Sheets, or LibreOffice to print the pick list. For pick-path order, sort by
Locationwith csv-sorter before printing.
Picker-friendly pick-list layout
A recommended front-to-back order for a printed pick list. The exact columns depend on your WMS; the goal is the scan-critical fields first.
| Position | Column | Why it goes here |
|---|---|---|
| 1 | Location / Bin / Aisle-Bay-Level | Pickers walk by location — it must be the first thing they read |
| 2 | SKU / Item Code / UPC | Confirms the exact item at that location |
| 3 | Quantity / Qty to Pick | How many to grab — second only to where and what |
| 4 | Description / Item Name | Sanity check that the SKU matches the product |
| 5+ | Order ID, Customer, Carrier, Notes | Reference fields — push to the end or remove for a clean print |
Reorder vs. other pick-list prep steps
This tool repositions columns only. Use the linked sibling tools for the rest.
| Need | This tool? | Use instead |
|---|---|---|
| Put Location/SKU/Quantity first | Yes | This tool |
| Sort rows into pick-path order (by Location) | No — row order is never changed | csv-sorter |
| Remove order/customer columns pickers do not need | No — all columns kept | csv-column-remover |
| Combine pick lists from several orders or waves | No — single file in/out | csv-merger |
Rename a cryptic WMS header (LOC_CD → Location) | No — names unchanged | csv-header-rename |
Free vs Pro limits for this tool
Limits apply to the processed result; over the ceiling the tool shows an upgrade prompt.
| Constraint | Free | Pro |
|---|---|---|
| Input file size | 2 MB | 100 MB |
| Result row cap | 500 rows | 100,000 rows |
| Cell values | Never modified | Never modified |
| Row order | Preserved (reorders columns only) | Preserved (reorders columns only) |
Cookbook
Real before/after layouts from WMS and 3PL pick-list exports. SKUs and locations are illustrative.
WMS export leads with order ID, not location
ExampleA typical WMS pick list starts with the order and customer, with Location/SKU/Quantity buried. Reorder so the picker columns come first.
Before (WMS order): OrderId,Customer,SKU,Location,Qty,Carrier SO-9001,Acme Co,WID-12,A-04-03,2,UPS After (Apply order = Location, SKU, Qty, Customer, OrderId, Carrier): Location,SKU,Qty,Customer,OrderId,Carrier A-04-03,WID-12,2,Acme Co,SO-9001,UPS
Reorder then sort by location for pick-path order
ExampleReordering puts Location first; sorting by Location then groups picks by aisle so the picker walks an efficient path. Two steps, two tools.
Step 1 — reorder here: Location,SKU,Qty B-02-01,WID-77,1 A-04-03,WID-12,2 A-01-09,WID-05,3 Step 2 — csv-sorter on Location (ascending): Location,SKU,Qty A-01-09,WID-05,3 A-04-03,WID-12,2 B-02-01,WID-77,1
Strip reference columns for a clean printed sheet
ExamplePickers do not need carrier or customer columns on the floor. Reorder them to the end here, then remove them so the printout is just Location, SKU, Quantity, Description.
Step 1 — reorder (refs to the end): Location,SKU,Qty,Description,Customer,Carrier A-04-03,WID-12,2,Blue Widget,Acme Co,UPS Step 2 — csv-column-remover drops Customer + Carrier: Location,SKU,Qty,Description A-04-03,WID-12,2,Blue Widget
Bin code with a hyphen preserved exactly
ExampleWarehouse locations like A-04-03 and SKUs like WID-12 contain hyphens. The tool preserves them exactly when repositioning the column — no value is altered.
Before: SKU,Qty,Location WID-12,2,A-04-03 After (Apply order = Location, SKU, Qty): Location,SKU,Qty A-04-03,WID-12,2 Bin code and SKU values are untouched.
Cryptic WMS headers — rename first, then reorder
ExampleSome WMS exports use codes like LOC_CD and ITEM. Rename them to picker-readable labels first, then reorder so the floor sheet is clear.
Source header (cryptic): ORD,ITEM,QTY_PICK,LOC_CD SO-9001,WID-12,2,A-04-03 Step 1 — csv-header-rename: LOC_CD->Location, ITEM->SKU, QTY_PICK->Qty Step 2 — reorder here: Location,SKU,Qty,ORD A-04-03,WID-12,2,SO-9001
Errors and edge cases
Real errors and silent failures sourced from each platform's own documentation. Match the wording to the row, fix what the row says to fix.
The tool reorders columns, not rows
By designThis tool changes column positions, never row order. So it makes Location the first column, but it does not group rows by location into a walking path. For pick-path order, run csv-sorter on the Location column after reordering — the two steps together give you a print-ready sheet.
All columns are kept — reference fields survive
By designEvery column is preserved, so order IDs, customer names, and carrier codes stay in the file (you can push them to the end). For a clean floor printout, remove them with csv-column-remover after reordering — the tool keeps all columns by default so nothing is lost accidentally.
Bin codes that look numeric are preserved as-is
PreservedA location like 0042 or a SKU like 007-X is preserved exactly by this tool — it does not coerce values. The risk is downstream: if you open the result in Excel, Excel may strip leading zeros on display. Format those columns as Text in Excel, or keep the file in a CSV-aware viewer for printing.
No admin access to the WMS export config
SupportedThis is exactly the use case the tool targets — you cannot change the 3PL or WMS export template, so you reshape the CSV after export on your own machine. The source system is never touched; you only transform the downloaded file.
Free tier blocks files over 2 MB
Upgrade requiredA large wave or batch pick list can exceed 2 MB and shows an upgrade prompt on free. Pro raises the file limit to 100 MB. To stay on free, split the pick list by wave with csv-row-splitter and reorder each.
Result over 500 rows blocks on free
Upgrade requiredFree caps the processed result at 500 rows. A high-volume pick list exceeds this. Pro lifts the cap to 100,000 rows. Splitting by order, zone, or wave keeps each file within the free cap.
Combined pick lists from multiple orders
Check inputTo pick several orders together you may want one combined sheet. This tool takes a single file, so combine the per-order CSVs first with csv-merger (matching headers), then reorder the merged file into picker layout — and watch the free-tier 500-row cap on the combined result.
Cryptic or duplicate WMS header codes
Check inputWMS exports often use codes (LOC_CD, QTY1) and sometimes repeat a label. The tool lists and moves each by position, so it works regardless — but a picker-readable sheet reads better after renaming with csv-header-rename before reordering.
Frequently asked questions
Can I save a column layout template for reuse?
Not currently — there are no saved templates or presets. You set the column order each time you process a pick list. If your WMS export always arrives in the same shape, the reorder is identical run to run; for unattended runs, the automation path below applies a fixed order in a single call.
Does this sort rows by location too?
No. This tool reorders columns only — it never changes row order. To group picks into an efficient walking path, reorder columns here so Location is first, then sort the rows by the Location column with csv-sorter. The two steps together produce a sheet that reads down the page in pick-path order.
What file size does the free tier support?
Free handles files up to 2 MB and caps the processed result at 500 rows; beyond either you get an upgrade prompt. Pro raises this to 100 MB and 100,000 rows. For a large wave on free, split the pick list with csv-row-splitter and reorder each chunk with the same order.
How do I move a column — is it drag and drop?
You move columns with up/down arrow buttons; each column shows its current position number. This is reliable on a warehouse laptop or tablet and has no drag-and-drop dependency that can misfire. Click an arrow repeatedly to move a column several positions at once.
Will reordering change my SKUs, bin codes, or quantities?
No. The tool repositions columns only; every cell — SKUs, hyphenated bin codes like A-04-03, and quantities — is preserved exactly. Values that contain commas or quotes are re-quoted on output so the columns stay intact, but the content is identical.
Can I remove the order and customer columns pickers do not need?
Yes, but in a separate step — this tool keeps every column so nothing is lost by accident. Reorder here to push reference columns to the end, then use csv-column-remover to delete them for a clean printed pick sheet.
My WMS headers are cryptic codes. Can I make them readable?
Rename them first with csv-header-rename — for example LOC_CD to Location, QTY_PICK to Qty — then reorder here. Reordering never renames a column, so a cryptic header stays cryptic until you rename it.
Does this need access to my WMS or 3PL system?
No. You export the pick list as a CSV from your system, then reshape it here on your own machine. The tool never connects to your WMS or 3PL, so you do not need admin rights to the export configuration — which is the whole point when you cannot change the source template.
What file types and delimiters are supported?
.csv, .tsv, and .txt, with the delimiter auto-detected — so a tab- or semicolon-separated WMS export reorders without configuration. The output is always written as comma-separated CSV, ready to open and print in any spreadsheet app.
Is my inventory data uploaded to JAD Apps?
No. Parsing and reordering run entirely in your browser via PapaParse. SKUs, bin locations, quantities, and order data never reach a JAD server. When signed in, only a usage counter (no content) is recorded, which you can opt out of in account settings.
Can I combine pick lists for multiple orders into one sheet?
Combine the per-order CSVs first with csv-merger (their headers should match), then reorder the merged file here into picker layout. Keep an eye on the free-tier 500-row cap on the combined file, or upgrade to Pro for larger consolidated pick lists.
Can I automate the reorder for every pick-list export?
Yes, via the public CSV API / @jadapps/runner. Pass order as an array of header names (matched case-insensitively) or 0-based indices. Note a difference from the browser tool: in the API path, columns omitted from order are dropped, whereas the browser UI keeps them all — so when automating, list every column you want to keep, in your picker order.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.