Data Import & Export

How to Generate QR Codes or Barcodes from an Excel List in WPS Spreadsheet

Amos GikundaAmos Gikunda Nov 13, 2026 874 views

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.

How to Generate QR Codes or Barcodes from an Excel List in WPS Spreadsheet
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 you start

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.

Solution 1Recommended

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.

1
Download a compatible add-in from a trusted vendor

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.

2
Enable the add-in in WPS Spreadsheet

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.

3
Run the add-in on your list

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.

4
Verify the generated codes

Spot-check several rows with a phone scanner or barcode scanner to confirm that each code matches the source value before sharing or printing.

Use a trusted barcode or QR add-in in WPS Spreadsheet
Bulk generation works best: This method automatically applies the same barcode or QR code format to every row in the selected range.
Direct WPS Spreadsheet solution

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. 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. 2. Select the data range to encode: Highlight the worksheet cells that contain the values for the QR codes or barcodes.
  3. 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. 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. 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.
Excel-compatible .xlsx support keeps your existing list and generated codes in a familiar workbook format.Bulk generation from a selected range avoids repetitive online tools for each person.Free to download and lightweight, with a familiar spreadsheet interface.Compatible with many Excel barcode and QR add-ins and VBA workflows on supported Windows versions.
microsoft office alternative - wps office

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.