About Services Tools Blog Contact us

SKU Labels from a Spreadsheet

Fills labels for sheet materials from a SKU spreadsheet and exports them as a label PDF.

  • Labels & Packaging
  • Cross-sector
  • Pipeline
  • Productised
  • Local/private
  • 2025

The problem

Each sheet needs a readable SKU label. Typing the labels by hand from a spreadsheet is slow, and the typed labels drift away from the stock file.

What it does

The SKU spreadsheet feeds an Adobe InDesign label layout, which fills in each label automatically. The output is a PDF of labels with a small logo mark. If the label content changes, a revised layout can be kept beside the first.

Outcomes

  • Each SKU has a label and nobody types it.
  • The PDF matches the spreadsheet.
  • A revised layout sits beside the original when the label content changes.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

SKU spreadsheet

Click to load sheet_stock.xlsx
Eight sheet codes
CodeMaterialThickSheetGrade
PLY-18-244Birch ply18 mm2440 × 1220BB/BB
MDF-12-244MR board12 mm2440 × 1220MR
OSB-11-244Structural board11 mm2440 × 1220OSB/3
PLY-09-244Hardwood ply9 mm2440 × 1220BB/CP
MDF-18-244Standard board18 mm2440 × 1220STD
PLY-06-244Flexible ply6 mm2440 × 1220Utility
CHIP-18-244Chipboard18 mm2440 × 1220P2
MDF-06-122Craft board6 mm1220 × 610STD

Face check

Revision 2 of the face is kept beside revision 1. The menu chooses which size the PDF imposes. Sample code PLY-18-244.

Small label In the PDF
Weyford Panels PLY-18-244 Birch ply · 18 mm 2440 × 1220 · BB/BB
Full-sheet label
Weyford Panels PLY-18-244

Birch plywood

  • Thickness 18 mm
  • Sheet 2440 × 1220 mm
  • Grade BB/BB
  • Finish Sanded both faces

Label PDF

sheet-labels.pdf Small label
PLY-18-244MDF-12-244OSB-11-244PLY-09-244 MDF-18-244PLY-06-244CHIP-18-244MDF-06-122

Page 1 of 1 · codes match sheet_stock.xlsx

Kept with the job
  • sheet_stock.xlsxsource
  • label-merge.inddlayout
  • label-merge-r2.inddrevised face
  • sheet-labels.pdfnot exported

How it works

  1. Take the SKU spreadsheet as the only source of label details.
  2. Set up the label layout to fill from the spreadsheet, including the logo mark.
  3. Run it to produce a label PDF.
  4. Keep the spreadsheet, the layout and the PDF together for the next revision.

Pipeline

flowchart LR
  A[SKU spreadsheet] --> B[Label layout]
  B --> C[Data merge]
  C --> D[Label PDF]
  C --> E[Revised merge]