There are formulas to convert the item numbers from one column into barcodes in another column. The formula to do this also adds an asterisk "*" to the beginning and end of the item number to provide start/stop instructions for the barcode to be properly read. If you add additional rows, make sure to copy the formula down the entire barcode column. An example of this formula is: (="*"&A3&"*") with the item number appearing in Column A.

In order to view the part numbers in Column B as barcodes, and properly print them as readable barcodes, you will need to download a barcode font.

Step 1.) On whichever computer(s) will be printing these types of barcodes, you'll need to install barcode font files. A free copy of a Code39 barcode font is available on our site here: Code39 Barcode Font

Step 2. ) Go to your downloads folder and click on the .ttf files for these fonts and choose "Extract All"

Step 3. ) Once extracted, you'll want to move these .ttf files into the C:\Windows\Fonts folder. This installs them for your user on your computer.

Step 4. ) Open up the barcode spreadsheet to ensure the font appears as a barcode, edit your items as needed, then print.

A 2D QR code is a for all intents and purposes, an image and Google Sheets as well as newer versions of Microsoft Excel have a formula for inserting Images.

It's called: IMAGE

How to add QR codes to your spreadsheet:

1. Add a formula to the cell you want the QR Code to appear in. The Barcode Book Template has this formula in Column B. This formula would be: =IMAGE("https://quickchart.io/qr?text=" & ENCODEURL(A3))

In this example A3 is the cell where the item number appears.

2. Copy the formula down the rows and you'll see QR Codes appear for each item.

3. Download the workbook/sheets as a PDF to save the images permanently.