How to Generate BARCODES and QR CODES in Google Sheets for FREE

Рет қаралды 202

Күн бұрын

Welcome back to 'The 101 Library'! In this video, I'll show you how to easily generate barcodes and QR codes in Google Sheets using the IMAGE function and the free API from barcodeapi.org. Whether you need barcodes for inventory management or QR codes for quick links, this method is simple and cost-effective.
🔔 Subscribe for more Google Sheets tips and tutorials: / @the101library
👍 Like and Share this video if it helped you!
📌 Timestamps:
0:00 - Introduction
0:20 - Using the IMAGE Function with API
1:20 - Practical Examples and Applications
📌 Resources Mentioned:
Google Sheets: docs.google.co...
Barcodeapi.org: barcodeapi.org...
Example Formula for QR Code:/Barcode: =IMAGE("barcodeapi.org..."&{Data}") - Replace {Data} with your value.
📌 Related Playlist:
Essential Google Sheets Tips for Beginners | The 101 Library : • Google Sheets
Thanks for watching! If you found this video helpful, please give it a thumbs up, and don't forget to subscribe to 'The 101 Library' for more tech tutorials and tips. If you have any questions or suggestions for future videos, drop them in the comments below. See you next time!
#GoogleSheets #Barcodes #QRCodes #The101Library

Пікірлер: 5

@The101Library Ай бұрын

Thanks for watching! 🎉 If you found this video on generating barcodes and QR codes in Google Sheets helpful, don't forget to smash that 👍 button and subscribe to 'The 101 Library' for more awesome tech tutorials! 🚀 Got questions or video suggestions? Drop them in the comments below! 💬 Check out our other videos to boost your tech skills: 👉How to use Microsoft Lists: kzfaq.info/get/bejne/epqhrJRnur7Vpac.htmlsi=fIxrY4ilRb-rnawQ 👉 Essential Google Sheets Tips for Beginners: kzfaq.info/sun/PLIOBVXau5TJH-qQVngpfTUE6hS4LFwCpu Stay connected and subscribe to the101library for more updates and tips! 📱

@corynnecasten5515 25 күн бұрын

Can you do a video how to scale the codes so they don't print super tiny?

@corynnecasten5515 25 күн бұрын

Also I'm working with Square POS what is the best way to print this into labels?

@corynnecasten5515 25 күн бұрын

Thank you for this video. When I hit enter to generate the code mine has the word auto in front of the numbers.. what did I do wrong?

@The101Library 19 күн бұрын

Hello, sorry for the late reply. I am not sure why your barcode has "auto" in front. This is the formula I used (=IMAGE("barcodeapi.org/api/auto/"&A1 )). All you have to do is to replace "A1" with the cell that has your code value. Make sure that your code value is set as Text (refer to video for that). If all this does not work, try to replace auto with a specific barcode type from the barcode list. As for the size of the barcode and how to print them in labels, I suggest that you copy the generated barcode into a Google Doc or a Word document and past the code as a "Picture". Then, you can resize your code as needed and then print it as a label. I will try to make a video of that soon in the future. Hope this helps! Let me know how it goes.