Abstract
QR codes are a popular way to direct individuals to specific web pages, like your business’ website. You can make them with relative ease, so there’s no excuse not to use them. Today, we’ll go over how you can make them in Microsoft Excel, a tool your business already probably uses to some extent.
Start By Building a Table
Your first step is to build a table in Excel. Use the Insert menu to find the option for Table. Make one with two columns, then rename Column1 as Text and Column2 as QR Code.
Your end result should look like this:
Populate Your Table with Links
Under the Text column, place your links; these are the destinations for your QR codes.
Add a Formula
Once you’re ready, select the top empty space in the QR Code column. You’ll then paste the following into the formula tab:
=IMAGE(“https://api.qrserver.com/v1/create-qr-code/?size=150×150&data=”&[@Text]&””)
Look, You Have a QR Code!
In the column, you should see QR codes for each of the links in the appropriate cell. We’ve edited our screenshot to show you a bit more clearly what’s going on, but all codes will direct to the corresponding link. You can copy them from this spreadsheet and use them anywhere you’d like.
Pretty Simple, Right?
If you found this blog helpful, consider giving us a call at 888-748-2525 to see how we can help your business make better use of the tools it already has at its disposal.
ABOUT THE AUTHOR
Rafiq Masri
With over 25 years of experience in Information Technology, Rafiq is one of the most accomplished, versatile and certified engineer in the field. He has spent the past 2 ½ decades administering and supporting a wide range of clients and has helped position Network Management, Inc. as a leader in the IT Managed Services space.
Rafiq has built a reputation for designing, building and supporting top notch IT infrastructures to match the business objectives and goals of his clients.
Embracing the core values of integrity, innovation, and reliability, Rafiq has a very loyal client base with some customer relationships dating back 20+ years.
Rafiq holds a bachelor’s degree in Mechanical Engineering from the University of Michigan and has completed graduate programs in Software Engineering and Business at Harvard and George Mason University. Rafiq is a former founder and CEO of Automation, Inc. in Ann Arbor, Michigan as well as a valued speaker on entrepreneurship and technology at industry events such as ExpoTech and others.