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 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 DataandAmount) and import them into the print queue with a single click. - Generate
- Create crisp
CODE_128,CODE_39,QR_CODE,EAN_13,UPC_A, orDATA_MATRIXbarcodes 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 Datato 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.
| Row | Print Data | Amount | Status |
|---|---|---|---|
| 1 | PZN-0482910 | 4 | Ready (4 copies) |
| 2 | PZN-0918234 | 1 | Ready (1 copy) |
| 3 | LOC-HAL2-B14 | 12 | Selected by Search |
| 4 | 8712345678906 | 2 | Ready (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, andDATA_MATRIX. - Smart Stretch Mode: Keeps vertical text height crisp while allowing horizontal bar scaling when
Stretchis 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
BarcodeReaderagainst 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.
| Format | Type | Typical Use Case |
|---|---|---|
| CODE_128 | 1D Linear | Logistics, PZN codes, alphanumeric SKUs, warehouse bins |
| CODE_39 | 1D Linear | Industrial part numbers, automotive & defense labels |
| QR_CODE | 2D Matrix | URLs, long serial strings, mobile scanner workflows |
| EAN_13 / UPC_A | 1D Retail | European & North American retail product packaging |
| DATA_MATRIX | 2D Matrix | Small 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 viaprintui.dllso 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.
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 theAmountcolumn. - 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.
| Print Type | Target Media | Multi-Copy (Amount) |
|---|---|---|
| A4 Barcode | Standard A4 / PDF | Prints 1 to N copies per row |
| A4 Product Manipulation | Standard A4 Warehouse Sheet | Prints 1 to N copies per row |
| GK420d Big Label | Zebra Thermal Label Roll | 1 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.
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 GK420ddriver. For the sharpest barcode edges on thermal labels, open Printing Preferences → Dithering and set Dithering type to None. -
A4 Office Laser & Inkjet
Both
A4 BarcodeandA4 Product Manipulationtemplates render standard A4 pages through the native WindowsPrintDocumentpipeline. -
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.
| Action | When | Where it goes |
|---|---|---|
| Clipboard import | Only 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 & decoding | When you press Generate Barcode or Decode. | Rendered locally in memory using ZXing.Net. |
| Clipboard image copy | When you click the generated barcode preview image. | Copied directly to your local Windows clipboard so you can paste it into other apps. |
| Printing | When you confirm the print dialog. | Sent directly to the local Windows print spooler for your chosen printer. |
| Network / Telemetry | Never. | 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 DataandAmount). 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.Printingfor 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.
- Powered by ZXing.Net. Uses industry-standard
ZXing.Net 0.16.8for fast, accurate 1D and 2D barcode encoding and decoding. - Crisp typography rendering. Renders human-readable barcode labels in bold
Segoe UIwith proportional height preservation when stretching horizontally. - Direct startup into MainWindow. Opens straight into the workspace with your default Windows printer pre-selected and
CODE_128ready 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.
Build or launch PrintSmartPro
Clone Creator-NL/PrintSmartPro on GitHub, open
PrintSmartPro.slnin Visual Studio 2022, restore the NuGet package, and pressF5.Generate a single barcode (optional)
Type any code into the text box, choose a format (such as
CODE_128orQR_CODE), and click Generate Barcode. Click the barcode image to copy it to your clipboard, or click Print Barcode.Copy your rows in Excel
Select 1 column (
Print Data) or 2 columns (Print DataandAmount) in your spreadsheet and pressCtrl+C.Import and verify
Click Import in PrintSmartPro. Use Search Data if you want to verify a specific item in the table.
Select print type and printer
Choose
A4 Barcode,A4 Product Manipulation, orGK420d 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, andDATA_MATRIXwith 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, andA4 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.