I need to do inventory tracking next month and I have my product list ready in a spreadsheet with all the numeric codes. The problem is I want to make the process faster by adding a barcode column that I can scan instead of manually entering each number. Right now I’m using Excel but I might switch to Google Sheets or use my tablet for this task. Has anyone figured out how to generate barcodes directly in spreadsheets? I’m looking for something that will create actual scannable barcodes from my existing product numbers. Any suggestions would be really helpful since manually typing hundreds of codes takes forever.
For Google Sheets specifically, I recommend using the built-in barcode function which works well across devices. You can create a formula like =SPARKLINE(A1,{"charttype","bar"}) but for proper barcodes, try using Google’s barcode API through a custom function. What worked for me was creating a helper column with =IMAGE("https://chart.googleapis.com/chart?chs=200x50&cht=qr&chl="&A1) for QR codes, or finding barcode generator add-ons in the Google Workspace Marketplace. The advantage is these solutions sync across all your devices automatically, so your tablet will display the same barcodes without font installation headaches. Just make sure your scanner app can read the barcode format you choose.
Actually ran into this exact situation about six months ago when doing warehouse inventory. Excel has some decent barcode add-ins you can download from their store, but honestly the mobile experience was pretty frustrating. What ended up working better for me was using a dedicated inventory app that could import my spreadsheet data and generate the barcodes automatically. Apps like Sortly or inFlow let you upload your product list and create scannable codes without messing around with fonts or formulas. The scanning worked much more reliably than trying to get my phone camera to read barcodes generated in spreadsheets. If you absolutely need to stick with spreadsheets though, test your barcode generation thoroughly before committing to hundreds of products because not all scanner apps read spreadsheet-generated codes consistently.
i totally get u! using barcode fonts is a quick fix. just grab code128 or code39 online, install the font, and change the text in your product column. it’s doable in both excel and sheets, but mobile can be a lil tricky for font installs.
The formula route gives you an image, so the column height has to be big enough or the code gets squished and scanners choke on it. If you go the font route instead, remember the font alone won’t add the start/stop characters, so the value in the cell needs wrapping or the code won’t read. Also worth printing one sample and scanning it with your tablet before doing the whole list.