---
title: "Tip of the Week: How to Create QR Codes in Microsoft Excel - Get a Free Network Security Consultation in South Florida"
description: "Did you know that you can use Microsoft Excel to generate QR codes?"
url: "https://www.l7solutions.com/blog/tip-of-the-week-how-to-create-qr-codes-in-microsoft-excel"
date: "2026-06-19T22:23:47+00:00"
language: "en-GB"
---
## Get a Free Network Security Consultation in South Florida
Get a free network security consultation today from L7 Solutions. We are your partner for managed services & IT support in South Florida and beyond. Call today.
[ Categories ](https://www.l7solutions.com/blog/categories "Categories")
[ Tags ](https://www.l7solutions.com/blog/tags "Tags")
[ Categories: All Categories ](https://www.l7solutions.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://www.l7solutions.com/javascript:void(0);)
# Tip of the Week: How to Create QR Codes in Microsoft Excel
[LSeven Solutions Blog](https://www.l7solutions.com/blog/categories/blog) [Tip of the Week](https://www.l7solutions.com/blog/categories/tip-of-the-week)
[LSeven Solutions Admin](https://www.l7solutions.com/blog/blogger/l7-admin)
Wednesday, 05 March 2025
[ 0 Comments ](https://www.l7solutions.com/blog/tip-of-the-week-how-to-create-qr-codes-in-microsoft-excel#comments)
[  ](//www.l7solutions.com/images/easyblog_shared/March_2025/03-05-24/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:
## Next, You Populate It With Your Links
In the Text column, paste the links for which you want to generate a QR code.
## 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\]&"")
## 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.
### 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 PHONENUMBER.
[ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/javascript:void(0);)
Tags:
[Quick Tips](https://www.l7solutions.com/blog/tags/quick-tips) [Efficiency](https://www.l7solutions.com/blog/tags/efficiency) [Tip of the Week](https://www.l7solutions.com/blog/tags/tip-of-the-week)
[ The Importance of Spam Protection for Business Ema... ](https://www.l7solutions.com/blog/importance-of-spam-protection-for-email-systems)
[ Staying Safe on Social Media Boils Down to These T... ](https://www.l7solutions.com/blog/staying-safe-on-social-media-boils-down-to-these-three-things)
About the author
[  ](https://www.l7solutions.com/blog/blogger/l7-admin)
[LSeven Solutions Admin](https://www.l7solutions.com/blog/blogger/l7-admin)
[ ](https://www.l7solutions.com/javascript:void(0); "Subscribe to updates from author") [ ](https://www.l7solutions.com/javascript:void(0);) [ ](https://www.l7solutions.com/blog/blogger/l7-admin)
Welcome to LSeven's Blog! Here we will share useful tips and tricks for Computers and Information on Our IT Services!
Author's recent posts
[More posts from author](https://www.l7solutions.com/blog/blogger/l7-admin)
[ Tuesday, 30 June 2026 Stop Managing Metal, Start Managing People: A Guide to Hybrid IT ](https://www.l7solutions.com/blog/stop-managing-metal-start-managing-people-a-guide-to-hybrid-it)
[ Saturday, 27 June 2026 Free AI is Not Free: Why Public Tools Are a Security Risk ](https://www.l7solutions.com/blog/free-ai-is-not-free-why-public-tools-are-a-security-risk)
[ Thursday, 25 June 2026 Phishing is Getting Sophisticated: The New Threats Businesses Face ](https://www.l7solutions.com/blog/phishing-is-getting-sophisticated-the-new-threats-businesses-face)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://www.l7solutions.com/component/users/login?return=aHR0cHM6Ly93d3cubDdzb2x1dGlvbnMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLWhvdy10by1jcmVhdGUtcXItY29kZXMtaW4tbWljcm9zb2Z0LWV4Y2Vs&Itemid=101)
Friday, 19 June 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**
## Schema
```json
{
"@context": "https://schema.org",
"@type": "BreadcrumbList",
"itemListElement": [
{
"@type": "ListItem",
"position": 1,
"name": "Home",
"item": "https://www.l7solutions.com"
},
{
"@type": "ListItem",
"position": 2,
"name": "Blog",
"item": "https://www.l7solutions.com/blog"
},
{
"@type": "ListItem",
"position": 3,
"name": "LSeven Solutions Admin",
"item": "https://www.l7solutions.com/blog/blogger/l7-admin"
},
{
"@type": "ListItem",
"position": 4,
"name": "Tip of the Week: How to Create QR Codes in Microsoft Excel",
"item": "https://www.l7solutions.com/blog/tip-of-the-week-how-to-create-qr-codes-in-microsoft-excel"
}
]
}
```