Jump to the section that is relevant to you.<\/p>\n\n\n\n
Case 1: Create QR Codes using Excel<\/h2>\n\n\n\n
In this case, you are looking to generate QR Codes in bulk. You have a spreadsheet (XLS, XLSX, or CSV) with data in each row for each QR Code. You are looking for an online tool where you can upload Excel and generate QR Codes.<\/p>\n\n\n\n
![\"CTA](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2024\/03\/QR-Batch-Design-Blog-CTA-3.png\")
\n <\/a>\n <\/div>\n \n\n\n\nIf you need this, you need a bulk QR Code generator tool such as QR Batch<\/strong><\/a>.<\/p>\n\n\n\n Here is how you can get started.<\/p>\n\n\n\n The spreadsheet (Google Sheets or MS-Excel) will contain the data that you want to encode in the QR Code. One row of data for each QR Code.<\/p>\n\n\n\n Here is how to format your spreadsheet:<\/p>\n\n\n\n To encode content in Excel, you can choose from the following three categories:<\/p>\n\n\n\n i. Website URL QR Code<\/strong><\/p>\n\n\n\n A Website URL QR Code, when scanned, takes the end-users to visit the encoded website address. Here, the first column should be the Filename (QR Code 1, QR Code 2, etc). While the second column should be the Website URL that will be encoded into the QR Code.<\/p>\n\n\n\n ii. Plain Text QR Code<\/strong><\/p>\n\n\n\n In a Plain Text QR Code, you can encode text information such as an address, product information, or, a short bio.<\/p>\n\n\n\n In order to create a Plain Text QR Code using Excel, the second column should contain the text. While the first column, as usual, should be the Filename.<\/p>\n\n\n\n Here’s what our customers have to say about us:<\/em><\/strong><\/p>\n\n\n\n iii. VCard QR Code<\/strong><\/p>\n\n\n\n A VCard QR Code, when scanned, displays contact information. These include details such as name, title\/designation, company, email, phone, and website. It also prompts the user to \u2018Add as contact\u2019. For a VCard QR Code, You can add contact details second column onwards. That is, the name is Column B, title in Column C, the company in Column D, and so on. <\/p>\n\n\n\n Once you have created the spreadsheet, go to the QR Batch<\/a><\/strong> homepage. Click on ‘Signup’ from the top navigation bar. Note that signing up for an account is free and necessary to start generating QR Codes.<\/p>\n\n\n\n Once logged in, you\u2019ll see two QR batch type options to choose from\u2014Generate QR Code Images <\/em>or Generate QR Code Labels<\/em>If you select the Generate QR Code<\/em> Images<\/em><\/strong> option, you will download your QR Codes as images. On the other hand, if you select the Generate QR Code Labels<\/em><\/strong> option, you will get QR Codes as labels for A4 sheets.<\/p>\n\n\n\n Now, choose the QR Code category\u2014Website URL, VCard, Plain Text, Serial Code, or Random Code\u2014as per requirements.<\/p>\n\n\n\n Upload the spreadsheet you created in Step 1 on the page that opens. You can upload it in CSV, XLS, or XLSX format. <\/p>\n\n\n\n The next step is to review the data. Here you will have to match the data in the columns with the data from the spreadsheet.<\/p>\n\n\n\n For example, say you want to create Simple Text QR Codes. The \u2018Review\u2019 page on which you land will prompt you to confirm the columns. That means you need to select which column is QR Code filename and which column has text.<\/p>\n\n\n\n Once you review the data, you will be landed on a page where you will see three design options: <\/p>\n\n\n\n If you want a basic black-and-white QR Code, go for the standard QR Code. But if your use case is promotional or customer-facing, choose one of the other two design options.<\/p>\n\n\n\n Also, custom QR Codes attract 50-100% more scans than plain black-and-white ones. <\/p>\n\n\n\n After you finalize the design of your QR Code, a window will pop up prompting you to specify the batch name. In the same window, you will also get an option to choose how you wish to export the QR Codes.<\/p>\n\n\n\n Note that if in the beginning, you had selected Generate QR Code Images<\/em> as batch, then you\u2019ll see the following options\u2014PNG, JPG, SVG, EPS, and PDF. On the other hand, if you had selected the Generate QR Code labels<\/em> option, you\u2019ll see the option to name the batch and choose the label sheet layout.<\/p>\n\n\n\n An additional 27% of individuals consider themselves advanced, indicating that a total of 83% of people believe they fall into either intermediate or advanced categories as Excel users.<\/em><\/strong><\/p>\n\n\n\n To help you understand it better, here\u2019s what it means:<\/p>\n\n\n\n With this option, you can export the QR Codes as images (in a zip folder) in the following formats\u2014PNG, JPG, EPS, SVG. You also need to specify the image size in inches, cm, or pixels.<\/p>\n\n\n\n This option allows you to export the QR Codes as label PDFs. Here you will get the option to choose the layout of the labels i.e. labels per sheet as per label size.<\/p>\n\n\n\n For your reference, here is a detailed guide on QR Code labels<\/strong><\/a>.<\/p>\n\n\n\n Once you choose the option, click on Next.<\/em><\/p>\n\n\n\n The major advantage of using QR Batch is that it charges you only for the QR Codes you create. That is, there is no subscription required. <\/p>\n\n\n\n Also note that the higher the number of QR Codes you generate, the cheaper will be the rate. <\/p>\n\n\n\n Also, you can estimate the batch price with the QR Batch Price Calculator. You can check it on the QR Batch Pricing webpage<\/strong><\/a>. <\/p>\n\n\n\n Once you make the payment, your batch will start generating. The time taken depends upon the size of the batch.<\/p>\n\n\n\n Typically, it can range from a few minutes to a couple of hours.<\/p>\n\n\n\n Once done, you\u2019ll receive an email with a zip file containing all the QR Codes. Alternatively, you can also download the batch from the My Batches<\/em> section of your account.<\/p>\n\n\n\n You can then download your batch. Hence, your bulk of QR Codes using an MS- Excel file will be downloaded.<\/p>\n\n\n\n Hence, your bulk of QR Codes using an MS- Excel file will be downloaded.<\/p>\n\n\n\n So, this was one case of using the Excel QR Code Generator tool.<\/p>\n\n\n\n Learn all about creating QR Codes in bulk<\/a><\/strong><\/p>\n\n\n\n In this case, you want to link an Excel to a QR Code. This is, when people scan the QR Code, they can view or download the Excel on their smartphones.<\/p>\n\n\n\n If this is your requirement, then what you need is a Excel QR Code Generator tool.<\/p>\n\n\n\n To make your work easier, we have compared the best QR Code generator tools<\/strong><\/a>. <\/p>\n\n\n\n In this article, we will use the Scanova QR Code Generator<\/strong><\/a> tool for demo purposes.<\/p>\n\n\n\n But before you proceed to actually create QR Codes, you need to know your requirements well. These are:<\/p>\n\n\n\n That is, do you want the flexibility to replace the linked Excel file anytime?<\/p>\n\n\n\n Is it important for you to know how many people scanned the QR Code, when did they scan, and from where (GPS location, city, country)? If so, this data can help you optimize future QR Code campaigns.<\/p>\n\n\n\n In addition to this, you can also see how your end-users interact with the content encoded in the QR Code after scanning it. It can a button to anything such as \u2018Register now<\/em>\u2019 or \u2018Sign up<\/em>\u2019.<\/p>\n\n\n\n On average, individuals allocate 38% of their time<\/a> to working in a spreadsheet<\/em><\/strong><\/p>\n\n\n\n You can create QR Codes that are password protected. To do it, you just need to add a password and share it with authorized people.<\/p>\n\n\n\n You can refer to this detailed guide on how to password protect your QR Code<\/strong><\/a>.<\/p>\n\n\n\n If the above capabilities are important, you should consider creating Dynamic QR Codes<\/strong><\/a>.<\/p>\n\n\n\n1. Format your spreadsheet<\/strong><\/h3>\n\n\n\n
\n
<\/p>\n\n\n\n![\"Excel](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2023\/12\/Excel-QR-Website-URL-1024x512.webp\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2024\/05\/2-1024x316.png\")
<\/figure>\n\n\n\n
<\/p>\n\n\n\n![\"Excel](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2023\/12\/Visiting-card-1-1024x512.webp\")
<\/figure>\n\n\n\n2. Create account on QR Batch<\/strong><\/h3>\n\n\n\n
![\"Excel](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2023\/12\/Choose-Batch-Type.png\")
<\/figure>\n\n\n\n![\"Excel](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2023\/12\/Choose-QR-Code.png\")
<\/figure>\n\n\n\n3. Upload spreadsheet<\/strong><\/h3>\n\n\n\n
![\"Excel](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2023\/12\/Upload-and-review-data.png\")
<\/figure>\n\n\n\n4. Review data<\/strong><\/h3>\n\n\n\n
![\"Excel](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2023\/12\/Upload-and-review-data-2.png\")
<\/figure>\n\n\n\n5. Add design <\/strong><\/h3>\n\n\n\n
![\"Excel](\"https:\/\/qrbatch.io\/blog\/wp-content\/uploads\/2023\/12\/Add-Design.png\")
<\/figure>\n\n\n\n\n
6. Specify Batch name and other details<\/strong><\/h3>\n\n\n\n
\n
\n
7. Make payment<\/strong><\/h3>\n\n\n\n
8. Download batch <\/strong><\/h3>\n\n\n\n
Case 2: Link Excel file to QR Code<\/h2>\n\n\n\n
1. Do you need the capability to edit the linked Excel at anytime<\/strong><\/h3>\n\n\n\n
2. Do you need to track scanning activity<\/strong><\/h3>\n\n\n\n
3. Do you need only authorized people to view the Excel<\/strong><\/h3>\n\n\n\n