{"id":11537,"date":"2025-06-24T17:58:12","date_gmt":"2025-06-24T17:58:12","guid":{"rendered":"https:\/\/colemandev.directivesites.com\/tip-of-the-week-how-to-create-qr-codes-in-microsoft-excel\/"},"modified":"2025-06-24T19:42:37","modified_gmt":"2025-06-24T19:42:37","slug":"tip-of-the-week-how-to-create-qr-codes-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/colemantechnologies.directivesites.com\/?p=11537","title":{"rendered":"Tip of the Week: How to Create QR Codes in Microsoft Excel"},"content":{"rendered":"
\n
\n
\n\"Tip
\n<\/a>\n<\/div>\n

QR codes are a handy way to direct someone to the right place online, like your business\u2019 website, but did you know that they are also pretty easy to make? Let\u2019s go over how you can whip up your own with the help of Microsoft Excel.<\/p>\n

First, You Need to Build a Table<\/h2>\n

In Excel, you\u2019ll want to create a table. Under the Insert<\/strong> menu, select Table<\/strong> and make one with two columns. Rename Column1<\/strong> as Text<\/strong> and Column2<\/strong> as QR Code<\/strong>.<\/p>\n

The result should look like this:<\/p>\n

\"\"<\/p>\n

Next, You Populate It With Your Links<\/h2>\n

In the Text column, paste the links for which you want to generate a QR code.<\/p>\n

\"\"<\/p>\n

Then, You Add the Formula<\/h2>\n

Then, selecting the top empty space in the QR Code column<\/strong>, paste in the following formula:\u00a0<\/p>\n

=IMAGE(“https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=150×150&data=”&[@Text]&””)<\/p>\n

\"\"<\/p>\n

Finally, You Have Your QR Code<\/h2>\n

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.<\/p>\n

\"\"<\/p>\n

It\u2019s Really That Simple!<\/h3>\n

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.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

QR codes are a handy way to direct someone to the right place online, like your business\u2019 website, but did you know that they are also pretty easy to make? Let\u2019s go over how you can whip up your own with the help of Microsoft Excel. First, You Need to Build a Table In Excel, […]<\/p>\n","protected":false},"author":16,"featured_media":10971,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[55,57,69],"tags":[],"class_list":["post-11537","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-efficiency","category-quick-tips","category-tip-of-the-week"],"_links":{"self":[{"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=\/wp\/v2\/posts\/11537","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11537"}],"version-history":[{"count":1,"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=\/wp\/v2\/posts\/11537\/revisions"}],"predecessor-version":[{"id":12095,"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=\/wp\/v2\/posts\/11537\/revisions\/12095"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=\/wp\/v2\/media\/10971"}],"wp:attachment":[{"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/colemantechnologies.directivesites.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}