Barcode generator.




Create a list of QR Code barcodes
1. Open a new Google Sheet https://drive.google.com/
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("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&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.

image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&A1))
Draw a QR Code 150 x 150 using cell [A1] as a source

For more information: https://developers.google.com/chart/image/docs/making_charts