Teach.Connect.Curate

Incorporating Technology into Education

10 Steps To Auto Generate QR Codes in Google Spreadsheets!

on July 18, 2013

TeachBytes

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!

View original post

Advertisements

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

%d bloggers like this: