Generate QR codes from a set of URLs in Excel
QR codes are a versatile way of storing a wide range of data types, including text, numbers, contact information, URLs, and lots more. They make it convenient for anyone wanting to access information quickly using a smartphone or QR code reader.
Unfortunately, Excel doesn't have built-in capabilities for generating QR codes. However, a few workarounds exist, including one that takes advantage of the Google Charts API.
Based on a set of URLs in A2:A7, carry out the following:
1️⃣
Go to 𝚑𝚝𝚝𝚙𝚜://𝚍𝚎𝚟𝚎𝚕𝚘𝚙𝚎𝚛𝚜.𝚐𝚘𝚘𝚐𝚕𝚎.𝚌𝚘𝚖/𝚌𝚑𝚊𝚛𝚝/𝚒𝚗𝚏𝚘𝚐𝚛𝚊𝚙𝚑𝚒𝚌𝚜/𝚍𝚘𝚌𝚜/𝚚𝚛_𝚌𝚘𝚍𝚎𝚜 (https://lnkd.in/eSy9kbG6).
2️⃣
Copy the root URL 𝚑𝚝𝚝𝚙𝚜://𝚌𝚑𝚊𝚛𝚝.𝚐𝚘𝚘𝚐𝚕𝚎𝚊𝚙𝚒𝚜.𝚌𝚘𝚖/𝚌𝚑𝚊𝚛𝚝? and paste it into IMAGE's 𝚜𝚘𝚞𝚛𝚌𝚎 argument, wrapped inside quotation marks.
=𝙸𝙼𝙰𝙶𝙴("𝚑𝚝𝚝𝚙𝚜://𝚌𝚑𝚊𝚛𝚝.𝚐𝚘𝚘𝚐𝚕𝚎𝚊𝚙𝚒𝚜.𝚌𝚘𝚖/𝚌𝚑𝚊𝚛𝚝?")
3️⃣
Add the three required parameters to the end of the URL, each separated by an ampersand (&):
• 𝚌𝚑𝚝=𝚚𝚛 (specifies a QR code)
• 𝚌𝚑𝚜=＜𝚠𝚒𝚍𝚝𝚑＞𝚡＜𝚑𝚎𝚒𝚐𝚑𝚝＞ (image size)
• 𝚌𝚑𝚕=＜𝚍𝚊𝚝𝚊＞ (the data to encode)
=𝙸𝙼𝙰𝙶𝙴("𝚑𝚝𝚝𝚙𝚜://𝚌𝚑𝚊𝚛𝚝.𝚐𝚘𝚘𝚐𝚕𝚎𝚊𝚙𝚒𝚜.𝚌𝚘𝚖/𝚌𝚑𝚊𝚛𝚝?&𝚌𝚑𝚝=𝚚𝚛&𝚌𝚑𝚜=＜𝚠𝚒𝚍𝚝𝚑＞𝚡＜𝚑𝚎𝚒𝚐𝚑𝚝＞&𝚌𝚑𝚕=＜𝚍𝚊𝚝𝚊＞")
4️⃣
Replace the ＜𝚠𝚒𝚍𝚝𝚑＞ and ＜𝚑𝚎𝚒𝚐𝚑𝚝＞ tags with pixel values, and delete ＜𝚍𝚊𝚝𝚊＞ to use an ampersand (&) outside the string to concatenate the URLs in A2:A7.
=𝙸𝙼𝙰𝙶𝙴("𝚑𝚝𝚝𝚙𝚜://𝚌𝚑𝚊𝚛𝚝.𝚐𝚘𝚘𝚐𝚕𝚎𝚊𝚙𝚒𝚜.𝚌𝚘𝚖/𝚌𝚑𝚊𝚛𝚝?&𝚌𝚑𝚝=𝚚𝚛&𝚌𝚑𝚜=𝟻00𝚡𝟻00&𝚌𝚑𝚕="&𝙰𝟸:𝙰𝟽)
This generates a QR code for each URL, which can be scanned and tested using a smartphone.
#exceleration #excel #microsoftexcel #excelformulas #exceltips #exceltricks #globalexcelsummit
---
The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts.
Learn more at https://globalexcelsummit.com/.
Find us on:
👔 LinkedIn: / global-excel-summit
🐤 Twitter: / excelsummit
🟦 Facebook: / globalexcelsummit
📸 Instagram: / globalexcelsummit
🤳 TikTok: / globalexcelsummit