PrintSmartPro

From Excel to hundreds of labels in seconds.

PrintSmartPro is a fast, no-nonsense Windows utility to generate crisp barcodes and batch-print Excel spreadsheets directly to Zebra GK420d thermal printers or A4 warehouse sheets.

  • Free and open source
  • Excel clipboard batch import
  • Zebra GK420d & A4 ready
  • Zero telemetry
PrintSmartPro — Interactive Barcode Studio Live preview, try it
Click barcode to copy
11223344

      
Printer: ZDesigner GK420d • Ready Try batch Excel import ↓
Version 1.0.0

PrintSmartPro is live on GitHub under the MIT licence. The repository includes the complete C# Windows Forms solution (PrintSmartPro.sln), ZXing.Net barcode integration, A4 and Zebra GK420d print templates, and full build instructions.

Printing fifty barcodes from Excel shouldn't take twenty minutes.

In warehouses, logistics hubs, pharmacies, and workshops, the data you need to print usually lives in an Excel spreadsheet: a column of product codes, PZN numbers, or shelf locations, and a column for how many copies you need.

Yet most barcode and label suites force you through heavy templates, cloud subscriptions, proprietary database wizards, or manual one-by-one copying.

PrintSmartPro was built on the shop floor to solve that exact bottleneck. Copy two columns from Excel, click Import, pick your printer, and print the entire batch at once — or generate and copy a single barcode in one click.

Built for speed, clarity, and zero friction

Every part of PrintSmartPro follows six practical rules.

Paste
Copy 1 or 2 columns straight from Excel (Print Data and Amount) and import them into the print queue with a single click.
Generate
Create crisp CODE_128, CODE_39, QR_CODE, EAN_13, UPC_A, or DATA_MATRIX barcodes instantly.
Copy
Need a barcode inside Word, Excel, or an email? Click the generated barcode preview image to copy the bitmap straight to your Windows clipboard.
Verify
A built-in barcode decoder reads the generated bitmap back into text so you can verify scannability before printing hundreds of labels.
Confirm
Batch jobs show a clear confirmation warning with the target printer name before dispatching potentially hundreds of pages or thermal labels.
Local
Runs 100% offline on Windows. No cloud accounts, no telemetry, no background services, and completely free under the MIT licence.

What PrintSmartPro does

Four focused modules in a single clean window.

Import spreadsheet columns and print at once

Select your cells in Microsoft Excel, LibreOffice Calc, or Google Sheets, press Ctrl+C, and click Import in PrintSmartPro. The clipboard parser splits tab-separated columns automatically into a live data grid.

  • Column 1 (Print Data): The SKU, PZN code, serial number, or warehouse bin location.
  • Column 2 (Amount): How many copies to print for that item. If you only copy a single column, it defaults to 1 copy.
  • Instant Grid Search: Type any value in Search Data to highlight and scroll directly to that row in the grid.
  • Safety Confirmation: Prompts you with the selected printer name before starting a mass print run.

Why it matters. You do not need to save CSV files, map database fields, or deal with file locks while Excel is open. Clipboard import works in two seconds.

Imported DataGridView (example Excel clipboard data)
RowPrint DataAmountStatus
1PZN-04829104Ready (4 copies)
2PZN-09182341Ready (1 copy)
3LOC-HAL2-B1412Selected by Search
487123456789062Ready (2 copies)

Multi-format generation, clipboard copy, and decoding

Powered by ZXing.Net, the interactive barcode generator lets you create individual 1D and 2D barcodes on the fly, inspect them visually, and copy or print them immediately.

  • 6 Symbologies built in: CODE_128 (default), CODE_39, QR_CODE, EAN_13, UPC_A, and DATA_MATRIX.
  • Smart Stretch Mode: Keeps vertical text height crisp while allowing horizontal bar scaling when Stretch is checked.
  • One-Click Clipboard Copy: Click directly on the barcode preview box to copy the rendered image to your Windows clipboard, with confirmation in the status bar.
  • Built-in Decoder: Click Decode to run ZXing's BarcodeReader against the rendered bitmap and verify the decoded string.

Quick single label. Clicking Print Barcode next to Generate Barcode sends that single code directly to your selected printer using the Zebra big label layout.

Supported ZXing.Net Barcode Formats
FormatTypeTypical Use Case
CODE_1281D LinearLogistics, PZN codes, alphanumeric SKUs, warehouse bins
CODE_391D LinearIndustrial part numbers, automotive & defense labels
QR_CODE2D MatrixURLs, long serial strings, mobile scanner workflows
EAN_13 / UPC_A1D RetailEuropean & North American retail product packaging
DATA_MATRIX2D MatrixSmall electronics, medical/pharma unit-dose marking

Direct support for Zebra GK420d thermal printers

Thermal label printers require high-contrast, properly proportioned layouts so barcodes scan reliably on the first pass. PrintSmartPro includes a dedicated GK420d Big Label print module (`PrintZebraLabelBigGK420D`).

  • Dedicated Thermal Layout: Formats each row's barcode and human-readable value onto a high-visibility label layout.
  • Any Installed Printer: Automatically enumerates all installed Windows printers and defaults to your active system printer (such as ZDesigner GK420d).
  • One-Click Driver Settings (⚙️): Opens the native Windows printer preferences dialog directly from PrintSmartPro via printui.dll so you can adjust darkness, speed, or dithering in seconds.

Pro Tip for Zebra GK420d. Set Dithering to None in your ZDesigner printing preferences so barcode bars print as solid black thermal lines without halftone dots.

Direct Printer & Driver Integration
Selected Printer: ZDesigner GK420d
Print Type: GK420d Big Label
Driver shortcut: rundll32.exe printui.dll,PrintUIEntry /e /n "ZDesigner GK420d"

A4 Barcode & Product Manipulation sheets

When you are printing to a standard office laser or inkjet printer (or exporting via Microsoft Print to PDF), PrintSmartPro offers two structured A4 document modes.

  • A4 Barcode (PrintA4Barcode): Prints clean A4 barcode sheets for pallet signage, binder covers, or staging areas, automatically repeating each item according to the Amount column.
  • A4 Product Manipulation (PrintA4ProductManipulation): Generates formatted A4 warehouse product handling sheets with centered headers and scannable `CODE_128` barcodes for inventory and quarantine workflows.

PDF archiving included. Select Microsoft Print to PDF in the printer dropdown to save any A4 or label run as a PDF document.

Built-in Print Templates
Print TypeTarget MediaMulti-Copy (Amount)
A4 BarcodeStandard A4 / PDFPrints 1 to N copies per row
A4 Product ManipulationStandard A4 Warehouse SheetPrints 1 to N copies per row
GK420d Big LabelZebra Thermal Label Roll1 label per row / single quick print

Try the Excel Batch Import Simulator

Paste or edit tab/space-separated rows below (just like copying 1 or 2 columns from Excel) to see how PrintSmartPro parses your data, searches rows, and plans the print job.

Up to 2 columns per line. If Amount is omitted, 1 copy is printed.
Load sample spreadsheet preset

Hardware & Zebra GK420d Optimization

PrintSmartPro works with any Windows printer driver, and includes a quick-access gear button (⚙️) to configure thermal printer preferences on the fly.

  • Zebra GK420d Thermal Printer

    Tested with the official ZDesigner GK420d driver. For the sharpest barcode edges on thermal labels, open Printing Preferences → Dithering and set Dithering type to None.

  • A4 Office Laser & Inkjet

    Both A4 Barcode and A4 Product Manipulation templates render standard A4 pages through the native Windows PrintDocument pipeline.

  • Microsoft Print to PDF

    Built right into Windows 10 and 11 — select it in the Printer dropdown to test batch runs or generate PDF barcode sheets for email and archiving.

  • Direct Driver Shortcut

    Clicking the ⚙️ button in PrintSmartPro executes the native Windows PrintUI command for your selected printer:

rundll32.exe printui.dll,PrintUIEntry /e /n "ZDesigner GK420d"

100% Offline & Private by Design

Warehouse inventory, product codes, and internal logistics sheets belong on your machine — nowhere else. Here is everything PrintSmartPro does with your data.

ActionWhenWhere it goes
Clipboard importOnly when you press the Import button.Parsed in memory into an in-app DataTable. Never saved to disk or sent over the network.
Barcode generation & decodingWhen you press Generate Barcode or Decode.Rendered locally in memory using ZXing.Net.
Clipboard image copyWhen you click the generated barcode preview image.Copied directly to your local Windows clipboard so you can paste it into other apps.
PrintingWhen you confirm the print dialog.Sent directly to the local Windows print spooler for your chosen printer.
Network / TelemetryNever.Nothing. Zero internet connections, zero analytics, zero accounts.

Good to know before you use it

Clear expectations save time on the shop floor. Here are the current design boundaries.

  • Maximum 2 Excel columns

    The clipboard importer expects 1 column (Print Data) or 2 columns (Print Data and Amount). If you copy 3 or more columns at once, PrintSmartPro will prompt you to check your selection.

  • Batch print dispatches per-page jobs

    Each item and copy in a batch loop dispatches a print document to the Windows spooler. That is why PrintSmartPro asks for confirmation before starting a batch run.

  • Windows Desktop (.NET Framework 4.8)

    Built with Windows Forms and System.Drawing.Printing for Windows 10 and Windows 11. It does not run natively on macOS or Linux.

Clean C# architecture

PrintSmartPro is written in C# on .NET Framework 4.8 using Windows Forms and ZXing.Net (`0.16.8`). The entire solution is compact, readable, and easy to customize in Visual Studio.

How PrintSmartPro is structured Excel clipboard data and manual text input feed into MainWindow.cs, which uses ZXing.Net for barcode rendering and dispatches print jobs to three dedicated form templates. Excel Clipboard (TSV) 1–2 columns: Print Data & Amount Single Barcode Input Format selector, Stretch, Decode MainWindow.cs (Central Dashboard) DataGridView queue, search, printer selector, printui.dll settings ZXing.Net BarcodeWriter & BarcodeReader integration PrintA4Barcode Standard A4 barcode sheets (1..N copies) PrintA4Product... A4 warehouse product manipulation sheets PrintZebraLabel... Zebra GK420d thermal big label layout Windows PrintDocument Spooler (Zebra GK420d / Office A4 / PDF)
  • Powered by ZXing.Net. Uses industry-standard ZXing.Net 0.16.8 for fast, accurate 1D and 2D barcode encoding and decoding.
  • Crisp typography rendering. Renders human-readable barcode labels in bold Segoe UI with proportional height preservation when stretching horizontally.
  • Direct startup into MainWindow. Opens straight into the workspace with your default Windows printer pre-selected and CODE_128 ready to go.
  • Easy to extend. Each print template is a self-contained Windows Form (PrintA4Barcode.cs, PrintA4ProductManipulation.cs, PrintZebraLabelBigGK420D.cs), making custom label sizes simple to add in Visual Studio Designer.

Using it, step by step

From cloning the repository to printing your first batch.

  1. Build or launch PrintSmartPro

    Clone Creator-NL/PrintSmartPro on GitHub, open PrintSmartPro.sln in Visual Studio 2022, restore the NuGet package, and press F5.

  2. Generate a single barcode (optional)

    Type any code into the text box, choose a format (such as CODE_128 or QR_CODE), and click Generate Barcode. Click the barcode image to copy it to your clipboard, or click Print Barcode.

  3. Copy your rows in Excel

    Select 1 column (Print Data) or 2 columns (Print Data and Amount) in your spreadsheet and press Ctrl+C.

  4. Import and verify

    Click Import in PrintSmartPro. Use Search Data if you want to verify a specific item in the table.

  5. Select print type and printer

    Choose A4 Barcode, A4 Product Manipulation, or GK420d Big Label, pick your target printer, and click Print Document.

Where it stands and what comes next

Everything in Version 1.0.0 is available in the repository today.

In version 1.0.0

  • Excel clipboard batch import Included

    1- or 2-column tab-separated clipboard import into a searchable DataGridView.

  • Multi-format barcode generator Included

    CODE_128, CODE_39, QR_CODE, EAN_13, UPC_A, and DATA_MATRIX with Stretch mode.

  • One-click clipboard copy & decoder Included

    Click the barcode preview to copy the bitmap, or click Decode to verify the encoded value.

  • Zebra GK420d & A4 templates Included

    Dedicated forms for GK420d Big Label, A4 Barcode, and A4 Product Manipulation.

  • Printer selector & driver shortcut v1.0.0

    Select any installed Windows printer, open native driver preferences (⚙️), and confirm before batch printing.

Ideas for future releases

  • Direct .xlsx / .csv file open

    Load Excel and CSV files directly from disk in addition to clipboard paste.

  • Modern .NET 8 upgrade

    Migrate the project file to SDK-style .NET 8 Windows Forms for high-DPI display scaling.

  • Custom label dimensions

    User-configurable width, height, and font size presets for additional Zebra and Brother thermal label rolls.

  • Batch progress bar & cancel

    Live progress indicator in the status bar with ability to pause or cancel large print loops.

Questions people ask

Is PrintSmartPro really free?

Yes. PrintSmartPro is free and open source under the MIT licence, created by Biohazard Corp (@Creator-NL).

How do I format my Excel sheet before copying?

Put the barcode text (SKU, PZN, location) in the first column and the number of copies to print in the second column. Do not include a header row when copying — just select the data cells, press Ctrl+C, and click Import.

What happens if I only copy one column from Excel?

PrintSmartPro accepts a single column too and defaults the print amount to 1 copy per row.

Do I need a Zebra GK420d printer to use it?

No. You can use any standard Windows A4 printer, other thermal printers, or Microsoft Print to PDF. You can also use PrintSmartPro purely as a desktop barcode generator and click the barcode image to copy it into Word, Excel, or design tools.

Why do my thermal barcodes look blurry or dotted?

Printer drivers often enable halftone dithering by default. Click the ⚙️ button next to your printer in PrintSmartPro, go to the Dithering tab in your Zebra driver preferences, and select None.

Does PrintSmartPro send any of my spreadsheet data to the internet?

Never. PrintSmartPro makes zero network connections. All clipboard parsing, barcode generation, and printing happen locally on your PC.

Generate barcodes. Print Excel batches at once.

Version 1.0.0 is available on GitHub under the MIT licence.

Made by Biohazard Corp. More at biohazard-corp.nl.