QRsetter

QR codes from Excel: the whole spreadsheet in one run

Import an XLSX or CSV file, and every row becomes a QR code on a print-ready sheet. Up to 1,500 codes at once, free and with no sign-up.

Step 1 · Data file start here

1 link per line, the caption after a space One line = one QR code.
The caption is printed under the code: add it after the link, separated by a space. You do not have to write "https://".example.com
example.com/menu Table 5When importing CSV or Excel (XLSX), the second column of the file becomes the caption.
Limits: up to 1500 links at once, a caption up to 100 characters.

Step 2 · Look and size
Fine tuning optional

Margins

Frame

Short ticks at the corners of every cell to cut along. Needs a gap between codes of 0.5 cm or more and a sheet margin of 0.25 cm or more.

Color

No fill: the code sits on the layout background, which has to be light. In a PDF this is the color of the paper.

Step 3 · Format
free, no sign-up and no watermark ✓
Point the mouse at a code in the preview to scan it with the reader. Tap a code in the preview to scan it with the reader.
Preview of an A4 sheet with QR codes made from an Excel spreadsheet
Excel import in QRsetter
  • Drop an XLSX onto the "Pick an Excel file" button, or click it and choose the file.
  • The generator takes up to 5 columns, in any order.
  • Numeric cells come through as stored, so phone numbers and part numbers arrive in full.
  • CSV and TXT files work too.

How to make QR codes from Excel

  1. Prepare the spreadsheet. The generator reads the first worksheet in the file and takes up to 5 columns. The column order does not matter. Keep the header row. The generator recognizes it and leaves it out. If the codes hold phones, plain text, Wi-Fi networks or contact cards (vCard), switch the tab above the input field first.
  2. Load the file. Click "Pick an Excel file" or drop the XLSX onto that button. The generator shows the first 10 rows and the columns of the spreadsheet.
  3. Assign the columns. Every column gets a dropdown with the fields for the code type you picked. If the link sits in the third column and the product name in the first, set the third column to "Link" and the first to "Caption". For links, the same panel has a "Link template" field. It takes an address such as https://example.com/p/{col2}/{col3}, and the "What you get" list shows the finished lines. Click "Import". The lines go into the form and the preview redraws, and rows with errors go into a report that uses the row numbers from Excel. Lines from a one-column file or a TXT file go straight into the form.
  4. Download the file. Click "Download PDF" for sheets to print, or switch the output to SVG sheets or a PNG for every code. A PDF always comes as one file. With SVG and PNG, one sheet or one code comes as a single file, and two files or more come packed in a ZIP.

Who needs codes from a spreadsheet

Lists like these already sit in Excel: a price list with part numbers and product links, an equipment list for an inventory count, a guest list for an event, the tables in a cafe. Import the whole file instead of copying rows one at a time, and the sheets come out with all the codes and their captions. For an equipment list, the article on QR code labels for inventory covers stable links and captions with asset numbers.

The tabs "Links", "Text", "Phone", "SMS", "Email", "Wi-Fi", "Contact card", "Barcode", "DataMatrix" and "Code128" all accept a file. Pick the tab for your code type before you load the file, because the fields offered for the columns depend on it. For Wi-Fi the fields are the network name, the password and the caption. For a contact card they are the name, phone, email, organization and caption.

The generator lays the sheets out for A4 or US Letter paper. Pick the sheet format and the code size in step 2, and the preview shows how many codes fit on one sheet. The page printing QR codes on a sheet lists the numbers for each format. Print the PDF at 100% scale, because the sheet already has its own margins.

When the spreadsheet has around 100 rows, the article on how to print 100 QR codes covers the checks before the print run: duplicates, header lines and a pilot sheet. For a list kept in Google Sheets, the article on QR codes from Google Sheets covers the download and the leading zeros.

Frequently asked questions

Which file formats can I import?

XLSX (Excel 2007 and later) up to 2 MB, and CSV or TXT up to 256 KB. The generator does not read the old XLS format, so save the file as XLSX first. For a Google Sheets spreadsheet, download it as XLSX or CSV and import that file.

What goes into the caption under the code?

By default the caption comes from the second column: a product name, a table number or an asset number, up to 100 characters. Links, text, phones, email and barcodes work this way. For SMS the second column is the message text and the caption comes from the third column. For Wi-Fi the second column is the password and the caption comes from the third column too. For a contact card the caption comes from the fifth column. The generator prints the caption under every code in the PDF and the SVG sheets, and under a 2 cm code 12 characters fit, the rest is cut with an ellipsis. In the per-code SVG and PNG files it goes into the file name.

The first row of my spreadsheet is a header. Should I delete it?

No. If the first row does not look like data, the generator treats it as a header and starts from the second row.

What if the link is not in the first column?

Leave the spreadsheet as it is and assign the columns after the file loads. Set the columns you do not need to "Do not use". Values from a stock or price column never reach the codes.

Why did the generator skip some rows?

The report appears under the "Pick an Excel file" button. It lists the row number from Excel, the reason and the value. The usual reasons are an empty cell, a broken link or a caption over 100 characters. Fix the rows in the spreadsheet and import the file again.

Will long numbers turn into 7.99912E+10?

The generator reads the value stored in the cell, not the way Excel displays it. Phone numbers and part numbers from numeric cells arrive in full, with no exponent and no lost digits.

Are there limits?

One run takes up to 1,500 rows. Split a longer spreadsheet into parts and import them one after another. Run it as many times as you need.

All knowledge base articles