QR Code Generator

Excel File to
QR Code Generator

Quickly create professional QR code lists, a time-saving and labor-saving digital solution.
Supports bulk generation, custom layout, and direct printing.

❌ No need to learn complex design software or Excel commands
❌ No need to manually generate and download QR code images one by one
✅ Upload Excel, complete bulk production in minutes
Start Now

1. Select Data Type

2. Upload File

Input Example: Two Column Data (Text + URL)

Product 1 Order Link https://today.line.me/
Product 2 Order Link https://google.com
Add Sales Rep 1 on LINE https://www.youtube.com

Input Example: Single Column Data

https://today.line.me/
https://google.com
https://www.youtube.com

You can also enter text directly, one URL per line

3. Choose Layout Settings

🏢 Business Use Cases

In the digital age, QR codes have become an important bridge connecting the online and offline worlds. Whether you are an event planner, store staff, restaurant owner, or educator, you need to quickly create a large number of QR codes. Our tool allows you to easily convert Excel lists into professional QR codes, saving time and effort.

🎯 Event Management

Check-in systems, data collection, surveys

🛍️ Retail Stores

Product information, member registration, promotions

🍽️ Food & Beverage

Digital menus, online ordering, review systems

📚 Education & Training

Material downloads, assignment submissions, course links

🎨 Exhibition Tours

Exhibit information, multimedia content, audio guides

🏠 Real Estate

Property details, VR tours, contact information

Restaurant Digital Transformation

A restaurant chain used this tool to bulk generate QR codes for online menus corresponding to all table numbers. Customers can scan the code to browse the menu and order online, improving dining efficiency.

Event Check-in System

An event company created QR codes from the attendee list, with each code linking to an individual's check-in page, significantly reducing on-site registration time.

Product Display Application

A 3C store created QR code labels for detailed product specification pages. Customers can scan them to view complete product information, reducing the need for staff consultation.

📋 How to Use

📁

1. Upload File

Select data type, upload your file. Supports .xlsx and .csv formats.

🎨

2. Adjust Layout

Set the number of items and style.

🖨️

3. Preview, Print, or Download

After a live preview, you can print directly or save as a PDF file.

❓ Frequently Asked Questions

Q: What if my Excel file has blank rows or cells?
A: The system automatically skips blank rows, but an error will be shown if the URL field is empty. It's recommended to clean up your data before uploading.

Q: For A4 paper in portrait orientation, how many QR codes are recommended per row?
A: It is recommended not to exceed 5. If the QR codes are too small, they may be difficult to scan. We suggest the QR code size should be no smaller than 1.5cm x 1.5cm, as smaller sizes can affect scannability.

Q: Can I customize the color of the QR codes?
A: Currently, only black and white QR codes are supported to ensure optimal scanning compatibility.

Q: Can I hide the text below the QR code?
A: Yes, you can uncheck "Show text below QR Code" in the layout settings to display only the QR code.

Q: What is the purpose of the border?
A: The border helps with cutting and alignment, especially useful when creating stickers or labels.

Q: Does the URL have to include http://?
A: Yes, the full protocol (http:// or https://) must be included, otherwise the QR code may not open correctly after scanning.

Q: Are URL shortening services supported?
A: Yes, any valid URL format can be converted, including short URLs from services like bit.ly, tinyurl, etc.

Q: Can I use Google Forms links?
A: Yes, links from various Google services like Google Forms, Google Drive, and YouTube are supported.

Q: Are links to LINE Official Accounts or Facebook Pages supported?
A: Yes, links to various social media platforms, including LINE, Facebook, Instagram, etc., are supported.

Q: Why does it sometimes crash?
A: This is usually due to a large file size or too many data entries. Depending on your computer or tablet's performance, it's recommended to process in batches, trying not to exceed 500 entries at a time.

Q: What should I do if the generated QR code won't scan?
A: Please check the following:
1. Is the URL format correct?
2. Is the QR code size too small?
3. Is the print quality clear?
4. Is your phone's scanning app working correctly? Try scanning other QR codes.

Q: What are the limitations of the link checking feature? Why can't it detect some broken links?

A: Due to browser security restrictions, our link checking feature has the following limitations:

Cases that can be detected:
  • Domain does not exist or DNS resolution fails
  • Connection timeout (no response within 5 seconds)
Cases that cannot be detected:
  • Server errors (e.g., 500, 502, 503)
  • Page not found but server is responsive (e.g., 404 error)
  • Pages requiring login or authentication
  • Links blocked by certain firewalls or security settings
Why these limitations?
This is because we use front-end technology for detection, which is subject to the browser's cross-origin security policies. While not 100% accurate, it can help you quickly filter out most problematic links.

It is recommended to manually check a sample of the links that pass the check. Important links should always be tested manually.
If you find a discrepancy between the detection result and the actual situation, this is normal.

We choose not to provide a back-end detection feature to prevent the connection checking function from being used for illicit purposes. If you require a connection monitoring service, please contact us using the information at the bottom of the page.

Q: Are there other free methods to quickly generate QR codes from Excel?

A: You can use a third-party image generator with the IMAGE function. Here's an overview of how to do it:

  1. Enter the URLs in column A of your Excel file.
  2. In column B, enter =IMAGE("https://api.excelapi.org/other/qrcode?text=" & A1)
  3. Press Enter, and an image will appear in column B.
  4. Drag down to automatically generate QR code images for the URLs in A1, A2, etc.

Disadvantages:

  • The IMAGE function is not supported in all versions of Microsoft Office. It's not available in Office 2017 or 2019; you need a paid Office 365 subscription or to use the online version at office.com (OneDrive workbook).
  • The image generation URL uses a third-party service like ExcelAPI. ExcelAPI has a daily free quota, and you can't use it once you exceed it. If the service disappears or becomes unavailable, you'll have to find an alternative. For example, some online tutorials mention "chart.googleapis.com", but that service has been discontinued.

If you use Google Docs, it also has an IMAGE function. You can also go to Extensions > Add-ons > Get add-ons, search for "QRCode", and find some batch QR code generation tools.

Why Choose Our QR Code Generator Tool?

🔒 Privacy & Security

  • We do not store your file content.
  • All processing is done locally in your browser.
  • No registration required, protecting your privacy.

🆓 Completely Free to Use

This tool is completely free, with no usage limits or watermarks, allowing you to focus on your business without worrying about extra costs.

If you need to track scan counts for each QR Code, generate standard barcodes, or have other layout/functional requirements, please contact us: