Method 1: The Modern & Reliable Way (CSV / Batch Export)
While installing barcode fonts in Excel was common in the 1990s, fonts often fail to calculate check digits properly (especially for Code 128, UPC-A, and EAN-13). The most reliable modern workflow is:
- In Excel or Google Sheets, organize your product data into columns (
SKU,Product Name,Price). - Go to File > Save As > CSV (Comma delimited) (.csv).
- Drag & drop the CSV file into our Bulk Barcode Tool.
- Download your batch in a single organized ZIP package or print directly onto Avery sheets.
Method 2: Using Code 39 Fonts in Excel
If you must render barcodes directly inside an Excel worksheet cell using a TrueType font (like Free 3 of 9), follow these rules:
Excel Formula for Code 39:
="*" & A2 & "*"Code 39 requires asterisk (*) start and stop characters. Set the cell font to "Free 3 of 9 Extended" with a size of 28pt+.
Try the Free Excel / CSV Batch Generator
No software to install, no macros, and zero data leaves your browser.