The Connection, Inc Blog

The Connection, Inc has been serving the New Jersey area since 1992, providing IT Support such as technical helpdesk support, computer support and consulting to small and medium-sized businesses.

Tip of the Week: How to Create QR Codes in Microsoft Excel

The Connection, Inc Blog Tip of the Week

George Gremminger

Wednesday, 05 March 2025

0 Comments

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 (732) 291-5938.

Tags:

About the author

George Gremminger

George's career in high technology systems began in 1985 at ESS in Atlantic Highlands, NJ, where he spent two years doing voice & data cabling, phone system installation, and service & maintenance. He then spent four years with Atlantic Telecom Services in Leonardo, NJ running their service and installation department, honing his skills in fiber optic lines, cabling, and phone systems.

In 1992, George drew on his years of experience and established The Connection, Inc.

As Owner, President and Senior Systems Engineer, George oversees all operations on a day-to-day basis. You might find him out in the field troubleshooting a telephone system, on a lift 30 feet in the air hanging fiber optic cable, or in the office helping with hardware or software issues. George is certified in a wide range of technologies and systems, including Microsoft, Sonic Wall, Mitel and Samsung.

George is a dedicated hands-on manager, ensuring every aspect of The Connection, Inc.’s operation runs smoothly. Whether it's 3 AM, or a Saturday afternoon, George is dedicated to helping their customers get connected and Stay Connected! His dedication to the community is clear, as he is a long-time volunteer member and President of the Leonardo First Aid Squad and a long-time volunteer member of the Community Fire Company of Middletown Township.

You can reach George at or 732-291-5938 ext. 500.

Author's recent posts

Contact Us At

E-Mail Us @