1
Overview
The Excel Upload tool converts a spreadsheet into a formatted PDF of Avery labels, ready to print. Each label shows the customer name, PO number, item details, region/branch, and total quantity.
It supports three company spreadsheet formats (A, B, C) and two Avery label sizes. The tool runs entirely in the browser — your file is not stored on the server.
2
How to Use
1
Select Company FormatChoose A, B, or C from the dropdown. This tells the tool how your spreadsheet is structured. See Section 3 for column requirements.
2
Select Label SizeChoose 22823 (2×3 per page, larger labels) or 22816 (3×4 per page, smaller labels). Match this to the Avery label sheet you will print on.
3
Choose Sort Order (optional)Select a column to sort labels by before generating — e.g., sort by Region to group all labels of the same region together on the printed sheet.
4
Upload the Excel fileDrag and drop your
.xlsx file onto the upload area, or click to browse. The tool validates your headers instantly.5
Download the PDFIf validation passes, a Download Labels PDF button appears. Click it to save the ready-to-print PDF.
3
Company Formats
Each company sends spreadsheets in a different structure. Pick the matching format so the tool reads the columns correctly.
Company A
Company A
#11015; Download Sample
| Column | Required? | Notes |
|---|---|---|
Name | Required | Customer name printed on label |
PONumber | Required | Printed top-right on label |
Items* | Required | Any column starting with "Items" (e.g. Items1, Items_S) |
Region | Optional | Shown as colored band under name |
Branch | Optional | Shown above total quantity |
Quantity | Auto-summed | Totalled from Items columns if not present |
Company B
Company B
#11015; Download Sample
| Column | Required? | Notes |
|---|---|---|
Name | Required | Customer name |
PONumber | Required | PO number |
SizeAndDetail | Required | Item lines separated by newlines within the cell |
Region | Optional | Colored band |
Branch | Optional | Above quantity |
Quantity | Optional | Shown as TotalQty on label |
Company C
Company C
#11015; Download Sample
Company C uses a different layout — data may span multiple sheets. The tool scans all sheets for the required markers rather than reading a fixed column list.
| Required Marker | Where |
|---|---|
A cell starting with PO# | Column A, any sheet |
A cell exactly matching NAME | Column A header row, any sheet |
A column header Year Pin | Same row as NAME header |
4
Label Sizes
| Code | Grid | Labels per page | Label size | Use when |
|---|---|---|---|---|
| 22823 | 2 × 3 | 6 | Larger | Fewer, bigger orders needing more item detail |
| 22816 | 3 × 4 | 12 | Smaller | High-volume orders, simpler label content |
Make sure the label size you select matches the physical Avery sheet in your printer. Printing 22816 data on 22823 sheets (or vice versa) will misalign labels.
5
Tips
- Save your Excel file as
.xlsxformat (not.xlsor.csv) - Column names are case-sensitive —
Nameworks,namedoes not - For Company B, put multiple items in
SizeAndDetailusing Alt+Enter (new line within a cell) — each line becomes a separate item line on the label - Use the Sort option to group labels by Region before printing — saves time re-sorting physical labels
- The PDF downloads immediately after generation — the file is not stored on the server
- Region colors are assigned automatically based on the region name — consistent across runs
6
Error Messages
| Error | Cause | Fix |
|---|---|---|
| Missing column: Name | Column header not found | Check column is named exactly Name (capital N) |
| Missing column: PONumber | PONumber column not found | Rename column to PONumber (no space) |
| Missing Items column | No column starting with "Items" | Rename your item columns to start with "Items" |
| Missing columns: SizeAndDetail | Company B column missing | Add SizeAndDetail column |
| No data found in sheet | Sheet is empty or has only headers | Check the first sheet has data rows below the header |
| No PO# row found | Company C: marker missing | Ensure a cell in column A starts with PO# |