How to Create Barcode in Excel

[@KevinStratvert]

Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

[@stephenMKonor]

This is really helpful

[@GiantParfait]

I don't need barcodes but I stumbled upon your videos and am delighted at how easily digestible everything is without annoying music or over the top zooming in or whatever. So I've been binging videos all night amd it's midnight now. 😂 Thank you so much.

[@mnmlst1]

OMG I'm doing your course at Udemy due to my work trained and can't believe you're at KZbin! You are such a great instructor!

[@PlannerKSH]

Thanks!

[@TheVirtualArena24]

Finally Kevin came back in his original form

[@noorSalem-oq3dv]

Nice

[@ziyadcomputer]

yes

[@RobinSingh-iy8wy]

I thoroughly enjoy your content. It’s incredibly informative and easy to understand and comprehend.

[@KeithMorrisonSr]

Thanks Kevin! Always great learning from you and your clear and perceptive delivery! I am trying to create DYNAMIC QR codes without having to be extorted by the QR code companies. Do you have a tutorial on how to do that? I really appreciate it!

[@pjohn1435]

Once again Kevin, you've done it, this will be helpful soon for our small business. Thanks again, Kevin. Keep up the wonderful work.

[@KevinStratvert]

Glad it was helpful!

[@roaringlegend456]

If you ever plan to expand your business or plan to sell your products in other stores, you might want to read on how Upc barcode numbers are asigned so you don't run into issues in the future

[@FritzieAdecer]

Kevin, you saved my day with this tutorial! Thank you and more power to you :)

[@jcj6892]

I would love a follow up video showing how to use the barcodes after they’ve been generated. Specifically, a fun idea I had was to generate a QR code for a yard sale sign with a date and time… silly, I know lol. But the end user needs a way to retrieve the information. You can type in a physical address that can be opened up in your favorite maps app, but it won’t include additional information like the nature of the event. Does this have to connect to a paid service or URL with the info? Or could you have your own mini home server or database that you could use for keeping track of what you’ve stored in boxes etc? There are a lot of cool possibilities.

[@keithM7]

What a good and educational video, but do I need an Office key to better optimize my Excel?

[@MarkUSAfreedom]

It's the best you can do but better performance

[@keithM7]

and where can I find it where it is safe and effective

[@MarkUSAfreedom]

You can check several places but I got it from BNH Software if you want something specific

[@keithM7]

I know there are several but I wanted to know about one in particular to start with. Thanks.

[@Saintor1]

Great and easy solution in Excel. I tried on MS Access reports but didn't find a way to make it work yet. Hopefully it works there too!

[@alphajorbarrie2535]

Please sir, answer this question: Is it still worth it to learn web development (HTML, CSS, and JavaScript) in this age of AI, or what would be your advice to someone who wants to make a career in the tech industry?

[@randyriegel8553]

I would not use AI until you learn the language yourself. You won't learn anything and most likely the AI code will not work as expected. I've been a software engineer for 20 years. AI is a nice tool if you already know the language to get a baseline. I had an C# application when ChatGPT came out and one method had really intensive calculations. So I had ChatGPT spit out the code of that method. It worked. Put both on a benchmark and my manually written code was faster and used less memory than the AI generated. If you don't know coding and depend on AI you will get bit in the ass.

[@renees766]

This is fantastic information, and you did an outstanding job teaching it!

[@gbasingapore]

Thanks. You saved my life.

[@krisztianmihovici8598]

I am actually mind blown ! Wow

[@jkontosgr]

Great video! Kevin congrats 🎉

[@octaviejuliet3278]

Top Top. Love it. Thanks for helping me.

[@drhoward81]

This tip saved me a lot of headaches. Thank you! Is there a way to print the barcode without the text underneath it? Do you have a video showing how to create a form in excel that can be printed as a label?

[@Dip_Digbijoy]

Thanks for updated us ❤

[@noelfrancisco5778]

Great tool, I learned something new today. Thanks :)

[@AtractivoPhotography]

Outstanding video, Kevin!

[@nareshbabukaparouthu5091]

OMG -> Its amazing and very easy, best video. thanks for sharing :)

[@UmairNazeer-w2l]

THANK YOU SO MUCH THIS VIDEO IS SO MUCH HELPFUL FOR ME TO SOLVE OUR SOLUTION AND PROBLEMS

[@DigitalMindQuest]

Hey man, I've really been enjoying your tutorials! They're clear, concise, and very helpful. I was wondering if you might consider creating a video on how to extract data from complex PDFs. I know you already have some videos on PDF data extraction, but if you're comfortable tackling a more intricate example, I think it would be fantastic to see your process in action.

[@abrahamjbah]

Miss your videos, I look at them even if am not interested in what you are teaching 😂.

[@djmojolosangeles]

Awesome video Kevin, thank you!

[@tube-master]

Interesting, not easy but a great function to be used in many situations 👌

[@fc8349-s7m]

Thanks Kevin for this tutorial, very helpful. Quick question, how can I get a UPC code?

[@Error404PageNottFound]

Legend thanks for this :D

[@newlightning2306]

Hi Kevin, thank you 🙏🏿 so much for this tutorial. May I ask, can this technique be adapted for use with Google sheets? Thanks in advance.

[@Zerosandones-dy7lb]

Hi Kevin I love to learn from you,thank you. Can you make a tutorial on creating a payroll with some skills and shortcuts,and how to pay staff?

[@nkechiizeji]

Nice one. What of barcoding in Microsoft word and PowerPoint?

[@derekduckitt5900]

A lot of good tips here, many thanks!

[@KevinStratvert]

Glad you enjoyed it!

[@JuJackMarketingCompany]

I needed to learn this. THANK YOU!!

[@KevinStratvert]

Glad it was helpful!

[@bashirwarraich1107]

Excellent and easy to learn

[@amilaimesh]

Great stuff, Kevin

[@tinab9572]

Thank you Kevin, another great learning video 😅 as you mention it could be great, if you could make a video that can show how your Kevin Cookies company make a store with an inventory of your cookies and scan each products Barcode and count down the selling items from your store inventory . Thank you :-) :-)

[@Sean_Yemen]

Hi @Kev Awsum presentation and in appreciation. For inventory management, of (for example) your data set, how would I go about it to link the bar code to a mobile device which will track the items counted, brought into stock or taken out of stock (sold)? Thank you in advance and I do enjoy your teachings. Blessings

[@ranbirjaiswal]

Awesome kevin

[@sayedajmalsadat]

Cool feature, thanks Kevin for the video.

[@KevinStratvert]

Any time!

[@raghavendrasarma6993]

WOW! Amazing ..

[@djmillen2010]

Would you be able to append a quantity to the code as well? For instance, you have an order for 5 cookies and type that in a quantity column, so when you create a barcode for the cookies, it would automatically scan that you need to charge for 5 cookies?

[@agouveia19]

Hi! Thank you for all the video's, they help a lot! I downloaded your workbook and did the exact steps you did, but in the colum of the barcode I get the message 'blocked'.. do you know why I''m getting this error code? I can't figure it out..

[@nawoyskifamily8875]

I am receiving the same message.

[@MuhsinTechnicalengineeringserv]

Your The best ever Non comparable

[@grantholmes1535]

Kevin, I got this to work, but need to print these on labels. When I try to do a merge to print pricing labels the image will not come over. Is there a way to do that?

[@feidie64]

Love it! Thanks!

[@sliccslacc]

Hey guys, and thanks for the video buddy. Since i haven't got the newest excel version and can't use api's at my office pc, i did it another way. wit a vba scribt and the font code128. pretty neat actually. so you're not dependent on the api. you can also do this as a excel formula. if any of you are interested, you can tell me

[@Osmanmaani4]

Thanks

[@technousr]

Kevin when using the api, does the UPC have to be a valid code for it to work or will it generate any code you give it? In addition, will it also provide any names of the associated products if they need to be pre-existing UPC codes?

[@KevinStratvert]

There are certain rules for barcode types (eg upc needs to be 12 digits long and include a check digit at the end). If you specify upc but provide more digits, you’ll get an error. There’s no lookup function for existing products.

[@UmarAlFarooq]

Wow! Great tip Kevin! Thank you!

[@hakeae]

Hi Kevin, just what I was after .... but I would liek to improve a little: the readable text under the barcode is the barcode type and the value but concatenated eg "code39value". Don't really need to see the barcode type, or at least have space between between tthem. Can you tlel me how to do that please? Thanks :) .

[@AO_theMAN]

Hey Kevin, what version of Excel did you use in this video and in all your videos?

[@asnyaka]

Awesome Kevin!

[@ChiraqVet]

So how exactly do you incorporate this with an inventory. Im new to all this an trying to learn to make a new inventory system for my job. Im wanting something where i can make a barcode an attack individual barcodes to our supplies and keep up with what we use by scanning the code as we get items from supply. Does that makes any sense..

[@thomasollie1712]

I need a QR for a series of numbers row. How to do?

[@asquithia]

Great thanks

[@KevinStratvert]

No worries!

[@Ngapak_Dewek]

thanks mister

[@Milkex]

Came for the Cuisinart break maker review, stayed for the Excel barcode generation guide

[@WMhermansen]

First off. Wow saved tons of time. But came back to the spreadsheet to add more UPC numbers. Now the image generating is in a different format than original UPC-a in the formula/api line. Everything remains the same in the formula cell except the cell address. Any ideas?

[@ayufan3]

Nice.....👍👍👍

[@frankierogers9109]

Hello Kevin, I want to start a barcode inventory control system for my small part time business. Could you tell me the best way to achieve this possibly with a 365 subscription?

[@wensex2008]

Thank you

[@solostarmlan]

Kelvin here again

[@DIYWITHVKAY]

Does this work for google sheets?

[@MikeRoxly]

will this work with shopify?

[@ArifAhmed-ve9fq]

Hello Kevin. Thank you for your tricks but I do not have IMAGE on the Dialogue box, how to bring it, please advice

[@gayansamarasekara]

Splendid...!

[@user-te2qg7tw7d]

Kevinがカッコよくなってる

[@rcsontag]

Instead of the barcode, Excel posts the word "Blocked" in the cells. What's going on?

[@ninalara661]

same :/

[@nargishamidi3610]

How do you write upc can you answer me please?

[@Salah_-_Uddin]

I will do it.

[@NewChapterMan]

Is there an app which will be able to decipher barcodes?

[@sphericon]

I love QR code

[@kebbitechzone9835]

Nice boss

[@Toyly-w6f]

Hi Kevin. When I write January 2023 in a cell like in your and when I hover down. Months are changed but in my case years are changed

[@Ringo_Lin]

That's so great!

[@Windows10haroun]

upload a video about how to program in JS

[@BillyAbuakuEstebanTV]

Awesome

[@arlenysceballo]

Love it!

[@alaaldinalqaisi8801]

How to scan these QR codes for taking an event attendance on a google sheet?

[@smarthelpguides]

you can direct them to a form to submit their name or less reliable method will be to check no of visits to the qr code url.

[@afwak.we.redak7]

@@smarthelpguides B

[@eddahafsta874]

I guess I didn't understand. Now that I have made those barcodes, I want to stick them on my moving boxes, and type into my excel table what I place in each box. I can't figure out how I then scan the barcode (I want to do that with my phone)

[@natozeleo7579]

Hai Kevin ...I need demo on geocode

[@JahangirAlam-mi1fv]

how can i print these barcode?

[@BasBruijnis]

Hi, is it possible to set the size also?

[@KevinStratvert]

Yes! Simply adjust the cell size and that’ll in turn affect the barcode size.

[@KJ-zr2ko]

Where do you get the URL from if I'm putting in a ISBN number?

[@aaravsingh8216]

cant see image option

[@szabozsombor3454]

I dont have Image suffix

[@amkotler]

I clicked the URL in the description and I got an error page.

[@Eternal_Tech]

In order for the URL API to function, it needs to have the barcode number appended to it in the manner Kevin demonstrates in the video.

[@ucan1]

If this video goes viral, my comment is gonna go viral

[@senuramarasinghe]

But this video has 122k views and your comment only has 24😂

[@hersheyrulz2]

Kevin, while I do understand that you and others are visual only people, there are many people who do need something like alternative text (alt text) so it would be great if you hadn’t just glazed over that field as being optional without even calling it out. You have a platform here that could help those learning how to do these tasks to be more mindful of others needs. I’m not saying you have to do a lesson on alt text, but it would’ve been great if you had at least acknowledged its existence.

[@KevinStratvert]

Fair point! Thanks for calling that out!

[@alexorozco453]

hello no image

[@noorSalem-oq3dv]

Create Barcode in Free like Subscribes 👍 thank you

[@geocastellano2927]

I can’t scan the barcode.

[@ziyadcomputer]

give me a video of how to use Google vids🙏

[@Mx81]

I would not use „free“ online tool … you never know what they are doing with that data.

[@Eternal_Tech]

What data does the barcode site actually obtain? It seems like they would certainly get the code (numbers) and they would know your IP address. However, unless they gain access to the spreadsheet itself, it does not seem like a security or privacy risk.

[@SS-zl3go]

fails to connect

[@Java-ky9yg]

Yeah… but how to download it to you computer?

[@6Mourning6Star6]

Nifty

[@Kingoffreefire380]

Hi

[@WaqasAli-dq9wg]

Would it generate the barcode for 4131 active inventory number?? Happy barcoding 😁

[@KevinStratvert]

Give it a shot 😉