Barcode generator.

Create a list of QR Code barcodes
1. Open a new Google Sheet
2. In column A (CELL A1) enter the value you want in the barcode. Such as FIRST NAME,LAST NAME,IDNUMBER
3. Then enter this formula in the second column (B).
=if(isblank(A1), "BLANK", image(""&A1))
4. Repeat to create a list. Make sure the formula in column B refers to the correct cell in column A.

Here is a breakdown of the formula
=if(isblank(A1), "BLANK", Display the word BLANK instead of a QR Code if the value in column A is missing.

Draw a QR Code 150 x 150 using cell [A1] as a source

For more information: