Many people use Google Sheets as their preferred spreadsheet application. This step-by-step guide explains how to generate barcodes in Google Sheets using Orca Scan’s Free Barcode Image API.
=IMAGE(CONCAT("
https://barcode.orcascan.com/?data=
", B2))
to the Barcode Image column
That’s it! You’re now able to generate barcode images in Google Sheets.
The Orca Scan barcode image API supports 12 different types of barcodes. Use the following steps to create different types of barcode images:
=IMAGE(CONCAT("
https://barcode.orcascan.com/?type=code128&data=
", B2))
code128
in the above formula with your desired typeThat’s it! You can now generate 12 different types of barcodes in your Google Sheet.
=IMAGE("
https://barcode.orcascan.com/?type="&C2&"&data=
"&B2)
Your Google Sheet now has the ability to change the type of barcode on the fly!
Yes! Here’s a link to the barcode image Google Sheet used in this example. Feel free to make a copy and play around with it yourself, or use our blank copy with test data.
You can generate and print barcodes using the Orca Scan web app.
We’re always happy to help, chat with us live or drop us an email.