How to make Kanban cards from a spreadsheet

Part, bin, trigger qty. Print the board

← Back to Blog

How to make Kanban cards from a spreadsheet

Published: · 3 min read · How-to
Do this in the free app: app.mylabelmaker.com. No signup. Design the label, then print on a Zebra or download PNG / PDF / ZPL.

Open bin location template

How to make Kanban cards from a spreadsheet: put part, bin, and trigger qty in a sheet, open the free label maker, set 3x2, map the columns, print the board.

Good to know: This is a simple bin card. It is not a MES or e-kanban system.

How to make Kanban cards from a spreadsheet

  1. Sheet: part, bin, trigger, barcode id.
  2. Open the free label maker and set 3x2 or 4x3.
  3. Map {{part}}, {{bin}}, {{trigger}}, barcode on the id.
  4. Preview two parts. Print the board.

When the trigger changes

Edit the cell, reload the CSV, reprint that row. Keep the JSON as the master face.

Print or save

Zebra thermal: print from the browser with Browser Print at the printer’s DPI. Everyone else: download PNG, JPEG, SVG, PDF, or ZPL. JSON keeps the editable master.

Print the board

Part and trigger from the sheet.

Open free label maker