How to create barcodes in Google Sheets

By Jake Marsh · Updated

To create barcodes in Google Sheets, put one value per row in a column, open Extensions, Rowcode, Open Rowcode, choose a Code type such as Code 128 or EAN-13, pick that column under What goes in each code and click Make codes. A barcode image appears in each row, in the column you chose, and any value that can't become a barcode gets a note saying why.

Pick the barcode type

The right type depends on what will scan it and what's in your column.

Your valuesUseNotes
Your own SKUs, bin numbers, asset tags with lettersCode 128Letters, digits and symbols. Packs long runs of digits tightly
Products sold in stores, with a 13 digit GTINEAN-13Digits only. Type 12 and Rowcode adds the check digit
Products sold in US and Canadian stores, 12 digitsUPC-ADigits only. Type 11 and Rowcode adds the check digit
Small packages with an 8 digit numberEAN-8Digits only. Type 7 digits
Shipping cartons with a GTIN-14ITF-14Digits only. Type 13 digits
Badges or older scanners that only read Code 39Code 39Uppercase letters, digits, space and - . $ / + %

For products you sell through retailers, the number itself has to come from GS1, the body that issues retail barcodes. Rowcode draws the barcode for the number you have; it doesn't issue numbers. For your own stock and equipment, any unique value works with Code 128.

Steps

  1. Put headers in row 1 and one item per row, for example SKU in column A and Product in column B.
  2. Fix number columns first. If your values start with zeros, select the column, choose Format, Number, Plain text, and retype them. Otherwise Sheets drops the zeros before Rowcode sees them.
  3. Open Rowcode and pick the Code type.
  4. Choose A column under What goes in each code and pick the column.
  5. Pick Put the codes in column. Rowcode suggests a new column at the right.
  6. Set Rows to all rows, or click Selection to use only the rows you've selected.
  7. Choose an Image size. Small is quick and fine on screen; Large is best for printing. Tick Print the value under barcodes to show the digits under the bars, and Make rows tall enough to see the codes so they aren't squashed.
  8. Click Make codes.

When a row doesn't become a barcode

The code cell for that row says what's wrong in plain words:

MessageWhat to do
EAN-13 check digit is wrong: the last digit should be 1Your number has a typo, or the last digit isn't a check digit. Fix the value
EAN-13 needs 12 digits, or 13 with the check digitAdd or remove digits
takes digits onlyRemove letters and symbols, or switch to Code 128

Fix the values and click Make codes again. Rows that were already right aren't remade, so they don't count again against your trial.

Keep barcodes in step with the sheet

Tick Make or update a row's code when its value changes in the Automatic section. A new row, an edited SKU or a row added by a Google Form gets a fresh barcode within seconds. To print what you've made, see how to print barcode labels from Google Sheets.

What it costs

Rowcode is $4.99 a month or $39 a year per Google account. Free trial: 100 codes or 14 days, whichever comes first. No card needed. Every plan and the install link are on the Rowcode page.

Rowcode: Bulk QR Codes & Barcodes

Bulk QR codes and barcodes from Google Sheets rows, made inside Google, never expiring $4.99 a month or $39 a year per Google account.


Questions

Will a phone scan these barcodes?

Yes, with a barcode scanning app. A USB or Bluetooth barcode scanner reads them too and types the value wherever your cursor is, including a Google Sheets search box.

Can I show the barcode in a cell and also keep the number?

Yes. The barcode goes in its own column, so your value column stays as it was. Sorting or filtering the sheet moves the barcode with its row.

Can I use a barcode font instead?

Fonts can draw Code 39 when you add asterisks around the value, but Code 128 and EAN need start, stop and check characters calculated first, which is the part Rowcode does for you.

Can I make QR codes and barcodes in the same sheet?

Yes. Make the barcodes into one column, then change the Code type to QR and the output column, and click Make codes again.


More Rowcode guides


More Google guides