Making QR Code in Microsoft Excel
Some examples, how to use StrokeScribe barcode generator to make QR Code in Excel. The Active Document is the easiest one but allows less customization. The ActiveX-based method is VBA friendly.
For more methods, look in the Related Tutorials.
The examples work with all Excel versions starting from Excel 2007 (excluding online version of Office). The Internet connection is not needed and no third-party online services are used.
Setup
- Download and install the barcode generator.
Placing QR Code in Excel as an Active Document
1. Switch to the Insert tab on the Excel Ribbon and click Object.
2. Look for the StrokeScribe Document in the list of available objects:
3. Right-click the barcode object, select StrokeScribe Control->Properties from the context menu;
Go to the General tab in the barcode properties dialog;
Set Alphabet = QRCODE;
Type any text in the Text field.
QR Code Customization
Switch to the Code-specific 2 tab in the barcode properties dialog.
Here you can set the error protection level and minimum size of the QR CODE matrix.
Micro QR Code
To create a MICRO QR code, set the Alphabet property as shown on the picture:
Related Tutorials
- Barcode in Microsoft Excel
- Using Formula to Create Barcode in Excel
- Using DLL version of the barcode generator in Excel
FAQ: Creating QR Codes in Excel
Q: How do I customize the QR code in Excel?
The level of customization depends on the typa of the barcode generator you’re using. In most cases, you can:
- Dynamically change the content to generate new QR codes.
- Adjust the size of the QR code by resizing the image.
- Choose the desired error correction level for the QR code.
- You may change the color of QR code.
Yes, you can create a batch of QR codes in Excel by using our formula-based example and COM-version of our QR code generator. This feature allows to generate QR codes for multiple rows or columns at once.
Q: Can I automate QR code generation in Excel?
Yes, using VBA and COM- or DLL- versions of the barcode generator. You can write a VBA script (see the examples above) to create QR codes automatically based on cell data.
Q: What types of data can I turn into a QR code in Excel?
You can create QR codes for various types of data, such as:
- URLs
- Text
- Contact information (vCards/business cards)
- Emails
- Phone numbers
- Wi-Fi network credentials
- Any binary data
Q: Is there a limit to the size or number of QR codes I can create in Excel?
There is no strict limit imposed by Excel. But, if you are trying to ues ActiveX objects to create QR codes, we do not recommend to create more than 1000 objects.
The font-based method QR code generation or methods provided by COM- and DLL- versions of our QR code generator allow to create an unlimited number of QR codes on a single Excel's worksheet.
Q: Can I create dynamic QR codes that update automatically when data in Excel changes?
Use our formula-based example to create QR codes or link an ActiveX instance of the barcode generator to a cell using the LinkedCell property.
Q: Why is my QR code not scanning properly?
If your QR code isn't scanning correctly, check the following:
- Resolution: The QR code should not be too small. Ensure it’s large enough for scanners to recognize.
- Content: Ensure the data encoded in the QR code is valid and properly formatted when encoding GS1, banking, postal barcodes.
- Placement: Avoid placing QR codes near the edges of the page or too close to the surrounding content.
© 2026 StrokeScribe. All rights reserved. Use of any portion of this site constitutes acceptance of our Terms of Use and Privacy Policy. The website material may not be reproduced, except with the prior written permission.