How to generate QR codes from a spreadsheet and keep filenames matched

by•

A batch of QR images is only useful if the person handling the files can match each image to the right destination. Here is a reproducible workflow for KitMoro QR Studio.

Disclosure: I develop KitMoro. This guide was prepared with AI assistance and checked against the current implementation and a previously decoded three-row sample. The sample is not a customer case study.

1. Prepare name and url columns

Use descriptive names and the full destination URL, for example:

name,url

Event agenda,

Venue directions,

Feedback form,

These are placeholder destinations. Replace them with your real links and verify that each page is accessible to the intended audience.

2. Export the sheet as CSV

Export the relevant sheet as CSV, preferably UTF-8. KitMoro accepts CSV or pasted URLs; it does not import native XLSX workbooks. Let your spreadsheet app quote names containing commas.

Choose Static when the QR should directly encode the supplied URL. Static batches run in the browser, need no account, and support up to 100 URLs per batch. The exported code does not need KitMoro to stay online, although the destination website still needs to work.

3. Keep the images and mapping file together

The ZIP contains PNG and SVG images plus links.csv. The mapping file records each name, encoded URL, destination, and PNG filename. Numbered filename prefixes keep repeated labels from overwriting one another. PNG exports are 768 by 768 pixels; SVG is available for scalable artwork.

Send the mapping file with the images when handing them to a designer or printer. A successful download alone does not establish that the correct image is beside the correct label.

4. Check the final artwork

Compare the mapping file with the approved source sheet. Scan the exported codes and inspect their destinations. Check the printed captions, preserve the clear border, and scan a proof at the intended print size and on the intended material.

Our three-row sample was decoded successfully. That checks those sample outputs, not every print size, surface, or phone camera.

5. Decide whether you need editable destinations

A static code cannot change when you edit the spreadsheet later. A dynamic code instead contains a redirect address, whose destination can be edited while the printed pattern stays the same. This adds a dependency on the redirect service.

KitMoro currently supports 20 editable links per private workspace. Retain the private recovery key: there is no email recovery. Do not include that key in your print handoff.

The generator, CSV template, and downloadable example ZIP are here:

The example files use placeholder URLs. Current scope is URL QR codes, CSV input, and PNG/SVG/ZIP export; a customer API, team accounts, and native XLSX import are not available.

When you hand a batch to another person, do they work primarily from filenames, a mapping spreadsheet, or a visual proof sheet? That distinction would help determine which part of the handoff to improve next.

2 views

Add a comment

Replies

Be the first to reply

Have a question or a thought to share? Add a comment above to start the conversation.