How to use
- In your spreadsheet, copy the column with the values you want as barcodes and paste it into the input box. You can copy several columns (for example product name and barcode) together. You can also drop a CSV or TXT file; CSV files saved as EUC-KR by Korean Excel are read correctly too.
- If the first row is a header, “First row is a header” turns on. It is guessed as a header when, in some column, the first row is text while every other row is only digits; change it if the guess is wrong.
- Pick the value column (required), the file name column (optional; the value is used otherwise) and the caption column (optional text shown below the code).
- Choose the barcode type and style. The preview table shows the check result for every row straight away.
- Choose ZIP (one PNG at 300 dpi or SVG per row) or PDF sheet (A4 grid) and generate. The limit is 5,000 rows at a time, with a progress bar and a cancel button.
Choosing a type
| Use | Type | Value |
|---|---|---|
| Retail products (worldwide) | EAN-13 | 12 digits (check digit added) or 13 digits |
| Small packs | EAN-8 | 7 or 8 digits |
| US & Canada retail | UPC-A | 11 or 12 digits |
| Shipping cartons | ITF-14 | 13 or 14 digits |
| Expiry, batch and other logistics data | GS1-128 | AIs in parentheses, such as (01)09501101530003(10)A1 |
| Internal IDs, general use | Code 128 | Letters, digits, symbols (ASCII); no Korean |
| Industrial | Code 39 | Uppercase, digits, space and - . $ / + %; lowercase is converted to uppercase |
| URLs and text | QR | Any string, including non-English text |
| Small parts, ID documents | Data Matrix, PDF417 | Any string |
Check digits and invalid rows
For EAN-13, EAN-8, UPC-A and ITF-14 the last digit is a check digit. With “Add check digit automatically” on, a value missing its check digit (12 digits for EAN-13, for example) gets one calculated: 950110153000 becomes 9501101530003 and 880123456789 becomes 8801234567893. If a value already has 13 digits but the last one is wrong, you get the fix, such as “last digit 4, expected 3 (9501101530003)”. With the option off, only values that include the check digit are accepted.
Bad rows are never dropped silently. The preview table shows the reason in red, the number of bad rows is displayed, and “Download error rows (CSV)” gives you the row number, value and reason to fix in your spreadsheet. Bad rows are not generated; the rest are. Rows that the barcode library rejects during generation (for example, a QR value that is too long) are listed after the run as well. Validation cannot tell whether a number is a registered product number; numbers for products you sell must be licensed from a GS1 member organisation. To check a check digit on its own, use the GTIN Check Digit Calculator.
Output and printing
- ZIP: one image per row. Characters not allowed in file names (
/ \ : * ? " < > |) are removed, and clashing names get a number, as incode.pngandcode-2.png. Module size is the bar width in mm for 1D codes (the default 0.33 mm is 4 px at 300 dpi) and the cell size in px for 2D codes. - PDF sheet: codes are laid out on an A4 grid with the caption under each one. Fit the cells to a layout from A4 Label Sheet Printer, or set the cell size, margin and gap yourself and the columns and rows are worked out for you. For example 50×30 mm cells with a 10 mm margin and a 2 mm gap give 3 columns by 8 rows, 24 per sheet, so 100 codes need 5 sheets. The PDF is built at true millimetre sizes, so print it at actual size (100%).
- When a caption column is set, that text replaces the digits printed by the barcode itself. In SVG the caption applies only to 1D barcodes with plain ASCII text, so use PNG or PDF for non-English captions.
To make and style a single barcode, use the Barcode Generator; for a single QR code, the QR Code Generator.
Your list and files are processed in your browser only and are never sent to a server.