Close Icon
Get the Orca scan app QR code

Scan the QR code to download the mobile app

How to generate barcodes in Google Sheets

How to generate barcodes in Google Sheets to your Orca sheet
How to generate barcodes in Google Sheets to your Orca sheet

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.

  1. Create a new Google Sheet
  2. Create a column named Barcode Value
  3. Enter the barcode values you wish to encode as an image
  4. Create a column named Barcode Image
    Create a column named ‘Barcode Image’
    Create a column named ‘Barcode Image’
  5. Add =IMAGE(CONCAT("https://barcode.orcascan.com/?data=", B2)) to the Barcode Image column
    Add the formula to the ‘Barcode Image’ column
    Add the formula to the ‘Barcode Image’ column
  6. Copy the formula by selecting the cell and dragging the bottom right corner
    Copy the formula to all cells in the ‘Barcode image’ column
    Copy the formula to all cells in the ‘Barcode image’ column
  7. Resize your cells to make the barcode images visible

That’s it! You’re now able to generate barcode images in Google Sheets.

How do I change the barcode type?

The Orca Scan barcode image API supports 12 different types of barcodes. Use the following steps to create different types of barcode images:

  1. Replace the Barcode Image formula with =IMAGE(CONCAT("https://barcode.orcascan.com/?type=code128&data=", B2))
  2. Replace code128 in the above formula with your desired type
  3. Copy the formula by selecting the cell and dragging the bottom right corner

That’s it! You can now generate 12 different types of barcodes in your Google Sheet.

How can I generate multiple barcode types at the same time?

  1. Create a new column named Barcode Type
    Create a column named ‘Barcode Type’
    Create a column named ‘Barcode Type’
  2. Enter the barcode type for each row
    Enter the barcode type for each row
    Enter the barcode type for each row
  3. Change the Barcode Image formula to =IMAGE("https://barcode.orcascan.com/?type="&C2&"&data="&B2)
    Change the Barcode image formula
    Change the Barcode image formula
  4. Copy the formula by selecting the cell and dragging the bottom right corner
    Copy the formula to all cells in the ‘Barcode image’ column
    Copy the formula to all cells in the ‘Barcode image’ column

Your Google Sheet now has the ability to change the type of barcode on the fly!

Do you have an example Google Sheet I can use?

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.

Click ‘Make a copy’ to use our template
Click ‘Make a copy’ to use our template

How can I generate and print barcodes?

You can generate and print barcodes using the Orca Scan web app.


Questions about generating barcodes?

We’re always happy to help, chat with us live or drop us an email.

Ready to start scanning?