How to Generate QR Codes or Barcodes from an Excel List in WPS Spreadsheet
Question details
The user needs an automated way to create a QR code or barcode for every row in an Excel-compatible list instead of using a separate online generator for each entry.

- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- Creating bulk QR codes or barcodes for a list of people, IDs, URLs, or other values stored in a spreadsheet.
- Observed behavior
- Excel does not offer a universal built-in formula for all barcode types, so users must use an add-in, image formula, or reviewed VBA macro.
Before generating codes, arrange your data as a clean spreadsheet table with a dedicated column for the values to encode, and confirm that you have permission to install or enable the barcode/QR solution you select. Also verify the publisher of any add-in or macro file before you open it.
Use a trusted barcode or QR add-in in WPS Spreadsheet
Best for bulk lists and one-click generation without editing VBA code; use a reviewed third-party Excel add-in that is compatible with WPS Spreadsheet.
Add-ins process all selected rows at once and are easier to manage than separate online generators. Only install add-ins from vendors you trust, and check the downloaded file with antivirus software before enabling it.
Visit the vendor’s official site, download the Excel add-in (.xlam or .exe installer) for the barcode or QR type you need, and scan the file before opening it.
In WPS Spreadsheet, go to File > Options > Add-ins, choose Excel Add-ins from the Manage list, click Go, then browse to and enable the downloaded add-in.
Select the cells or column containing the values to encode, open the add-in from the Add-ins tab, choose the QR code or barcode format, set the output column, and click Generate.
Spot-check several rows with a phone scanner or barcode scanner to confirm that each code matches the source value before sharing or printing.

Generate QR codes with an online image formula
Use this no-install option when you only need QR codes and your version of WPS Spreadsheet supports the IMAGE function.
Use a VBA macro to generate codes row by row
Use this approach for highly customized barcode types or when you already have a reviewed VBA macro from a trusted source.
Generate QR Codes or Barcodes from an Excel List with WPS Spreadsheet
WPS Spreadsheet opens and saves Excel workbooks, so you can bulk-generate QR codes or barcodes from an existing list using a trusted add-in, an online QR image formula, or a reviewed VBA macro—without switching to a separate one-by-one generator.
- 1. Open your list in WPS Spreadsheet: Launch WPS Office, open the Excel workbook containing the person list or data values, and confirm the column you want to encode is clean.
- 2. Select the data range to encode: Highlight the worksheet cells that contain the values for the QR codes or barcodes.
- 3. Use an add-in, formula, or macro: Apply a trusted barcode or QR add-in, an IMAGE-based QR formula, or a reviewed VBA macro to generate each code in the output column.
- 4. Check a few results: Scan several generated codes with a phone or barcode scanner to verify they match the original values before printing or sending the file.
- 5. Save as Excel-compatible workbook: Go to Menu > Save As and keep the .xlsx format so the file remains compatible with Microsoft Excel and other spreadsheet apps.

Frequently Asked Questions
Does WPS Spreadsheet have a one-click built-in barcode generator?
WPS Spreadsheet does not have a universal built-in barcode generator for all barcode types. You can use a trusted third-party Excel add-in, an IMAGE-based QR formula, or a reviewed VBA macro, then fill the result down the list.
Can I use the same Excel barcode add-in I already have in WPS Spreadsheet?
Many Excel add-ins work in WPS Spreadsheet on Windows, but compatibility is not guaranteed. Enable the add-in through File > Options > Add-ins and test it on a copy of your workbook first.
How do I generate a QR code for every row without typing a formula for each row?
Create the formula or run the add-in once in the first row, then drag the fill handle down or run the add-in over the selected range to generate all rows in bulk.
Is it safe to enable VBA macros for barcode generation?
Only enable macros from a source you trust. Scan the downloaded file, review the macro code if possible, and test it in a copy of the workbook before using it with real data.
Will the generated barcodes stay compatible with Microsoft Excel?
Yes. Save the workbook in .xlsx format in WPS Spreadsheet, and the list and generated images or values remain compatible with Microsoft Excel.




