--- title: "Tip of the Week: How to Create QR Codes in Microsoft Excel - Blogs on IT Support and Cybersecurity for Small Business" description: "QR codes are a handy way to direct someone to the right place online, like your business’ website, but did you know that they are also pretty easy to make? Let’s go over how you can whip up your own with the help of Microsoft Excel.First, You Need to" url: "https://colemantechnologies.com/blog/tip-of-the-week-how-to-create-qr-codes-in-microsoft-excel" date: "2026-06-08T11:37:55+00:00" language: "en-GB" --- ## Blogs on IT Support and Cybersecurity for Small Business Insights on cybersecurity, AI, and IT strategy to help business leaders reduce risk, improve performance, and make better technology decisions. [ Categories ](https://colemantechnologies.com/blog/categories "Categories") [ Tags ](https://colemantechnologies.com/blog/tags "Tags") [ Categories: All Categories ](https://colemantechnologies.com/javascript:void(0); "Categories") Search...Suggested keywords [ x ](https://colemantechnologies.com/javascript:void(0);) # Tip of the Week: How to Create QR Codes in Microsoft Excel [Tip of the Week](https://colemantechnologies.com/blog/categories/tip-of-the-week) [Quick Tips](https://colemantechnologies.com/blog/categories/quick-tips) [Efficiency](https://colemantechnologies.com/blog/categories/efficiency) [Coleman Technologies Admin](https://colemantechnologies.com/blog/blogger/darren-coleman) Tuesday, 24 June 2025 [ ![Tip of the Week: How to Create QR Codes in Microsoft Excel](https://colemandev.directivesites.com/wp-content/uploads/2025/06/CreateQRCode_51339562_400.jpg) ](https://colemandev.directivesites.com/wp-content/uploads/2025/06/CreateQRCode_51339562_400.jpg "Tip of the Week: How to Create QR Codes in Microsoft Excel") QR codes are a handy way to direct someone to the right place online, like your business’ website, but did you know that they are also pretty easy to make? Let’s go over how you can whip up your own with the help of Microsoft Excel. ## First, You Need to Build a Table In Excel, you’ll want to create a table. Under the **Insert** menu, select **Table** and make one with two columns. Rename **Column1** as **Text** and **Column2** as **QR Code**. The result should look like this: ![](https://colemantechnologies.com/images/easyblog_shared/March_2025/03-05-24/Image_1.png) ## Next, You Populate It With Your Links In the Text column, paste the links for which you want to generate a QR code. ![](https://colemantechnologies.com/images/easyblog_shared/March_2025/03-05-24/Image_2.png) ## Then, You Add the Formula Then, selecting the top empty space in the **QR Code column**, paste in the following formula: =IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=150x150&data="&\[@Text\]&"") ![](https://colemantechnologies.com/images/easyblog_shared/March_2025/03-05-24/Image_3.png) ## Finally, You Have Your QR Code This will generate a QR code for each link in the corresponding cell. While we have edited the screenshot somewhat to show you the result more clearly, all of these codes will direct to the associated link, and can be copied and used elsewhere. ![](https://colemantechnologies.com/images/easyblog_shared/March_2025/03-05-24/Image_4.png) ### It’s Really That Simple! Stick around for more handy tips and discussions about numerous IT topics and happenings. To learn more about what we can do to assist your business with its IT directly, contact us at (604) 513-9428. [ ](https://colemantechnologies.com/javascript:void(0);) [ ](https://colemantechnologies.com/javascript:void(0);) [ ](https://colemantechnologies.com/javascript:void(0);) [×](https://colemantechnologies.com/javascript:void(0);) Stay Informed When you subscribe to the blog, we will send you an e-mail when there are new updates on the site so you wouldn't miss them. Your Name E-mail Address [ Vendor Relationships Could See Strain ](https://colemantechnologies.com/blog/vendor-relationships-could-see-strain-1) [ How to Make the Most of What Your Business Has ](https://colemantechnologies.com/blog/how-to-make-the-most-of-what-your-business-has-1) About the author [ ![Coleman Technologies Admin](https://colemantechnologies.com/media/com_easyblog/images/avatars/author.png) ](https://colemantechnologies.com/blog/blogger/darren-coleman) [Coleman Technologies Admin](https://colemantechnologies.com/blog/blogger/darren-coleman) [ ](https://colemantechnologies.com/blog/blogger/darren-coleman) Author's recent posts [More posts from author](https://colemantechnologies.com/blog/blogger/darren-coleman) [ Tuesday, 05 May 2026 Darren Coleman Featured in Boss Today on AI Literacy and Human Judgment ](https://colemantechnologies.com/blog/darren-coleman-bosstoday-ai-literacy) [ Monday, 06 April 2026 How Cloud IT Services Are Transforming Business Continuity ](https://colemantechnologies.com/blog/how-cloud-it-services-are-transforming-business-continuity) [ Monday, 06 April 2026 Darren Coleman Featured in USAWire on Why Businesses Need an AI Strategy ](https://colemantechnologies.com/news-a-events/darren-coleman-usawire-ai-strategy) ## Schema ```json { "@context": "https://schema.org", "@type": "BreadcrumbList", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "Home", "item": "https://colemantechnologies.com" }, { "@type": "ListItem", "position": 2, "name": "Blog", "item": "https://colemantechnologies.com/blog" }, { "@type": "ListItem", "position": 3, "name": "Coleman Technologies Admin", "item": "https://colemantechnologies.com/blog/blogger/darren-coleman" }, { "@type": "ListItem", "position": 4, "name": "Tip of the Week: How to Create QR Codes in Microsoft Excel", "item": "https://colemantechnologies.com/blog/tip-of-the-week-how-to-create-qr-codes-in-microsoft-excel" } ] } ```