Print Barcode Labels Using ONLY Google Sheets

Thank you so much for the detailed video

Apparently, the barcode website now makes you enter a new code every two months in order to use this system with the sheet he shared. You will not be able to do this until you enter your code. It is FREE, but you have to remember to do it.

What label template did you use?

Nice work, thanks for showing the steps and including the link to the demo sheet. My Mother-in-law just asked for help with labels she needs for a small church library and I had done this before with Excel/Word mail merge but I like your way and will try it myself next time.

The Method Shared here was very effective, however now the URL for onbarcode has been changed this is kinda redundant right now. please share update

what a load of pfaffing but thanks for sharing

Great video - I have a Square Shop and I need to figure out a way to create barcodes using my SKU that is different on each item. I can export my list to a spreadsheet but doh't know how to print to labels. Can you help me? Thank you so much. I can upgrade to Square Plus and they have a barcode app but it would cost me $60/MO - eeeeeeek:O(

science and barcodes!

This has been extremely helpful! Been using this for almost 2 years. Unfortunately, my spreadsheet has the same issue that yours has now, I only get an image for the barcode that says "invalid barcode settings" any idea how that might be resolved? I've tried reverse engineering your method from their website, but can't get it to work right.

sadley no longer relevant as online companies have stopped people from doing this, so you shou;d update this info

Since Onbarcode added a necessary "2 month activation code" for their online barcode generation to work, your method no longer works reliably.

I thought I had it working with the free activation code changing every two months, but with their new activation code, I don't know if the activation code changes based on the device used on or what, but OnBarcode's free online barcode generation is now proving totally UNRELIABLE for generating the barcodes in the spreadsheet!!!

It works flawlessl one day, then next day on same computer, only half the barcodes generate correctly, but it always seems to change so every day or two I have to modify the cell contents to get the barcodes to generate correctly for a couple hours!!!

Hey I figured out how to fix the stupid code activation thing the barcode generator added.

1) go to their you tube copy and paste to activate. It then allows you to edit the generator.
2) right click the image of the generated barcode and click open in new tab
3) go to the new tab copy the url
4) go to your google sheet you have been using and highlight the section of the old url and paste in the new one
5) in the url you just added go to the section that says “.aspx?TYPE=4&DATA=“ after the = erase 1234567 that was the place holder sku they had from the image and replace it with “&C2&” (make sure to include the “” around that formula.
5) hit enter and verify it correctly pulled the sku you had in C2. If it’s right just click and drag the cell down and problem solved.

It seems we will have to follow these steps every 2 months as they change their dumb activation code but it still works.

They set a License code on the service you are reviewing. Can you fix it?

I have used this for a while and for some reason it is not working now. Is this a glitch? I am stressing out because this has never happened before.

I'm pretty sure I'm using the same barcode generating site for my code 128 barcodes and you don't need any added line to show the characters in the barcode because the website does provide the option to include characters in the barcode inserted into the image underneath the barcode itself.

I loaded your sample sheet and to make the image include the characters contained in the barcode below the barcode itself is very simple!

Look at your formula sending the data to the website and the only change needed to get the characters to display below the barcode itself is in the formula you used, where the formula says "SHOW-TEXT=false" simply change that "false" to "true" and the website will then generate the barcode and include the characters contained in the barcode in text underneath the barcode.

Hi I just want to ask how did you connect the scanner on your google sheet? Thank you

Thank You!

im really lost when you try to copy and paste the barcodes and conctanate the rows to print. : l

Sorry to be so late to the game. Is there a way to eliminate the asterisks around the text? This is a great help. Thanks!

Great tutorial for Print Barcode Labels Using ONLY Google Sheets, simple and clear.

Thank you so much!!!

Today the generator broke, do you know how to get back to the free code generator?

ANDREW BENNET YOU BLOODY RIPPERRRRR THIS IS PERFECT <3 🥰

Can I pay you to help me transfer my barcodes to Google sheet.

How would I make the code show up under the barcode? Also amazing video! Thank you!

What scanner are you using?

Thanks, This was very helpful. Got my Amazon UPC labels ready.

Very useful, thanx

This is GENIUS!! Thank you so much!

i love this tutorial, im trying to get it to work for a thermal label printer instead of those multi label sheets, which i could do with your method, but instead of 30 with some manual labor of cut and copy, i have 1,801 different barcodes i need to print and im afraid that may be a little too much time, are there any work arounds for this?

Hey, thank you for the video! Very informative. I've managed to follow all your steps successfully, however the one difference is i'm printing barcodes to place onto product packaging. I have a thermal label printer, which i've purchased 1x2inch labels for. Is there any way you would be able to show us how to print 1 barcode at a time for the designed quantity, with a thermal label printer? Thank you!

hello. I would like to ask if there is a way to use the same method as when i try to do it, it gives me nothing as there is a dash in the information im trying to enter such as GW R4 - 02 - B

Extremely helpful video. Thank you so much Andrew Benett.

Thank you very much! This video and template helps me a lot.

how do you get barcode in google sheets?

Thanks for sharing

Thanks for this video, it works great,but i have a problem, if i decide to make a barcode with a jumpline,how can i do that?for example in your data i need a make barcode with student name and student number,how can i do that?.Can someone help for this problem?

Such a help! So easy even I understood it. Many less tears were shed. Thank you!

Any idea how to do something like this in Excel?

Absolutely genius. Thanks!

Hi and thank you!!!! I have a question, if I am just doing barcodes no text can I format one sheet to the sizes needed rather that starting a new page and formatting to transfer data too? Will it work the same? Thanks soooo much!

Is there a way to make the barcodes not blurry? Thank you!!!

you sir are a gentleman and a scholar. Thankyou!

This is awesome! I used it for a store where we use Square. I can now create my own barcodes in Google Sheets & scan them (UPC-A format) into Square with a barcode scanner & ring up sales into Square with the barcode scanner. I have looked everywhere on how to do this. Thank you so much....

Great!!!!!! this is amazing .... Can we do the same process on Microsoft Excel ?????? please let me know