{"id":16897,"date":"2024-12-24T22:51:00","date_gmt":"2024-12-24T13:51:00","guid":{"rendered":"https:\/\/84office.jp\/?p=16897"},"modified":"2024-12-25T00:52:32","modified_gmt":"2024-12-24T15:52:32","slug":"google-sheets-qr-code-formula","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/google-sheets-qr-code-formula\/","title":{"rendered":"How to Easily Generate QR Codes in Google Sheets Using Formulas"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p>Have you ever thought creating QR codes is challenging, especially when using tools or writing code?<\/p>\n\n\n\n<p>With Google Sheets, you can easily generate QR codes using simple formulas.<\/p>\n\n\n\n<p>In this guide, we\u2019ll show you how to leverage a free QR code generation service that\u2019s also available for commercial use.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example Output<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full is-resized u-mb-ctrl u-mb-30\"><img decoding=\"async\" width=\"587\" height=\"670\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-104.png\" alt=\"\" class=\"wp-image-16900\" style=\"width:410px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-104.png 587w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-104-263x300.png 263w\" sizes=\"(max-width: 587px) 100vw, 587px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list has-border -border02 u-mb-ctrl u-mb-60 has-swl-pale-03-background-color has-background\">\n<li>Enter the data you want to convert into a QR code in Column A.<\/li>\n\n\n\n<li>Input the formula in Column B to generate the QR code.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>The Formula to Generate a QR Code<\/strong><\/h2>\n\n\n\n<p>\uff08Example for input in cell B2\uff09<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-50\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=IMAGE(&quot;https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=150x150&amp;data=&quot; &amp; ENCODEURL(A2), 4, 150, 150)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">IMAGE<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&quot;https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=150x150&amp;data=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(A2), <\/span><span style=\"color: #AE81FF\">4<\/span><span style=\"color: #F8F8F2\">, <\/span><span style=\"color: #AE81FF\">150<\/span><span style=\"color: #F8F8F2\">, <\/span><span style=\"color: #AE81FF\">150<\/span><span style=\"color: #F8F8F2\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><strong>Explanation of the Formula<\/strong><\/p>\n\n\n\n<dl class=\"swell-block-dl u-mb-ctrl u-mb-60\">\n<dt class=\"swell-block-dl__dt\"><code>https:\/\/api.qrserver.com\/v1\/create-qr-code\/<\/code><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>The URL of a free QR code generation API.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><code>size=150x150<\/code><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Specify the QR code image size as 150&#215;150 pixels.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><code>data=<\/code><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>Specify the data to be included in the QR code.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><code>ENCODEURL(A1)<\/code><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li>URL-encode the data entered in cell A1 to safely pass it to the API.<\/li>\n<\/ul>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><code>IMAGE<\/code>Function Options<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<ul class=\"wp-block-list\">\n<li><code>4<\/code>: Display the image with a custom size.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>150, 150<\/code>: 150, 150: Fix the width and height to 150 pixels each.<\/li>\n<\/ul>\n<\/dd>\n<\/dl>\n\n\n\n<h2 class=\"wp-block-heading\">What is a QR Code Generator (QR Code API)?<\/h2>\n\n\n\n<p>In this formula, we use the <a href=\"https:\/\/goqr.me\/\">QR Code Generator\uff08QR Code API\uff09<\/a> service provided by goQR.me.<br><br>The QR Code Generator is a web-based service that allows you to easily generate QR codes.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">It has the following features:<\/p>\n\n\n\n<dl class=\"swell-block-dl u-mb-ctrl u-mb-40\">\n<dt class=\"swell-block-dl__dt\">Available for free:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>An open QR code generation service that is also available for commercial use.<\/p>\n\n\n\n<p>(The following statement is displayed on the <a href=\"https:\/\/goqr.me\/\">QR Code Generator<\/a> website:)<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"u-mb-ctrl u-mb-10\">you can place and use the QR graphic on leaflets, posters, business cards or other products without any costs \/ for free (including commercial use).<\/p>\n<\/blockquote>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\">Simple API structure:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>You can create QR codes simply by adding text and size information to the URL.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\">High flexibility:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>Capable of converting various data into QR codes, such as URLs, text, Wi-Fi settings, and email addresses.<\/p>\n<\/dd>\n<\/dl>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">Basic QR code generation is available for free, but paid plans enable tracking and analytics, making it useful for marketing purposes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Create a QR Code<\/h2>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Enter the data.<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"784\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-52-1024x784.png\" alt=\"\" class=\"wp-image-16633\" style=\"width:595px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-52-1024x784.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-52-300x230.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-52-768x588.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-52.png 1519w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Enter the data you want to generate a QR code for (e.g., URL, text, etc.) in Column A of the spreadsheet.<\/p>\n\n\n\n<p>(The first row is the header row.)<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Enter the formula.<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"230\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-53-1024x230.png\" alt=\"\" class=\"wp-image-16634\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-53-1024x230.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-53-300x67.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-53-768x172.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-53-1536x344.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-53-2048x459.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Enter the previously mentioned formula in Column B (e.g., cell B2).<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro u-mb-ctrl u-mb-40\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"=IMAGE(&quot;https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=150x150&amp;data=&quot; &amp; ENCODEURL(A2), 4, 150, 150)\" style=\"color:#F8F8F2;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki monokai\" style=\"background-color: #272822\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F92672\">=<\/span><span style=\"color: #A6E22E\">IMAGE<\/span><span style=\"color: #F8F8F2\">(<\/span><span style=\"color: #E6DB74\">&quot;https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=150x150&amp;data=&quot;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #F92672\">&amp;<\/span><span style=\"color: #F8F8F2\"> <\/span><span style=\"color: #A6E22E\">ENCODEURL<\/span><span style=\"color: #F8F8F2\">(A2), <\/span><span style=\"color: #AE81FF\">4<\/span><span style=\"color: #F8F8F2\">, <\/span><span style=\"color: #AE81FF\">150<\/span><span style=\"color: #F8F8F2\">, <\/span><span style=\"color: #AE81FF\">150<\/span><span style=\"color: #F8F8F2\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Copy the formula to the rows below as needed.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">The Qr Code Is Generated.<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"587\" height=\"670\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-104.png\" alt=\"\" class=\"wp-image-16900\" style=\"width:419px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-104.png 587w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-104-263x300.png 263w\" sizes=\"(max-width: 587px) 100vw, 587px\" \/><\/figure>\n<\/div>\n\n\n<p>The QR codes will be generated in Column B.<\/p>\n\n\n\n<p>When you edit the data in Column A, the corresponding QR code will be updated automatically.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Download QR Code Images<\/strong><\/h2>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Download the file as a web page (.html).<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"891\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/771935a34ad1c1213bd50f249b59a606-1024x891.png\" alt=\"\" class=\"wp-image-16898\" style=\"width:506px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/771935a34ad1c1213bd50f249b59a606-1024x891.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/771935a34ad1c1213bd50f249b59a606-300x261.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/771935a34ad1c1213bd50f249b59a606-768x668.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/771935a34ad1c1213bd50f249b59a606.png 1295w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>From the menu, select <strong>[File] > [Download] > [Web Page (.html)]<\/strong>.<\/p>\n\n\n\n<p>This action downloads the entire spreadsheet in HTML format.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Open the Downloaded HTML File<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"640\" height=\"851\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-54.png\" alt=\"\" class=\"wp-image-16636\" style=\"width:428px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-54.png 640w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-54-226x300.png 226w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/figure>\n<\/div>\n\n\n<p>When you open the downloaded HTML file, the QR codes will be displayed.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Save a Specific QR Code Image<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"847\" height=\"472\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/56614ff9e746b429107eb5fa7396ec7b.png\" alt=\"\" class=\"wp-image-16637\" style=\"width:634px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/56614ff9e746b429107eb5fa7396ec7b.png 847w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/56614ff9e746b429107eb5fa7396ec7b-300x167.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/56614ff9e746b429107eb5fa7396ec7b-768x428.png 768w\" sizes=\"(max-width: 847px) 100vw, 847px\" \/><\/figure>\n<\/div>\n\n\n<p>Right-click on the QR Code image that opens in your browser.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Select \u201cSave Image As.&#8221;<\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/image-57.png\" alt=\"\" class=\"wp-image-16640\"\/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-60\">An image of only the selected QR code will be downloaded.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<p class=\"is-style-big_icon_memo u-mb-ctrl u-mb-60\"><img decoding=\"async\" width=\"700\" height=\"248\" class=\"wp-image-16644\" style=\"width: 700px;\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/e76220412661f0b28ef00981b05a2f92.png\" alt=\"\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/e76220412661f0b28ef00981b05a2f92.png 1367w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/e76220412661f0b28ef00981b05a2f92-300x106.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/e76220412661f0b28ef00981b05a2f92-1024x363.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/e76220412661f0b28ef00981b05a2f92-768x272.png 768w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><br>You can also open the URL in the formula:<a href=\"https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=150x150&amp;data=&quot; &amp; ENCODEURL(A2)\">https:\/\/api.qrserver.com\/v1\/create-qr-code\/?size=150&#215;150&amp;data=&#8221; &amp; ENCODEURL(A2)<\/a> to display the QR code.<\/p>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">Use Cases<\/h2>\n\n\n\n<p>It can be used for the following purposes, among others:<\/p>\n\n\n\n<ul class=\"wp-block-list has-border -border02 u-mb-ctrl u-mb-60 has-swl-pale-03-background-color has-background\">\n<li><strong>Product management:<\/strong>:\u3000<br>\u3000Convert product codes or product links into QR codes.<br><\/li>\n\n\n\n<li><strong>Event management:<br><\/strong>\u3000Convert event registration forms or venue directions URLs into QR codes.<br><\/li>\n\n\n\n<li><strong>Marketing:<\/strong><br>\u3000Distribute coupon codes or campaign pages as QR codes.<br><\/li>\n\n\n\n<li><strong>Streamlining administrative tasks:<br><\/strong>    Encoding for inventory management or shipment tracking.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">Things to Keep in Mind<\/h2>\n\n\n\n<dl class=\"swell-block-dl u-mb-ctrl u-mb-60\">\n<dt class=\"swell-block-dl__dt\">Data encoding (converting to a format usable in a URL)<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>Even if special characters are included, they will be encoded using the <code>ENCODEURL<\/code> function.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\">QR Code Size<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>To change the size, you can modify <code>size=150x150<\/code> to something like <code>size=200x200<\/code>.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong>Performance Issues<\/strong><\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>When creating a large number of QR codes, the output of the spreadsheet may become slower.<\/p>\n<\/dd>\n<\/dl>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\">Summary<\/h2>\n\n\n\n<p>By using formulas in Google Sheets, you can easily generate QR codes.<\/p>\n\n\n\n<p>By saving the generated QR codes as image files, you can use them in printed materials or digital documents.<\/p>\n\n\n\n<p>In addition to the formula method introduced here, there are also ways to generate QR codes using Google extensions, which will be featured in the next article.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-30\"><\/div>\n\n<div class=\"p-postListWrap u-mb-ctrl u-mb-30\"><ul class=\"p-postList -type-simple\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-calendar-free-time-template\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-25\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670825\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">Google Calendar Free Time Finder Template\uff5cGoogle Sheets \u00d7 Apps Script<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-calendar-free-time-extraction\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-24\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670824\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">How to Find Common Free Time in Google Calendar: Manage Shared Schedules with Google Apps Script<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-calendar-to-sheet-template\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-23\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670823\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">Ready-to-Use Google Calendar to Sheets Export Template| Google Sheets &amp; Apps Script<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<p class=\"is-style-emboss_box has-swl-pale-02-background-color has-background\">Our company offers support for improving work efficiency through the use of Google Apps Script. <br>If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us. <br>We are fully committed to supporting your business improvements.<br><br><a href=\"https:\/\/84office.jp\/contact\/\">Contact us here<br><\/a><\/p>\n\n\n\n<script src=\"https:\/\/codoc.jp\/js\/cms.js\" data-css=\"rainbow\" data-usercode=\"pQLZofrBiA\" charset=\"UTF-8\" defer><\/script>\n <div id=\"codoc-entry-9lNr9PuMXQ\" class=\"codoc-entries\" data-without-body=\"1\" data-support-button-text=\"Support with a Tip\" data-support-message=\"We will keep offering tools and information to boost work efficiency. Your support helps us provide even better content.\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever thought creating QR codes is challenging, especially when using tools or writing code? With Goog [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":16902,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=16631","footnotes":""},"categories":[12],"tags":[],"class_list":["post-16897","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=16897"}],"version-history":[{"count":1,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16897\/revisions"}],"predecessor-version":[{"id":16903,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/16897\/revisions\/16903"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/16902"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=16897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=16897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=16897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}