## Datalyst Blog

Datalyst delivers expert managed IT services in Providence, RI. Optimize performance, secure your systems, and grow with us. Contact us today!

 [ Categories ](https://datalyst.directivesites.com/blog/categories "Categories")

 [ Tags ](https://datalyst.directivesites.com/blog/tags "Tags")

 [ Categories:  All Categories ](https://datalyst.directivesites.com/javascript:void(0); "Categories")

 Search...Suggested keywords

 [  x ](https://datalyst.directivesites.com/javascript:void(0);)

 <a class="eb-image-viewport"></a>

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

  [Datalyst Blog](https://datalyst.directivesites.com/blog/categories/blog)   [Tip of the Week](https://datalyst.directivesites.com/blog/categories/tip-of-the-week)

  [Daniel Mathieu](https://datalyst.directivesites.com/blog/blogger/daniel-mathieu)

  Wednesday, 05 March 2025

   [ 0 Comments ](https://datalyst.directivesites.com/blog/tip-of-the-week-how-to-create-qr-codes-in-microsoft-excel#comments)

 [ ![Tip of the Week: How to Create QR Codes in Microsoft Excel](//datalyst.directivesites.com/images/easyblog_shared/March_2025/03-05-24/b2ap3_large_CreateQRCode_51339562_400.jpg) ](//datalyst.directivesites.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:

![](https://datalyst.directivesites.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://datalyst.directivesites.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&amp;data="&amp;\[@Text\]&amp;"")

![](https://datalyst.directivesites.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://datalyst.directivesites.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 (774) 213-9701.

 [  ](https://datalyst.directivesites.com/javascript:void(0);) [  ](https://datalyst.directivesites.com/javascript:void(0);) [  ](https://datalyst.directivesites.com/javascript:void(0);)

Tags:

  [Quick Tips](https://datalyst.directivesites.com/blog/tags/quick-tips)   [Efficiency](https://datalyst.directivesites.com/blog/tags/efficiency)   [Tip of the Week](https://datalyst.directivesites.com/blog/tags/tip-of-the-week)

 [  Understanding What You Can Get Out of Managed IT S... ](https://datalyst.directivesites.com/blog/understanding-what-you-can-get-out-of-managed-it-services)

 [  Staying Safe on Social Media Boils Down to These T... ](https://datalyst.directivesites.com/blog/staying-safe-on-social-media-boils-down-to-these-three-things)

 About the author

 [ ![Daniel Mathieu](https://datalyst.directivesites.com/images/easyblog_avatar/808_808_blogauthor.png) ](https://datalyst.directivesites.com/blog/blogger/daniel-mathieu)

 [Daniel Mathieu](https://datalyst.directivesites.com/blog/blogger/daniel-mathieu)

  [  ](https://datalyst.directivesites.com/javascript:void(0); "Subscribe to updates from author") [  ](https://datalyst.directivesites.com/javascript:void(0);)   [  ](https://datalyst.directivesites.com/blog/blogger/daniel-mathieu)

Dan is a trusted IT advisor with a background of over 25 years in IT and continuously works on the challenges of putting the right people in place to drive business growth and customer satisfaction.

Author's recent posts

  [More posts from author](https://datalyst.directivesites.com/blog/blogger/daniel-mathieu)

 [ Friday, 31 July 2026  Are You Paying for Inactive Software? ](https://datalyst.directivesites.com/blog/are-you-paying-for-inactive-software)

 [ Wednesday, 29 July 2026  3 Reasons Why Storing Business Files Locally is Obsolete ](https://datalyst.directivesites.com/blog/3-reasons-why-storing-business-files-locally-is-obsolete)

 [ Tuesday, 28 July 2026  Combating Software Bloat and Cyber Risks ](https://datalyst.directivesites.com/newsletter-content/combating-software-bloat-and-cyber-risks)

 <a class="eb-anchor-link" data-allow-comment="1" id="comments" name="comments"> </a> Comments

  No comments made yet. Be the first to submit a comment

   **![Guest](https://datalyst.directivesites.com/media/com_easyblog/images/avatars/author.png)**   Already Registered? [Login Here](https://datalyst.directivesites.com/home/login-logout?return=aHR0cHM6Ly9kYXRhbHlzdC5kaXJlY3RpdmVzaXRlcy5jb20vYmxvZy90aXAtb2YtdGhlLXdlZWstaG93LXRvLWNyZWF0ZS1xci1jb2Rlcy1pbi1taWNyb3NvZnQtZXhjZWw=)

 Wednesday, 05 August 2026

  Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)

 **Captcha Image**