Scientific notation in identifiers
Excel can display or store a long numeric identifier in scientific notation.
Use a text-formatted source column and compare the imported preview to the original identifier list.
barcode generator from Excel
Turn an Excel product list into barcode labels
BatchLabel reads the selected worksheet as a data source rather than asking you to copy values one at a time. You can inspect formatted text, map columns deliberately and catch missing values or invalid checksums before the workbook becomes a multi-page label export.
LOCAL TOOL
Turn an Excel product list into barcode labels
Choose a CSV or XLSX to continue in the full mapping workspace. Nothing is uploaded.
Drop your spreadsheet hereCSV or XLSX • 10-row trial without an account
No upload No sign-up to trySign in to save and continue
A practical workflow
How to use it
- 01
Prepare identifier columns
Format codes as text in Excel and save the workbook without macros.
- 02
Choose a worksheet
Upload the file, inspect detected sheets and confirm which row contains headers.
- 03
Map, validate and lay out
Connect spreadsheet columns to label fields, resolve row errors and export a test page.
Avoid rework
Common errors and precise fixes
Choosing the first sheet automatically
Workbooks often open on instructions or archived data rather than the active product table.
Review sheet names and the preview before confirming the mapping.
Know the limits
Password-protected, corrupt or unusually large workbooks are rejected.
Legacy .xls support is enabled only if the selected parser and its security tests cover it.
Questions, answered
Before you continue
Does BatchLabel evaluate Excel formulas?
No. Formulas and macros are not executed. Where a workbook provides a stored display value, the importer treats it as untrusted static data.
Will my Excel file be uploaded?
Not in the local browser-first version. Parsing, mapping and generation happen in the tab; saving or exporting creates data on your own device.