Generate Barcodes Easily: A Step-by-Step Guide Using Google Sheets

Have you ever wanted to convert the data entered in your spreadsheet into barcodes?

By utilizing barcodes, you can streamline tasks such as product management and inventory tracking.

In this article, we’ll show you how to easily generate barcodes using Google Sheets and external services.

Just like generating QR codes, you can create barcodes by entering formulas.

あわせて読みたい

スプレッドシートで数式を使ってQRコードを簡単に作成する方法 QRコードを作成したいと思っても、ツールを使ったりコードを書くのは難しい…そう思ったことはありませんか？ Googleスプレッドシートなら、数式を使って簡単にQRコード…

Output Example

Enter data in column A
Enter the formula in column B to generate the barcode

In the spreadsheet, the entered data is automatically converted into barcodes.

Converting data into barcodes enables efficient management of products and inventory.

URL Used in the Formula

https://bwipjs-api.metafloor.com/?bcid=code128&text=YourData

In this formula, we will use the Image function, which incorporates an external service called ‘Barcode Writer in Pure JavaScript (BWIP-JS),’ an open-source API for generating barcodes.

By including data and settings in the URL, you can instantly generate barcodes in image format.

It is free to use and supports a variety of barcode formats.

• Code 128
• QR Code
• EAN-13
• UPC-A

Steps to Generate Barcodes

STEP

Enter Data into the Spreadsheet

Enter the data to be converted into barcodes in column A.”

(The first row is the header row)

STEP

Generate Barcodes Using the IMAGE Function

Enter the following formula in column B (e.g., cell B2):

=IMAGE("https://bwipjs-api.metafloor.com/?bcid=code128&text="&ENCODEURL(A2))

You can change the type of barcode by modifying the formula as follows:

Examples of Modifiable Barcode Formats:

• code128 → Code 128
• qrcode → QR Code
• ean13 → EAN-13（International Article Number (EAN)）
• upca → UPC-A (North American Product Number)

Copy the formula to the rows below as needed.

STEP

Verify the Barcodes

Barcodes will be generated in column B.

When the data in column A is edited, the barcodes will also be updated.

Conclusion

By entering formulas in Google Sheets, you can generate barcodes without incurring any costs or extra effort.

Use this to streamline your daily tasks.

あわせて読みたい

Chrome拡張機能を使ってスプレッドシートでQRコードを作成する方法 GoogleスプレッドシートでのQRコード作成は、数式を使った方法のほか、拡張機能を使うことでも手軽にQRコードを作成できます。 この記事では、拡張機能を使ってQRコード…

Our company offers support for improving work efficiency through the use of Google Apps Script.
If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us.
We are fully committed to supporting your business improvements.

Contact us here