Free tools Windows power users keep installed
One-click scans. No signup required.
Excel has no universal built-in “Insert Barcode” command. You create a barcode by choosing the right symbology, preserving the source value as text, and using an add-in, an encoder with a barcode font, a VBA generator, or a separate label workflow. For most people making a list of internal IDs, an Excel barcode add-in is the simplest reliable option; Excel for the web usually needs a web-compatible image service instead.
Do not treat a barcode font as a complete generator. The encoder must add the structure required by the symbology, and the finished symbol must be scanned from the final printout—not merely judged by how it looks on screen.
Choose the barcode type before opening Excel
A barcode format is part of the data requirement, not just a visual style. Ask who will scan it and where it will be used.
| Format | Suitable use | Important qualification |
|---|---|---|
| Code 128 | Internal SKUs, inventory IDs, assets and shipping data | Compact and alphanumeric, but it needs proper encoding. |
| Code 39 | Industrial, library and internal tracking | Less data-dense; often uses start and stop characters. It is not a universal retail format. |
| UPC-A / EAN-13 / EAN-8 | Retail products | Use an assigned, valid product number. Rendering a pattern does not create a legitimate retail identifier. |
| ITF-14 | Outer cartons and shipping containers | Use only where the packaging or trading partner requires it. |
| GS1-128 | Supply-chain and logistics records | Requires GS1 Application Identifiers and their prescribed data structure. |
| QR Code | URLs, text, contact details and other 2D data | Usually better for a phone scan than for a retail product number. |
| Data Matrix / PDF417 | High-density industrial, logistics or regulated data | Choose a generator that supports the required format and rules. |
Commercial Excel tools commonly support several of these formats, but support differs by product and implementation. See IDAutomation’s Excel integration overview.
#1 Best Overall
- For Home and Small Business: Prints 3/4" - 2" wide labels; ideal for home organization (storage bins, bottle, jar, food container, etc.), small business (address, product info, QR Code, barcode, brand logo, etc.), or school and office supplies (name tag, folder, documentation, etc.)
- Versatile App Editing Function: Easily add images from your phone, tablet or PC; customize your labels with 30+ fonts, 50+ frames, and 660+ icons; all free to use
- Enhanced Image Quality: The App delivers precise image processing capabilities, resulting in a high-resolution and clear output; enhanced aesthetic appeal, formality, and richness
- Easy to Use: The APP is completely free, requires no registration; features auto label size recognition; no ink or toner needed; create labels quickly and easily
- Versatile Label Compatiblity: Compatible with square, round, address, cable, jewelry and file labels, to meet all your needs; ensuring a perfect fit for any project; keeps everything neat and tidy
Prepare the Excel data safely
Most barcode failures begin before generation. Excel may change an identifier while importing or entering it.
Keep identifiers as text
- Select the source column, such as
A2:A100. - Choose Home > Number Format > Text before entering or importing values.
- For a single value, a leading apostrophe also preserves the literal text:
'001234567890. - Recheck imported files; changing the display format after Excel has already converted a value does not restore lost digits.
Long numeric strings can become scientific notation such as 4.51E+11, and leading zeros can disappear. IDAutomation documents these Excel conversion problems and recommends text formatting or a leading apostrophe: IDAutomation Excel integration.
Use separate source and barcode columns
| Item ID | Description | Barcode output |
|---|---|---|
001234567890 |
Blue notebook | Generated symbol |
SKU-AX19-004 |
Replacement part | Generated symbol |
- Keep one identifier per row.
- Remove accidental spaces and hidden characters unless they are intentionally encoded.
- Keep human-readable text in its own cell or beneath the symbol.
- Confirm that the chosen symbology accepts the letters, punctuation, spaces or Unicode characters in your data.
Barcode software encodes the underlying cell value, not necessarily the value you think the cell is displaying.
Easiest method: use an Excel barcode add-in
An add-in is usually the best choice for beginners, lists, linked barcodes and label sheets. TEC-IT’s TBarCode Office provides an illustrated example: it supports individual symbols, lists, cell-linked output, Code 128, UPC/EAN, GS1-128 and QR Code through the Excel Add-Ins tab and TBarCode Panel. See the official TBarCode Office page.
Create one barcode
- Install the add-in and open the workbook in desktop Excel.
- Open Add-Ins > TBarCode Panel.
- Select the destination cell.
- Choose the required type, such as Code-128, UPC/EAN, GS1-128 or QR code.
- Enter the data or select its source cell.
- Set available dimensions and parameters, then choose Insert Barcode.
- Scan a printed test before producing a batch.
Generate a list or link a symbol to a cell
- Select the cells containing the source values.
- Open the panel and select the barcode type.
- Choose Insert Barcode for the list.
- For a dynamic result, select the barcode, choose Link to Cell, and select the source cell.
- Change the source value and verify that the symbol updates.
Linked updating is a feature of the particular add-in, not a native Excel property. Add-ins can be blocked by company policy, and recipients without the same add-in may see a different workbook.
Rank #2
- 【No Brand Lock-in】 No RFID chips, no brand lock-in. Use any standard thermal label rolls you like. Say goodbye to expensive proprietary paper and enjoy the freedom to choose affordable options.
- 【2" Printing for Business & Home】 The CLABEL 221B supports a wider range of 25mm-50mm (0.98-2Inch). Perfect for small business needs. Generate scannable barcodes, address labels, price tags, and jewelry labels. One printer for retail, bakery, warehouse, and office organization
- 【NO Learning Curve – Easy Setup】 Open, connect, print. Our "Clabel trade" App offers quick Bluetooth connection in seconds. Access hundreds of creative templates, icons, and fonts without extra cost. Supports Excel batch printing and image-to-text — making professional labeling effortless.
- 【Durable, Sharp & Smudge Quality】 Our matched thermal labels are waterproof, oil-proof, and highly resistant to friction or scratches. Whether used in a busy kitchen, or a high-traffic retail shelf, your stickers will stay sharp and without tearing
- 【Bluetooth Connection】 Our printer supports Bluetooth connection with Android and iOS smartphones. It does not support iPad. For computer connection, please use USB cable.
Alternative: a barcode font plus an encoder
A font turns specially encoded characters into bars; it normally cannot convert arbitrary input into a valid Code 128, UPC/EAN or GS1 symbol by itself. A working font solution needs:
- the matching barcode font;
- an encoder or formula that adds start, stop, check and symbology-specific characters; and
- the font installed on every computer that displays or prints the workbook.
One vendor-specific Code 128 example is:
=Code128(A2)
Apply the matching Code 128 font to the formula result. The function name and font name are not universal; a formula from one package will not work with an unrelated font. IDAutomation’s documented VBA/font workflow is aimed at Windows desktop Excel and older versions, including Excel 2007–2016; it should not be assumed to work in Excel for the web or every Mac installation. See IDAutomation’s VBA import instructions.
- Install the vendor’s font.
- Install or import that vendor’s encoder.
- Put the raw value in
A2. - Enter the vendor’s encoder formula in
B2. - Apply the matching barcode font to
B2. - Resize without distorting the symbol, add human-readable text separately, and scan the printout.
“Just install a barcode font” fails when start/stop characters, check digits or supported character rules are missing. Font-based files are also fragile to share: the matching TrueType or OpenType font must be installed locally on each workstation.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesDesktop Excel: use a native VBA barcode generator
A native generator embeds barcode-generation functions in a desktop workbook and can output images, shapes or other formats. IDAutomation documents support for locally installed Excel 2007 and later on Windows and Excel 2016 and later on Mac with VBA support. Its generator is not compatible with Excel for the web because it requires VBA: IDAutomation Native Barcode Generator manual.
For example, its Code 128 function is:
=IDAutomation_NXLS_C128(A3)
A documented QR Code example is:
=IDAutomation_NXLS_QRCode(A3,3,,,,,,,4)
Installation involves extracting the generator files, opening the supplied macro-enabled workbook, and optionally activating an add-in through File > Options > Add-ins. Save macro-enabled workbooks as .xlsm where required. Users may see security warnings, need to enable content, or experience slower sheets when thousands of images or shapes are generated.
Rank #3
- Lightning Speed: Transform your labeling efficiency with this professional thermal label printer, delivering an impressive 93 labels per minute at crystal-clear 300 dpi resolution - perfect for high-volume shipping and business needs
- Dual-Color Innovation: Elevate your labeling with Brother Genuine technology that enables both black and red printing capabilities, allowing you to create eye-catching labels that command attention and enhance your professional branding
- Versatile Applications: Dominate your organization needs with this powerful label maker machine, perfect for creating professional shipping labels, file folders, name badges, and postage labels - streamlining your business operations
- Advanced Integration: Experience seamless connectivity with Windows and Mac systems, featuring Brother Genuine Plug & Label technology that enables instant printing from Microsoft Word, Excel, and Outlook without additional software installation
- Professional Design: Maximize productivity with the built-in auto-cutter for precise label finishing, compatible with Brother Genuine DK pre-sized labels and continuous-length tapes up to 3 ft long for custom banners and signage
Excel data to printed labels: use Word mail merge
Microsoft supports a different workflow in which Excel supplies the records and Word creates the barcode label. It is useful for Avery-style sheets or one barcode per merged record, but the barcode object lives in Word rather than Excel. Microsoft’s instructions are at Add barcodes to labels.
- Prepare and name the Excel data range.
- In Word, choose Mailings > Start Mail Merge > Labels and select the label vendor and product.
- Choose Mailings > Select Recipients > Existing List, then select the workbook.
- Insert a barcode field into the first label.
- Choose Mailings > Update Labels, then Preview Results.
- Print a test sheet and scan it.
Microsoft’s field-code pattern is:
{ DisplayBarcode "{ MergeField FirstName } { MergeField LastName } { MergeField City }" CODE128 t h 1440| }
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Use the field-code support and symbology appropriate to your Word edition; Excel remains the data source in this method.
Excel for the web and Mac: check compatibility first
- Excel for the web: desktop VBA and many legacy add-ins do not run in the browser. A web-compatible image or streaming integration, such as an
IMAGE-based service, is a separate solution and sends data to an external dependency. Review IDAutomation’s integration options. - Mac: compatibility depends on the product and Excel version. IDAutomation documents Excel 2016 and later with VBA support; fonts still must be installed. Some workflows recommend EPS or BMP output for transfer between platforms.
- Microsoft 365: identify whether you are using the desktop subscription app, Excel for the web, Mac Excel or a managed installation where add-ins and macros are disabled.
Print and scan the finished barcode
A technically valid symbol can fail after resizing, printing or placing it on a label.
- Print at the intended final size and do not stretch the image non-proportionally.
- Keep the blank margin, or quiet zone, around the symbol; do not put borders, text or graphics inside it.
- Use strong contrast, normally dark bars on a light background.
- Test the actual printer, label stock and scanner used at work.
- Scan several samples at different orientations and distances. A phone app is useful for QR Codes; a handheld scanner is essential for the operational test.
- Keep human-readable data beneath or beside the symbol where the workflow requires it.
Quiet-zone defaults vary by barcode type and generator; see the IDAutomation generator manual. A successful decode proves only that a scanner read the symbol—it does not prove that a UPC/EAN, carrier label or regulated identifier is legitimately assigned or compliant.
Rank #4
- Bluetooth Wireless Connection: KNAON Bluetooth shipping label printer enables wireless printing. For Mobile users, download the 'FlashLabel Pro' app from APP Store or Google Play for printing. Also, supports Windows and macOS, and can directly connect to the printer by downloading the 'FlashLabel Pro' App. Windows 7 or later computers can also print via Bluetooth by installing the latest advanced driver. Note: All devices CANNOT be connected directly to Bluetooth, and must be used through the 'FlashLabel Pro' app.
- USB Cable Connectivity: This printer ensures seamless USB connectivity with macOS, Windows (7 and above), ChromeOS, and Linux. KNAON printer features a built-in USB drive preloaded with drivers and tutorial videos for a fast and hassle-free setup. For ChromeOS, need to install 'FlashLabel' extension to your Google Chrome.
- Versatile DIY Labeling Options: KNAON Thermal Shipping Label Printer offers a vast selection of pre-designed templates, including 3,000+ templates, 5,000+ icons, and 100+ fonts available in the app. Designed for both professional and personal use, it supports various thermal paper sizes, ensuring effortless customization for all your labeling needs. Ideal for printing DIY shipping labels, barcode labels, thank-you labels, mailing labels, name tags, price tags, and various small thermal labels.
- Seamless Multi-Platform Compatibility: This Bluetooth shipping label printer works effortlessly with all major platforms, including Amazon, eBay, Shopify, USPS, UPS, Etsy, PayPal, Poshmark, DHL, and more, ensuring smooth and efficient label printing. (Note: Save the logistics label as a PDF file on the shipping platforms, then import it into the 'FlashLabel Pro' app for printing).
- Portable & Stylish Design: KNAON multi-function thermal label printer offers user-friendly operation in a compact design. Its perfect size (7.17 x 3.9 x 3.43 inches) makes it simple to store anywhere. With a fast printing speed of up to 180 mm/s and support for paper widths from 1.5 to 4.2 inches. The package also includes 10 test printing papers to get you started right away.
Troubleshooting common failures
| Symptom | Likely cause | Recovery |
|---|---|---|
| Bars display as ordinary text | Missing or wrong font, no encoder, or raw data in the output cell | Confirm the exact font and vendor formula, reinstall if needed, and test on the printing computer. |
| Scanner will not read | Wrong symbology, missing check structure, unsupported characters, small size, poor contrast, lost quiet zone or altered data | Compare the decoded value with the source, re-enter the source column as Text, enlarge proportionally, restore margins and print at 100%. |
| Leading zeros disappear | Excel treated the identifier as a number | Format as Text before entry or import, use an apostrophe, and verify the underlying value. |
| Long values show scientific notation | Excel converted the number during import or entry | Re-import with the field explicitly typed as text; changing display formatting afterward may not recover digits. |
#NAME? or an ambiguous-name error |
Add-in inactive, macros disabled, wrong vendor function, or duplicate VBA modules | Activate the correct add-in, enable content where permitted, use the matching function, and remove duplicate encoder modules. IDAutomation discusses duplicate VBA files at its support guide. |
| Works on one computer only | Missing font or add-in, blocked macros, Excel for the web, or an external image dependency | Document prerequisites, distribute embedded images where appropriate, save in the correct format and test on a clean machine. |
| Add-in does not appear | Wrong Excel edition, disabled add-in, policy restriction or incomplete installation | Check File > Options > Add-ins, inspect disabled/inactive items, restart Excel and reinstall the vendor package. Use desktop Excel rather than the web version for desktop add-ins. |
Which method should you choose?
| Your situation | Most suitable route | Main trade-off |
|---|---|---|
| Beginner, many rows, linked values or several symbologies | Excel barcode add-in | Requires installation and compatible licenses on users’ computers. |
| Controlled offline workbook with simple linear symbols | Barcode font plus matching encoder | Every workstation needs the exact font and encoder. |
| Desktop workbook needing embedded generation and multiple outputs | Native VBA generator | Macro security and desktop-only compatibility. |
| Label sheets driven by an Excel list | Word mail merge | Generation and layout happen in Word, not Excel. |
| Excel for the web | Web-compatible image or streaming service | External availability, privacy and offline limitations. |
| Production labels, serialization, printer control or compliance | Dedicated label or inventory software | More cost and setup, but better operational controls than a spreadsheet. |
Choose Code 128 for many internal alphanumeric identifiers, but do not use it to bypass a retail, carrier or industry specification. For an occasional QR Code, a separate QR generator may be simpler than installing Excel software. A paid tool can render a symbol; it cannot assign a valid UPC/EAN or replace operational validation.
Frequently Asked Questions
Can I create a barcode in Excel for the web?
Not with desktop VBA or many legacy add-ins. Use a web-compatible image or streaming integration, and consider whether sending identifiers to an external service is acceptable.
Is changing a cell to a barcode font enough?
Usually not. Most symbologies require an encoder that adds start, stop and check information before the matching font renders the result.
Why does my barcode scan on screen but fail on paper?
Printing can change scale, contrast and the quiet zone. Print at final size on the actual label stock, preserve proportions and test with the operational scanner.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →
