Make hundreds of QR codes from one CSV file
Upload a spreadsheet with one row per code, check it, and create them all at once. Every code is dynamic, so you can change any of them later. Or loop over the API from your own software.
- Up to 500 rows a file
- Every link back as a CSV
- Change any code later
title,type,destination Spring flyer,url,https://example.com/spring Store 12 poster,url,https://example.com/stores/12 Call the front desk,phone,+1 555 010 2030 Guest Wi-Fi,text,"Network: Lobby, Password: welcome" Bookings,email,[email protected]
How bulk upload works
Sign in, open QR Codes and choose Create Many.
Download the sample file if you want a starting point, and fill in one row per code.
Upload the CSV. Every row is checked before anything is made, and rows with a problem say what’s wrong.
Choose Create. A progress bar shows the codes being made, one row at a time.
Choose Download links to get a CSV with each code’s title and short link.
The CSV format
The first line names the columns: title, type and destination.
Working in Excel, Numbers or Google Sheets? Export or save the sheet as CSV first. An SMS code made from a file texts the number with no message filled in.
- title: the code’s name in your dashboard. Leave it blank and the code is called QR code 1, QR code 2 and so on.
- type: url, text, phone, sms or email. Leave the column out and every row is a website code.
- destination: the web address, the text to show, the phone number or the email address.
- Put quotes around a cell that has a comma in it, as most spreadsheet apps do for you.
- Up to 500 rows in each file. For more, split them across files.
What you get back
Every row becomes its own dynamic code, with its own short link, analytics and history. They appear in your QR codes list straight away.
Download links gives you a CSV with each code’s title and short_url. Hand it to a print shop or a mail merge, or fetch the images from the API. In the dashboard, images are downloaded one code at a time: there isn’t a single download for every image yet.
Plan limits
- Free: 25 codes on the account, with each table on a menu counting as one. When a file would go past that, the rows that fit are made and the rest are marked with the reason.
- Premium, $5 a month: no limit on codes. A file can still have up to 500 rows, so larger batches go in several files or through the API.
Create codes in bulk from the API
When the list lives in your own system, create codes in a loop and save the images as you go.
There’s no single bulk endpoint, so send one POST /qr per code. Premium allows 10,000 requests an hour. If you go over, the reply is a 429 with a Retry-After header: wait that many seconds and try the same row again. A 403 means the plan has no room or the key can only read, so stop there.
Tag each batch, such as spring-2027, so you can find the whole set later with GET /qr?tag=spring-2027 and change them together.
# pip install requests
# codes.csv has the columns title, type and destination, as above.
import csv
import os
import time
import requests
BASE = "https://pikaqr.com/api/v1"
session = requests.Session()
session.headers["Authorization"] = f"Bearer {os.environ['PIKAQR_KEY']}"
def create(row):
kind = row["type"] or "url"
field = "destination_url" if kind == "url" else "content"
while True:
res = session.post(f"{BASE}/qr", json={
"title": row["title"],
"qr_type": kind,
field: row["destination"],
"tags": ["spring-2027"],
})
if res.status_code != 429:
return res
time.sleep(int(res.headers.get("Retry-After", "60")))
os.makedirs("images", exist_ok=True)
with open("codes.csv", newline="") as source, open("created.csv", "w", newline="") as out:
writer = csv.writer(out)
writer.writerow(["title", "id", "short_url"])
for row in csv.DictReader(source):
res = create(row)
body = res.json()
if res.status_code == 403:
print("Stopped:", body["error"])
break
if not res.ok:
print("Skipped", row["title"], "-", body["error"])
continue
writer.writerow([row["title"], body["id"], body["short_url"]])
image = session.get(f"{BASE}/qr/{body['id']}/image", params={"format": "svg"})
with open(f"images/{body['short_code']}.svg", "w") as file:
file.write(image.text)Many codes for one menu
For a restaurant, a bar or a hotel, a menu code with tables is often better than separate codes. Each table gets its own printed code that opens the same menu, and the scans show which table they came from. Change the menu once and every table follows.
Add a numbered run with POST /qr/:id/tables, such as Table 1 to Table 12, up to 100 at a time. The dashboard can print every table’s code on one page, each labelled with its name. Free allows 5 tables on each menu, and Premium allows 500.
curl https://pikaqr.com/api/v1/qr/$MENU_ID/tables \
-H "Authorization: Bearer $PIKAQR_KEY" \
-H "Content-Type: application/json" \
-d '{ "name": "Table", "from": 1, "to": 12 }'Questions
How many QR codes can I make at once?
Up to 500 from each CSV file. Free accounts have 25 codes in total, and Premium has no limit, so you can upload as many files as you need.
Can I upload an Excel file?
Save or export it as CSV first. Excel, Numbers and Google Sheets can all do this. Keep the first row as the column names: title, type and destination.
Are bulk QR codes static or dynamic?
Dynamic. Each one holds its own short link, so you can change where any of them goes later and see how often each one is scanned.
Can I download all the images at once?
Not as one file yet. Download links gives you every short link in a CSV, and the API can save each image in a loop. Tables on a menu can be printed together on one page.
Can I change many codes later?
Yes, from the API. Tag them when you make them, list them with GET /qr?tag=, and send a PATCH for each one. In the dashboard, you change them one at a time.