Skip to content

Bulk QR code and barcode generator

Paste your list and get a named code for every row. Up to 500 a batch, free with no account.

Or barcodes: EAN-13, UPC-A, Code 128 and more.

What is in your list?

One web address per row.

Static or dynamic?

A kind column in your file decides row by row; rows left blank follow this choice.

The template's columns are label, value and kind.

Name each row, like Table 4, https://example.com/table-1. The name becomes the file name now and the label you search for later.

0 rows read

Paste two columns, get a named code for every row

  1. Paste two columns. Names, then links. Copy them straight from Excel or Google Sheets, or upload a CSV.
  2. Generate. Every code shows in the preview. Rows that can’t become a code are listed with the reason, and the rest go ahead.
  3. Download. PNG or SVG, numbered and named from the row: 1-Table-4.png. More than 8 files come as one ZIP.

Codes you can’t edit later are made in your browser, so those rows never leave your device.

Set up your sheet: name in A, link in B

A: name
Names the file. Cut at 40 characters. Leave it out and the link names the file.
B: link
The link or text the code opens. A row with this cell blank is skipped.
Heading row
Optional. A first row like Name, Link is skipped.
Separator
Commas, tabs and semicolons all work. A paste from Excel uses tabs.

Rows that get left out are listed with the reason, such as a product number with a wrong check digit. Fix them in the sheet and paste just those again.

A QR code in every Excel cell, with one formula

With your links in column A, put this in B2 and fill it down. Every row gets a code for its link.

=IMAGE("https://app.qrsalt.com/api/qr/free?format=png&size=256&data="&ENCODEURL(A2))
  • Needs IMAGE() and ENCODEURL(), as in Excel for Microsoft 365 on Windows, not on a Mac or the web. Google Sheets takes the same formula.
  • 240 codes an hour, shared by your network. For longer lists, paste them into the tool above.
  • These codes can’t be changed later, and scans aren’t counted.

Bulk barcodes, with every check digit checked

Switch the tool to Barcodes for 12 types, from EAN-13 and UPC-A to Code 128. Each row is checked before anything is drawn:

  • Error, with the row number: Row 14: the check digit should be 7, not 2. That row is left out.
  • Fixed: one digit short, so the check digit was added. A wrong one is never replaced, and one click undoes every fix.
  • Repeat: marked and kept, since twenty labels for one product is normal.

The ZIP has a report.csv with each row’s status. To pick a type, see the barcode generator.

Print on label sheets: 10 to 30 labels a page
Label sheet layouts for printing barcodes
PaperLabels a sheetLabel sizeSold as
A424 (3 × 8)63.5 × 33.9 mmL7159 size
A424 (3 × 8)70 × 37 mmEdge to edge, no gaps
A421 (3 × 7)63.5 × 38.1 mmL7160 size
A414 (2 × 7)99.1 × 38.1 mmL7163 size
US Letter30 (3 × 10)2⅝ × 1 in5160 size
US Letter20 (2 × 10)4 × 1 in5161 size
US Letter10 (2 × 5)4 × 2 in5163 size

You get a vector PDF, one page a sheet. Start at any label to use up a half-used sheet. You’re warned when barcodes would print below 80% of standard size. Print at actual size, never “fit to page”.

Codes you can change later: import a file from Starter

The codes above can’t be changed after printing. From Starter ($5 a month), upload a file of up to 1,000 rows as editable codes, up to 100 on that plan.

Each one counts its scans. Later you can pause, move or re-tag up to 500 at once from your list of codes.

Bulk QR codes, answered

Can I generate QR codes from an Excel file?

Not from the .xlsx itself. Copy the two columns and paste them, or save the sheet as CSV and upload that.

How many QR codes can I make at once?

500 a batch, free. Paste a longer list and the first 500 are made; paste the rest as a second batch.

Is my list uploaded?

No. Codes that can’t change are drawn in your browser. Rows you mark for editable codes are sent only when you press Continue, and we keep them for a day so they’re waiting in the importer.

How do I put the codes into a mail merge?

Add a column with each row’s file name, with the folder in front. In InDesign’s Data Merge, start that column’s heading with @ and every record gets its own code.

The Free plan gives you 3 editable codes. Paid plans start at $5 a month. See pricing or browse every tool.