Do you use QR codes in your classroom? ( If not, you should! )
Usually I use a webpage to create QR codes one by one, but today I found a shortcut. Google Sheets can actually create QR codes for you in bulk! There's a video below explaining, but in short :
1) Create a new spreadsheet.
2) Put the text or URL you want in the first column
3) Put " =image(“https://chart.googleapis.com/chart?chs=150×150&cht=qr&chl=”&A1) " in the second column ( make sure that 'A1' part matches the cell number of the text you want. )
4) Magic!
Usually I use a webpage to create QR codes one by one, but today I found a shortcut. Google Sheets can actually create QR codes for you in bulk! There's a video below explaining, but in short :
1) Create a new spreadsheet.
2) Put the text or URL you want in the first column
3) Put " =image(“https://chart.googleapis.com/chart?chs=150×150&cht=qr&chl=”&A1) " in the second column ( make sure that 'A1' part matches the cell number of the text you want. )
4) Magic!