Step 1: Log into your Google Drive account.
Screen Shot 2013-07-17 at 7.33.37 PM

Step 2: Create a new spreadsheet. Screen Shot 2013-07-17 at 7.33.30 PM

Step 3: Label Column A “Message.”
Screen Shot 2013-07-17 at 7.38.35 PM

Step 4: Label Column B “QR Code.”
Screen Shot 2013-07-17 at 7.38.47 PM

Step 5: Enter some text or URLs in column A.
Screen Shot 2013-07-17 at 7.42.22 PM

Step 6: In Cell B2, enter this formula (or copy and paste it.)
=image(“https://chart.googleapis.com/chart?chs=150×150&cht=qr&chl=” & A2)
Screen Shot 2013-07-17 at 7.46.53 PM

Step 7: Press Enter and a QR code will appear!
Screen Shot 2013-07-17 at 7.46.17 PM

Step 8: Resize the cell to make the QR code bigger.
Screen Shot 2013-07-17 at 7.50.22 PM

Step 9: Click and drag the corner of B2 to fill the entire column.
Screen Shot 2013-07-17 at 7.51.27 PM

Step 10: Resize the other rows and voila! You’re done!
Screen Shot 2013-07-17 at 7.50.44 PM

Happy QR code automating, y’all!

Advertisements

11 thoughts on “10 Steps To Auto Generate QR Codes in Google Spreadsheets!

  1. This sounds a cool idea! However, when I enter the formula and press enter it says “Parse error”. Do you know what the problem is?

  2. Could you suggest an easy way to record teaching lessons for coteachers

    Kathleen Sent from my iPad

  3. Google Spreadsheet is really not as easy as doc so we need some guides like this one To Auto Generate different codes and programs. thanks

  4. I am also having that “Parse Error”. Any idea what to do to fix it (as someone posted above…). Thanks!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s