How to Print Barcode Labels from Google Sheets

Why Google Sheets and BarcodeMaker Work Well Together

Google Sheets is free, accessible from any device, and easy to share with teammates. Many small businesses already use it to manage product lists, inventory, or order data. BarcodeMaker reads CSV files that Google Sheets can export in one click — making it a fast combination for generating batch barcode labels without any specialist software.

Recommended Column Setup

• barcode — required. The Code 128 value to encode. Use SKU numbers, product codes, or item IDs (e.g. SKU001, ITEM-1004, 9780001234567).
• product_name — optional. The text shown below or beside the barcode on the label.
• price — optional. A retail price or reference value displayed on the label.
• sku — optional. An internal stock code separate from the barcode value.

Step 1: Set Up Your Google Sheet

Create or open a Google Sheet with your product data. Put column headers in the first row — names like "barcode", "name", "price", or "sku" work well, but any header name is fine because you will map columns manually after uploading. Make sure every row in the barcode column has a non-empty value. Rows with empty barcode cells will be skipped when generating the PDF.

Step 2: Export from Google Sheets as CSV

In Google Sheets, go to File > Download > Comma-separated values (.csv, current sheet). This downloads a .csv file of the current sheet to your computer. If your spreadsheet has multiple sheets, you will need to download each sheet separately and run BarcodeMaker on each one. The CSV export is plain text and works in any browser without any special handling.

Step 3: Upload the CSV to BarcodeMaker

Go to barcodemaker.xyz, click the upload area, and select the CSV file you just downloaded. BarcodeMaker reads the file in your browser — it is not uploaded to a server, so your product data stays on your device. After uploading, the tool shows a list of columns from your file. Select which column contains your barcode values and which (if any) contain product names, prices, or SKUs.

Step 4: Generate and Download the PDF

Click Generate PDF. BarcodeMaker creates one Code 128 barcode per row, laid out 24 per A4 page, and packages everything into a downloadable PDF. Open the PDF and print it, making sure to set the print scale to exactly 100% or "Actual size". Do not use "Fit to page" or "Scale to paper" options, which would resize the barcodes and shift labels off the label sheet perforations.

Step 5: Print One Test Page First

Before printing a large batch, print a single page, scan several of the barcodes with your actual scanner, and check that the labels align with the perforations on your label sheet. If barcodes scan correctly and labels are aligned, print the full job. If labels are slightly offset, check that you selected the correct paper size (A4 vs Letter) in the print dialog.

Tips for Keeping Your Google Sheet Barcode-Ready

• Use a dedicated "SKU" or "barcode" column and never merge it with other data
• Keep barcode values as plain text — format cells as Text if Google Sheets auto-converts numbers to scientific notation (e.g. 1E+12)
• Avoid leading zeros disappearing — format the column as Text before entering codes like "00123"
• Use a separate sheet for your master product list and generate label exports as a copy, so the original is never accidentally modified

Create barcode labels from Google Sheets