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 values | Use | Notes |
|---|---|---|
| Your own SKUs, bin numbers, asset tags with letters | Code 128 | Letters, digits and symbols. Packs long runs of digits tightly |
| Products sold in stores, with a 13 digit GTIN | EAN-13 | Digits only. Type 12 and Rowcode adds the check digit |
| Products sold in US and Canadian stores, 12 digits | UPC-A | Digits only. Type 11 and Rowcode adds the check digit |
| Small packages with an 8 digit number | EAN-8 | Digits only. Type 7 digits |
| Shipping cartons with a GTIN-14 | ITF-14 | Digits only. Type 13 digits |
| Badges or older scanners that only read Code 39 | Code 39 | Uppercase 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
- Put headers in row 1 and one item per row, for example
SKUin column A andProductin column B. - 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.
- Open Rowcode and pick the Code type.
- Choose A column under What goes in each code and pick the column.
- Pick Put the codes in column. Rowcode suggests a new column at the right.
- Set Rows to all rows, or click Selection to use only the rows you've selected.
- 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.
- Click Make codes.
When a row doesn't become a barcode
The code cell for that row says what's wrong in plain words:
| Message | What to do |
|---|---|
| EAN-13 check digit is wrong: the last digit should be 1 | Your 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 digit | Add or remove digits |
| takes digits only | Remove 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.