01
Google Sheets Barcode Generator method
Put the shown uppercase value in the source cell, paste the formula into another cell, and apply Libre Barcode 39 to the output cell. Keep a separate human-readable code column.
InventoryFREE · NO SIGNUP
Google Sheets Barcode Generator
Validate an internal Code 39 value and get a copy-ready Google Sheets formula. Preview the barcode locally, then apply the Libre Barcode 39 font to the formula cell in Sheets.
FREE TO USEA LOOK ATLAS TOOL
01 USE IT NOW02 NO ACCOUNT03 FIELD NOTES BELOW
WORKING INPUTS
Prepare the supplied value.
LIVE RESULT
Sheets cell formula
="*"&UPPER(A2)&"*"Apply Libre Barcode 39 to the formula output cell in Google Sheets.NORMALIZED SOURCE VALUELA-JKT-001
ENCODED TEXT*LA-JKT-001*
REQUIRED FONTLibre Barcode 39 (basic, not Extended)
OPTIONAL CHECK CHARACTERNot added; scanner must accept basic Code 39
LOCAL BARCODE PREVIEW · CODE39
Keep quiet zones and aspect ratio. Test the final printed label with your scanner.
14
THE CODE LIVES IN THE SHEET
Make the formula and its font work together
The formula creates Code 39 text. The barcode font draws the bars. Plain text, a different font or missing start/stop markers can turn a useful label into an unreadable one.
WORKING VIEW
CODE 39 FORMULAA2 CONTAINS LA-JKT-001
METHODAdd Code 39 start/stop markers around the uppercase cell value
WORKING NOTE="*"&UPPER(A2)&"*" produces *LA-JKT-001*; apply Libre Barcode 39 to the output cell.
INPUTS → CLEAR OUTPUT
THE FIELD NOTES
Quick answer above. Better decisions below.
Use the result now, then read the practical notes for assumptions, examples, limitations, and the choices behind it.
A2 CONTAINS LA-JKT-001CODE 39 FORMULA
="*"&UPPER(A2)&"*" produces *LA-JKT-001*; apply Libre Barcode 39 to the output cell.
02
Keep the inputs consistent
This supports the basic Code 39 alphabet and adds the required asterisk start/stop markers. The supplied value cannot contain an asterisk. It does not calculate a Mod43 check character; use a scanner configured for basic Code 39 without that optional check.
03
Use the result in your workflow
Keep the useful output beside the source values so another person can check the same scenario.
04
Know the limits of this tool
The local preview uses JsBarcode. The spreadsheet requires its own font and print settings, so test the final printed sheet with the scanner you will actually use. No code is sent to a barcode image service.
THE PRODUCT IS NEXT
Turn the product into the campaign.
Use Look Atlas to transform one straightforward product photo into premium on-model ecommerce imagery for your store, ads, and social channels.TRY YOUR FIRST SHOOT FREENO CREDIT CARD REQUIRED
Google Sheets Barcode Generator method
Put the shown uppercase value in the source cell, paste the formula into another cell, and apply Libre Barcode 39 to the output cell. Keep a separate human-readable code column.
Keep the inputs consistent
This supports the basic Code 39 alphabet and adds the required asterisk start/stop markers. The supplied value cannot contain an asterisk. It does not calculate a Mod43 check character; use a scanner configured for basic Code 39 without that optional check.
Use the result in your workflow
Keep the useful output beside the source values so another person can check the same scenario.
Use the sku generator first if the sheet does not yet have stable internal codes. Keep purchasing records organized with the google sheets purchase order generator, then put barcode formulas beside those codes.
Know the limits of this tool
The local preview uses JsBarcode. The spreadsheet requires its own font and print settings, so test the final printed sheet with the scanner you will actually use. No code is sent to a barcode image service.
Questions, answered.
How does the google sheets barcode generator work?
Put the shown uppercase value in the source cell, paste the formula into another cell, and apply Libre Barcode 39 to the output cell. Keep a separate human-readable code column.
What should I check before using the result?
This supports the basic Code 39 alphabet and adds the required asterisk start/stop markers. The supplied value cannot contain an asterisk. It does not calculate a Mod43 check character; use a scanner configured for basic Code 39 without that optional check.
What does this tool leave out?
The local preview uses JsBarcode. The spreadsheet requires its own font and print settings, so test the final printed sheet with the scanner you will actually use. No code is sent to a barcode image service.
BUILT BY LOOK ATLAS
Your product deserves more than a marketplace thumbnail.
Turn a simple product photo into polished, campaign-ready creative for your store, ads, and social channels. No studio. No reshoots.
Create your first shoot free, then keep going when you’re ready.
01 PRODUCT PHOTO → CAMPAIGN