Uploaded January 2024 | Updated November 2026, 3 days ago
How to make QR codes in bulk for websites, PDFs, and more in Excel using formulas.
⚠️ UPDATE: The API shown in the video has been deprecated.
Visit this post for the working alternative and download your free practice file: bit.ly/qrcodesfile
👩🏫 Learn more Excel functions and formulas with my course: bit.ly/advformulas0130
In Excel, you can easily create bulk QR codes for free using simple formulas. Unlike other spreadsheet tools, Excel lets you copy and paste your generated QR code images directly wherever you need them.
QR codes don't expire because they are simply visual versions of text and links. You can use them for:
• Website links & PDFs
• Digital tickets & event passes
• Contactless payments
• Product packaging & menus
In this tutorial, we cover two methods:
1. The Fast Formula Method: Using Excel's IMAGE function (Microsoft 365).
2. The Custom Color Method: A flexible approach to create colored QR codes that works across all versions of Excel.
Stick around until the end where we cover key FAQs and sizing limits!
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
==============
0:00 Use cases for QR codes
0:44 The quickest formula method
2:37 Make it an easy one-click tool
5:24 How to make colored QR codes
6:50 Match your brand colors
7:31 Important limits & rules
8:08 Which option is the best (personal opinion)
#Excel #QRCode #ExcelTutorial
How to make QR codes in bulk for websites, PDFs, and more in Excel using formulas.
⚠️ UPDATE: The API shown in the video has been deprecated.
Visit this post for the working alternative and download your free practice file: bit.ly/qrcodesfile
👩🏫 Learn more Excel functions and formulas with my course: bit.ly/advformulas0130
In Excel, you can easily create bulk QR codes for free using simple formulas. Unlike other spreadsheet tools, Excel lets you copy and paste your generated QR code images directly wherever you need them.
QR codes don't expire because they are simply visual versions of text and links. You can use them for:
• Website links & PDFs
• Digital tickets & event passes
• Contactless payments
• Product packaging & menus
In this tutorial, we cover two methods:
1. The Fast Formula Method: Using Excel's IMAGE function (Microsoft 365).
2. The Custom Color Method: A flexible approach to create colored QR codes that works across all versions of Excel.
Stick around until the end where we cover key FAQs and sizing limits!
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS
==============
0:00 Use cases for QR codes
0:44 The quickest formula method
2:37 Make it an easy one-click tool
5:24 How to make colored QR codes
6:50 Match your brand colors
7:31 Important limits & rules
8:08 Which option is the best (personal opinion)
#Excel #QRCode #ExcelTutorial










