What This Method Does (and What Our Tools Don’t)
First, so you know where you stand: neither our free web generator nor our Mac app has a CSV import. Gen QR Code Maker is built for making codes one at a time, with colours, a logo and error correction you choose. It is not built for producing 300 shelf labels. If your real need is “one code per row of a spreadsheet”, the right free tool is already on your Mac.
Apple’s Shortcuts app (included with macOS Monterey and later) has a built-in Generate QR Code action. Add a few text-handling actions and a loop, and it will read a list, make one code per line and save each image into a folder under the name you choose. Nothing is uploaded and there’s no row limit set by a pricing plan.
This article is only about the spreadsheet-to-folder job. If you want other Shortcuts automations, such as clipboard-to-QR or a Safari URL to QR, see our Mac Shortcuts QR code guide. For an overview of every way to make a QR code on a Mac, start with the QR code generator for Mac guide.
A Mac running macOS Monterey (12) or later with the Shortcuts app, a spreadsheet app (Numbers, Excel or Google Sheets) and TextEdit. Every tool here is free and works offline once your list is on the Mac.
Prepare the Spreadsheet
Most failed batch jobs come from the data, not the shortcut. Spend five minutes here and the rest is mechanical. You need just two columns per row:
- Column A: file name, such as
sku-A100,badge-042orroom-12-wifi. Use letters, numbers, hyphens and underscores only. Every value must be unique or later files will overwrite earlier ones. - Column B: payload, meaning the exact text the code will contain. For a website that’s the full URL with
https://. For anything else it’s a short formatted string that phones know how to read.
Payload formats that phones understand
The Generate QR Code action encodes whatever text you give it. To make a phone offer “Join network” or “Call” instead of just showing text, write the payload in one of these widely supported formats:
- Website:
https://example.com/products/A100 - Phone call:
tel:+15551234567(international format) - Email:
mailto:orders@example.com?subject=Order%20A100(encode spaces as %20) - Wi-Fi:
WIFI:T:WPA;S:GuestNet;P:secret123;; - Plain text:
BIN-42 ZONE-C ROW-7
You can build these with a formula instead of typing them. For a Wi-Fi sheet with the network name in column C and the password in column D, a column B formula like ="WIFI:T:WPA;S:"&C2&";P:"&D2&";;" produces the payload for every row. In the Wi-Fi format, a semicolon, comma, colon, backslash or double quote inside the name or password must have a backslash in front of it. Our Wi-Fi QR code guide explains the format in more detail.
Export a pipe-separated text file, not a raw CSV
This is the trap that catches most people. A CSV separates columns with commas, but Shortcuts’ Split Text action doesn’t understand CSV quoting. Any comma inside a value, whether in a password, a product name or a URL query, splits the row in the wrong place. The fix is to join each row with a character that never appears in your data:
- In a spare column, enter
=A2&"|"&B2and fill it down to the last row. Each cell now reads something likesku-A100|https://example.com/products/A100. - Select that column (data rows only, no header row) and copy it.
- Open TextEdit, choose Format → Make Plain Text, paste, and save as
qr-list.txt.
If your file came from a CSV export, this step also avoids two smaller problems: a hidden byte-order mark at the start of the file, and Windows-style line endings that would put an invisible carriage return at the end of every payload.
Build the Batch Shortcut
Open Shortcuts, click + to create a new shortcut, and add the following actions from the action library on the right. Search each one by name.
Spreadsheet to QR Codes: Action by Action
Select File. Prompts you to choose qr-list.txt each time you run it. You can also use a fixed File action if the list always lives in the same place.
Split Text by New Lines. This turns the file into a list with one entry per row.
Repeat with Each item in the split text. Everything from steps 4–8 goes inside this loop.
Split Text the Repeat Item by a Custom separator: |. Each row becomes a two-item list.
Get Item from List → First Item, then Set Variable named FileName. Add a second Get Item from List → Item At Index 2 (taken from the split text, not the variable) and set it to a variable named Payload.
Generate QR Code from Payload. Open the action’s options and set the error correction level. Medium suits clean indoor labels; use High for codes that may get scuffed.
Set Name of the QR code image to FileName. If the saved files arrive without an extension, set the name to FileName followed by .png.
Save File into a folder such as ~/Desktop/QR-Output. Turn off Ask Where to Save so it doesn’t prompt for every row.
Here is the same shortcut as a compact outline you can compare against your editor:
Select File // qr-list.txt (no header row)
Split Text [New Lines]
Repeat with Each (Split Text)
Split Text Repeat Item [Custom: |]
Get Item from List [First Item] → Set Variable FileName
Get Item from List [Item At Index 2] → Set Variable Payload
Generate QR Code Payload [Error Correction: Medium/High]
Set Name QR Code → FileName
Save File → ~/Desktop/QR-Output [Ask Where to Save: off]
End Repeat
Run it on a five-row test file first. When the five images appear in the output folder with the right names, run the full list. You can also pin the shortcut to the menu bar or give it a keyboard shortcut in its settings, so the next batch is one click away.
File Names & Common Traps
When a batch gives odd results, the cause is nearly always one of these:
- A header row slipped in. If the first image is called
filenameand encodes the word “payload”, you copied the header. Delete that line from the text file. - Empty last line. A blank line at the end of the file can produce an error or an empty code on the final loop. Remove trailing blank lines in TextEdit.
- Duplicate file names. Two rows named
sku-A100means the second overwrites the first, or gets a numbered copy, depending on the Save File setting. Check uniqueness in the spreadsheet with aCOUNTIFbefore exporting. - Unsafe characters in names. A slash or colon in a file name confuses macOS. Keep names to letters, numbers, hyphens and underscores.
- Spaces around the pipe.
sku-A100 | https://…encodes a URL that starts with a space, and some scanners won’t open it. Build the joined column with a formula rather than by hand. - Very long payloads. The more text you encode, the denser the code and the larger it must be printed. Keep URLs short, for example
example.com/p/A100rather than a long tracking-laden link.
Save qr-list.txt next to the output folder. It is your record of which file holds which content, and rerunning the shortcut on it rebuilds the whole set exactly if you ever lose the images.
QR Code Apps for Mac & Safari
Prefer generating codes without opening a browser tab? These two native Apple apps cover both habits — a full generator on the desktop, and a one-click share button inside Safari.
Check Before You Print
A batch job means every mistake is repeated hundreds of times, so test a sample before sending anything to a printer.
- Scan a sample with more than one phone. Pick the first, a middle and the last image and scan them from the screen with an iPhone Camera and an Android camera. Check each opens the right destination.
- Check the pixel size. Open one image in Preview and choose Tools → Show Inspector to see its dimensions. Make sure that’s enough for your printed size at your printer’s resolution. Our print resolution guide shows how to work it out.
- Leave the quiet zone. The QR standard (ISO/IEC 18004) calls for a clear margin four modules wide around the code. Don’t let label templates crop into it.
- Size for scanning distance. A shelf label read at arm’s length can be small. A poster read from across a room can’t. See the QR code size guide.
- Print one test sheet on the actual label stock and scan it under the lighting where it will be used.
To lay the images out, drag the output folder’s contents into a label template in Pages, Word or your label printer’s software. Because each file is named after its row, matching images to labels is straightforward.
When to Use Something Else
The Shortcuts batch gives you plain black-on-white codes, which is right for labels, badges and inventory. A few situations call for a different tool:
A handful of codes that need to look on-brand
If you have, say, a dozen codes for packaging or signage and they need your colours or a logo, make them one by one in Gen QR Code Maker ($5.99 once on the Mac App Store). It adjusts error correction automatically when you add a logo, keeps codes organised in projects and colour-tagged folders, and its Collage export puts two or four codes side by side on a printable sheet. It doesn’t batch-import, so it suits small, designed sets, not long lists.
One or two codes, right now
For a single URL, Wi-Fi network, email address or phone number, the free generator on our homepage is quicker than any shortcut. It runs in your browser without uploading your data and downloads PNG or SVG. If you work in Safari a lot, Tab to QR ($1.99 once) turns the current tab into a QR code from the toolbar.
You may need to change destinations after printing
Batch-generated codes are static: whatever you encode is permanent. If product pages might move, don’t encode their full URLs directly. Encode short addresses on a domain you control, like https://example.com/p/A100, and set up redirects on your website. You can then change where each one goes without reprinting, and add UTM tags to see scans in your analytics (see how to track QR code scans in GA4). If you need hosted redirects, scan dashboards and team management without running your own site, that’s what subscription dynamic-QR platforms are for. Our tools don’t offer it.
You’d rather script it
If you’re comfortable with code, a short script reading the CSV properly (quotes and all) is the most robust option for very large or recurring jobs. See generating QR codes with Python or Apple’s native route in CIFilter QR codes on macOS.
Build a file-name column and a payload column, join them with a pipe, paste into a plain-text file with no header, and run a Shortcuts loop: Split Text → Generate QR Code → Set Name → Save File. Test five rows, scan samples on two phones, then print. Use Gen QR for the few codes that need branding.
Frequently Asked Questions
No. Gen QR Code Maker makes codes one at a time, with colours, a logo and error correction you choose, and keeps them organised in projects and folders. It has no CSV import or batch export. For a long list of plain codes, use the free Shortcuts method on this page; use Gen QR for the handful of codes that need styling.
Yes. The Shortcuts app that comes with macOS has a Generate QR Code action. Combined with Split Text and Repeat with Each, it can read a text file with one row per code and save one named image per row into a folder. It runs on your Mac and costs nothing.
Build the Wi-Fi payload string in a spreadsheet column, for example WIFI:T:WPA;S:NetworkName;P:Password;; and encode that string as plain text. Phones recognise this format and offer to join the network. If the network name or password contains a semicolon, comma, colon or backslash, put a backslash in front of that character.
The Split Text action in Shortcuts splits on every separator it finds and does not understand CSV quoting. A comma inside a value, such as in a Wi-Fi password or a URL query, would cut the row in the wrong place. Joining each row with a character that never appears in your data, such as a pipe, avoids that.
Apple does not publish a limit for this, and speed depends on your Mac. Test with five rows first, then run the full list. For very long lists, split the file into chunks of a few hundred rows so a problem in one row is easy to find.
No. Codes made this way are static: the data is stored in the pattern itself, so they keep working as long as the destination exists. If you may need to change destinations later, encode URLs on your own domain and manage the redirects there.