{"id":436725,"date":"2022-04-24T18:00:10","date_gmt":"2022-04-24T15:00:10","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-make-a-qr-code-in-google-sheets\/"},"modified":"2022-04-24T18:00:10","modified_gmt":"2022-04-24T15:00:10","slug":"how-to-make-a-qr-code-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-qr-code-in-google-sheets\/","title":{"rendered":"#How to Make a QR Code in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2ddcdb70aa3\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2ddcdb70aa3\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-qr-code-in-google-sheets\/#%E2%80%9CHow_to_Make_a_QR_Code_in_Google_Sheets%E2%80%9D\" >&#8220;How to Make a QR Code in Google Sheets&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-qr-code-in-google-sheets\/#Create_a_QR_Code_Using_the_Image_Function\" >Create a QR Code Using the Image Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-qr-code-in-google-sheets\/#Create_a_QR_Code_Using_an_Add-On\" >Create a QR Code Using an Add-On<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Make_a_QR_Code_in_Google_Sheets%E2%80%9D\"><\/span>&#8220;How to Make a QR Code in Google Sheets&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-795038\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/GoogleSheetsQRCode.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/GoogleSheetsQRCode.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/GoogleSheetsQRCode.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets QR Code linking to How-To Geek\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>A QR code is convenient for capturing information with a mobile device camera. You can scan a code to visit a website and get contact details. To make sharing simple, here\u2019s how to create a QR code in Google Sheets.<\/p>\n<p>After making and inserting a QR code into Google Sheets, you or your audience can scan it to get the additional information they need. There are two effective methods for creating that code. You can use a function and formula or a Google Sheets add-on. Let\u2019s look at both.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_a_QR_Code_Using_the_Image_Function\"><\/span>Create a QR Code Using the Image Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google offers a link you can insert into the formula for the Image function to create the QR code. It may sound complicated, but it\u2019s actually super easy. With it, you can use the code to link to a website, contact details, and text.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Generate a Web Link QR Code in Google Chrome<\/em><\/strong><\/p>\n<p>Select the cell where you want to insert the QR code. Here is a basic formula linking to a website in cell A1. We\u2019ll break down the formula and explain the options you can use.<\/p>\n<pre>=image(\"https:\/\/chart.googleapis.com\/chart?chs=300x300&amp;cht=qr&amp;chl=\"&amp;ENCODEURL(A1))<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795029\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/ImageFunctionLinkSite-GoogleSheetsQRCode.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Image function for a web link QR code\" width=\"650\" height=\"157\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Here are the pieces for the formula:<\/p>\n<p><code>https:\/\/chart.googleapis.com\/chart?<\/code>: This is the site link that you must include to create the QR code.<\/p>\n<p><code>chs=300x300<\/code>: This determines the size of the QR code in pixels as width and height. Ours is 300 by 300 pixels.<\/p>\n<p><code>cht=qr<\/code>: This specifies the QR code type.<\/p>\n<p><code>chl=\"&amp;ENCODEURL(A1)<\/code>: This determines the data to encode. Here, we\u2019re encoding the link in cell <code>A1<\/code>.<\/p>\n<p>The ampersand operators between each of these pieces connect the string. Because you can use the formula for creating a QR code that does more than link to a website let\u2019s look at another example.<\/p>\n<p>With this formula, our code provides our company phone number in cell A2. The QR code is 500 pixels wide and 400 pixels high.<\/p>\n<pre>=image(\"https:\/\/chart.googleapis.com\/chart?chs=500x400&amp;cht=qr&amp;chl=\"&amp;ENCODEURL(A2))<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795030\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/ImageFunctionPhoneNumber-GoogleSheetsQRCode.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Image function for a phone number QR code\" width=\"650\" height=\"174\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> Depending on the size you enter for the code, you may need to adjust the size of the column or row in your sheet to accommodate the QR code.<\/p><\/blockquote>\n<p>You can include a few optional pieces in the formula:<\/p>\n<p><code>choe=(output_encoding)<\/code>: This determines how to encode the data in the QR code. The default, if omitted, is UTF-8, but you can also use Shift_JIS or ISO-8859-1.<\/p>\n<p><code>child=(error_correction_level)(margin)<\/code>: QR codes offer four levels of correction for errors to recover misread or masked data. You can use this to select a level.<\/p>\n<p>The above is courtesy of the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/developers.google.com\/chart\/infographics\/docs\/qr_codes\">Google Charts &gt; Infographics site<\/a>. You can visit the site for details on the formula options and additional information on how QR codes work.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_a_QR_Code_Using_an_Add-On\"><\/span>Create a QR Code Using an Add-On<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you search the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/workspace.google.com\/marketplace\">Google Workspace Marketplace<\/a>, you\u2019ll find several QR code generators. For instance, you may want to make codes in bulk. But for a simple QR code add-on that works well, check out this <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/workspace.google.com\/marketplace\/app\/qr_code_maker\/3039558402\">QR Code Maker<\/a>.<\/p>\n<p>Be aware that installing a third-party add-on from the Marketplace means you\u2019ll need to grant access to specified items for your Google Account. Make sure that you and your organization are comfortable with the security risks involved. Should you decide to check out this add-on, here\u2019s how it works.<\/p>\n<p>To generate a code, go to Extensions &gt; QR Code Maker &gt; Insert QR Code.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795031\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/ExtensionsQRCodeMaker-GoogleSheetsQRCode.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"QR Code Maker in the Google Sheets Extensions list\" width=\"603\" height=\"314\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This opens a sidebar for the add-on. Enter the text or link for the code into the box at the top. Then, click \u201cGenerate.\u201d<\/p>\n<p>You\u2019ll see your QR code display so you can grab your mobile device and scan the code to give it a quick test.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795033\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/QRCodeMakerGenerate-GoogleSheetsQRCode.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Generated QR code\" width=\"300\" height=\"485\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To add the code to your sheet, select \u201cInsert.\u201d The code then displays as a large image that you can move and resize as you please.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-795032\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/QRCodeMakerInsert-GoogleSheetsQRCode.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Inserted QR code\" width=\"581\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The next time you want an easy way to share information directly from your Google Sheet, consider making a QR code using one of these options.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make Your Own QR Codes from Your iPhone or Android Phone<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/795025\/how-to-make-a-qr-code-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Make a QR Code in Google Sheets&#8221; A QR code is convenient for capturing information with a mobile device camera. You can scan a code to visit a website and get contact details. To make sharing simple, here\u2019s how to create a QR code in Google Sheets. After making and inserting a QR&#8230;<\/p>\n","protected":false},"author":1,"featured_media":436726,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/GoogleSheetsQRCode.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-436725","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/436725","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=436725"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/436725\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/436726"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=436725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=436725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=436725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}