AxiomBlueprint
Network and homelab

Patch Panel and Structured Cabling Labeling Sheet

Generate cable IDs and both-end labels automatically, catch duplicate ports/outlets, and print label sheets to PDF with the included script. What you get. Patch-Panel-Cable-Labeling-Sheet.xlsx. make_labels.py. Sample-Labels.pdf....

$19one-time price, instant download

Buy now for $19
  • Checkout runs on Gumroad, which takes payment, sends your receipt and delivers the files.
  • Problem with a file? Message us and we will fix or replace it. Refund terms.

Formats: Excel (.xlsx), PDF, Python script

Try a free working sample first →

Patch Panel and Structured Cabling Labeling Sheet: cover image 1Patch Panel and Structured Cabling Labeling Sheet: cover image 2Patch Panel and Structured Cabling Labeling Sheet: cover image 3

What you can check before you buy

v1.0version · file dated Oct 14, 2026
6visible sheets in the workbook
1,643formulas, all readable in the cells
0formula error cells after a full recalculation
nonemacros in the spreadsheet file

Checked on Oct 14, 2026: the workbook Patch-Panel-Cable-Labeling-Sheet.xlsx was opened and fully recalculated in LibreOffice and no cell showed an error. This is our own check against the sold file, not an outside audit. The template was drafted with AI assistance; its formulas are checked with automated tests and worked examples.

Also included: make_labels.py (a plain Python script you can read before running; no spreadsheet macros).

Inside the workbook (from the real file)

input cellformula (hover for the formula)heading

Sheet: Read Me (16 rows, 7 columns)
Patch Panel and Structured Cabling
Generate cable IDs and both-end la
How to use
1. Yellow cells are inputs; everyt
2. Open the Tests sheet: it should
3. Grey tabs named T_* / Test_* /
4. Works in Excel 2019/365 and Lib
What this is NOT
Not a copy of any cabling standard
Sheet: Panels (24 rows, 7 columns)
Sample: panels
One row per patch panel. Ports = h
Panel IDLocation / rackPorts
PP01Rack A1 (MDF)48
PP02Rack A1 (MDF)24
PP11IDF-2 rack24
Sheet: Cable Runs (205 rows, 12 columns)
Sample: cable runs
One row per cable. Cable ID and bo
Cable IDPanelPortOutlet / far-end IDLocationCable typeLength (m)
PP01-01PP011RM101-A1Room 101 north wallCat618
PP01-02PP012RM101-A2Room 101 north wallCat618
PP01-09PP019RM102-A1Room 102Cat631
PP02-24PP0224AP-HALL-1Hall ceilingCat6A42
PP11-03PP113RM210-B1Room 210Cat655

Preview shows the first rows of each sheet as calculated. Your copy has the full sheets.

What is in the download

Who it is for

  • Network and systems engineers and IT admins who need cable IDs and both-end labels generated from a spreadsheet instead of typed by hand.
  • Students preparing for networking exams and consultants who want an auditable workbook with a Tests sheet and a Read Me sheet.
  • Anyone who wants to catch duplicate ports or outlets and print label sheets to PDF with the included make_labels.py script.

Who it is not for

  • Not a copy of any cabling standard's labeling scheme, and not a certifier. It does not test or certify cable runs.
  • The label layout is a generic 3 x 10 grid. You need to measure your label stock and pass the millimetre values yourself.
  • The PDF script needs Python 3 and reportlab. The author has not opened the workbook in desktop Excel (it recalculates on open) and has not tested print alignment on a printer.

About this template

Generate cable IDs and both-end labels automatically, catch duplicate ports/outlets, and print label sheets to PDF with the included script.

What you get

  • Patch-Panel-Cable-Labeling-Sheet.xlsx
  • make_labels.py
  • Sample-Labels.pdf
  • Tests sheet inside the workbook: every formula checked against hand-computed answers (shows ALL n TESTS PASS)
  • Read Me sheet with how-to, limits and sources

Who it is for: network and systems engineers, IT admins, students preparing for networking exams and consultants who need a reliable, auditable spreadsheet instead of an ad-hoc one.

How to use: open the workbook, type into the yellow cells, read the computed columns; red-highlighted check cells tell you what to fix. Start with the sample data, then overwrite it with yours.

What it is NOT: Not a copy of any cabling standard's labeling scheme and not a certifier. Label sheet geometry is a generic 3 x 10 layout: measure your stock and pass millimetre values. The script needs Python 3 and reportlab.

Verification: 21 hand-computed tests (see Tests sheet) pass; the build re-evaluates all 1643 formula cells with an independent formula evaluator and finds 0 errors. NOT opened in desktop Excel by the author: recalculates on open. make_labels.py text verified identical to the workbook label formulas; page counts verified (30 labels = 1 page, 35 = 2). Physical print alignment NOT tested on a printer.

*Created with AI assistance and reviewed by the author.*

Questions

What files and formats do I get?

You get Patch-Panel-Cable-Labeling-Sheet.xlsx (6 sheets, 1,643 formulas), Sample-Labels.pdf and the Python script make_labels.py.

Can I edit the formulas?

The workbook is a normal Excel file, so the formulas are visible and the cells can be edited. You type into the yellow cells and read the computed columns. Red check cells tell you what to fix.

How do I start?

Open the workbook and start with the sample data, then overwrite it with yours. To print labels, run make_labels.py with Python 3 and reportlab installed, passing your label stock sizes in millimetres.

Refunds: refunds follow the rules of the marketplace where you buy; if a file is broken we fix or replace it (details). It is a planning tool, not tax, legal, financial or engineering advice. Check rates, limits and rules against the official source before you rely on them. How we check our files.

Free tools that go with it

Guides

More from Network and homelab