X
This article was co-authored by wikiHow staff writer, Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher.
This article has been viewed 591,918 times.
Learn more...
This wikiHow teaches you how to create a barcode for use on a product. After signing up for a GS1 prefix for your barcodes, you can create UPC or EAN barcodes one at a time by using an online generator, or you can create a printable list of CODE128 barcodes using Microsoft Excel and Microsoft Word.
Steps
Method 1
Method 1 of 3:
Preparing to Create
-
1Understand how barcodes work. A barcode contains two sets of numbers—a global prefix that identifies your business, and a product serial number—that allows you to bring up a product's information by scanning the code.
- If your products don't have individual serial numbers yet, you'll need to set up a product list in your preferred point of sale program before you can create relevant barcodes.
-
2Register your business with GS1. GS1 is a not-for-profit company that maintains the global standards for barcodes. After registering your company with GS1, you will receive a "prefix" set of numbers that you can use to refer to your company at the beginning of each barcode.
- To register with GS1, go to the GS1 U.S. page, read the guide, click Fill out GS1 Company Prefix Application, and follow the instructions.
Advertisement -
3Determine the type of barcode you need. Most businesses will use either UPC (North America, U.K., New Zealand, and Australia) or EAN (parts of Europe, Asia, Africa, and Latin America) barcodes.[1]
- There are other types of barcodes (e.g., CODE39 and CODE128) as well.
- Different versions of barcodes support varying lengths of product numbers. For example, EAN-8 barcodes support up to 8 numbers to identify your business and a product, while EAN-13 codes support up to 13.
-
4Make sure that you have an inventory list on-hand. Before you create a product's barcode, you'll need to know the number that you use to identify that product in your business' point of sale program. It can be a hassle to dig up this information for each product individually, so have your product information sheet available if possible.
Advertisement
Method 2
Method 2 of 3:
Using an Online Generator
-
1Open the TEC-IT site. Go to https://barcode.tec-it.com/en in your browser. The TEC-IT site has a free barcode generator here.
-
2Select EAN / UPC. On the left side of the page, you'll see a list of barcode types. Scroll down until you see the EAN / UPC heading, then click it to expand it.
- Your mouse cursor must be over the list of barcode categories when you scroll.
- If you want to create a different type of barcode, click that type of barcode instead.
-
3Select a barcode variation. Click one of the barcode options below the EAN / UPC heading.
- For example: to create a 13-digit EAN code, you'd click EAN-13 here.
-
4Delete the "Data" sample text. In the large text box to the right of the list of barcode categories, delete the text that appears after selecting a barcode type.
-
5Enter your company's prefix. Type the prefix given to you by GS1 into the "Data" text box.
-
6Enter your product number. In the same box as the prefix, type in the number that you use for your product.
- There shouldn't be a space between the prefix and the product number.
-
7Click Refresh. This link is below the bottom-right corner of the "Data" text box. Doing so will update the barcode preview on the right side of the page with your prefix and product number.
- If you see an error in the barcode preview box, try re-entering your barcode or selecting a different barcode format.
-
8Click Download. It's on the right side of the page. The barcode will download into your computer's default "Downloads" location; once it finishes downloading, you'll be able to print it out and place it on the appropriate product.
Advertisement
Method 3
Method 3 of 3:
Using Microsoft Office
-
1Understand the limitations. You can create a CODE128 barcode in Microsoft Office, but you cannot create UPC or EAN codes. This shouldn't be a problem if you have the ability to scan CODE128 barcodes, but if you're reliant on UPC or EAN scanners, use an online generator instead.
-
2Create a new Microsoft Excel document. Open Microsoft Excel, then click Blank workbook.
- On a Mac, just open Excel to create a new document.
-
3Enter your barcode's information. Enter the following information in the following cells:[2]
- A1 - Type in Type
- B1 - Type in Label
- C1 - Type in Barcode
- A2 - Type in CODE128
- B2 - Type in the barcode's prefix and product number.
- C2 - Re-enter the barcode's prefix and product number.
-
4Save the document on your desktop. To do so:
- Windows - Click File, click Save As, double-click This PC, click Desktop on the left side of the window, type barcode into the "File name" text box, and click Save, then close Excel.
- Mac - Click File, click Save As..., type barcode into the "Save As" field, click the "Where" box and click Desktop, and click Save, then close Excel.
-
5Create a new Microsoft Word document. Open Microsoft Word, then click Blank document in the upper-left side of the window.
- On a Mac, just open Microsoft Word to create the document.
-
6Click the Mailings tab. It's at the top of the Word window. A toolbar will appear near the top of the window.
-
7Click Labels. You'll find this option on the far-left side of the Mailings toolbar.
-
8Select a type of label. Click the box beneath the "Label" heading in the lower-right side of the box, then do the following:
- Click the "Label vendors" drop-down box.
- Scroll to and click Avery US Letter
- Scroll to and click the 5161 Address Labels option in the "Product number" section.
- Click OK
-
9Click New Document. It's at the bottom of the Labels window. You should see a new document with boxes outlined in it appear.
-
10Click the Mailings tab. This will re-open the Mailings toolbar in your new document.
-
11Click Select Recipients. It's in the upper-left side of the window. A drop-down menu will appear.
-
12Click Use an Existing List…. This option is in the Select Recipients drop-down menu.
-
13Select your Excel document. Click Desktop on the left side of the pop-up window, click the Barcode Excel document, click Open, and then click OK when prompted.
-
14Click Insert Merge Field. It's in the "Write & Insert Fields" section of the Mailings tab. A drop-down menu will appear.
-
15Click Type. This is in the Insert Merge Field drop-down menu. Doing so will insert a line of text that says { MERGEFIELD Type } in the top-left cell of the document.
- If clicking Type inserts a line of text that says <<Type>> instead, don't worry—you'll have a chance to fix it in a minute.
-
16Insert the other two types of field. Click Insert Merge Field again, click Label, and repeat for the final option in the drop-down menu (Barcode). You should see the following:
- { MERGEFIELD Type }{ MERGEFIELD Label }{ MERGEFIELD Barcode }
- If you see <<Type>><<Label>><<Barcode>> here instead, select the text, right-click it, and click Toggle Field Codes in the context menu that appears.
-
17Place a colon and a space between the "Type" and "Label" tags. The line of text should read { MERGEFIELD Type }: { MERGEFIELD Label } now.
-
18Place { MERGEFIELD Barcode } on its own line. Click the space directly before the left bracket, then press ↵ Enter.
-
19Replace the FIELD part of the "Barcode" tag. You'll select the "FIELD" part of { MERGEFIELD Barcode } and replace it with BARCODE.
- The updated tag should now say { MERGEBARCODE Barcode }
-
20Enter the barcode's name. Click the space directly to the left of the barcode tag's closing bracket, then type in CODE128 there.
- The updated tag should now say { MERGEBARCODE Barcode CODE128}
-
21Create the barcode. Click the Finish & Merge button in the toolbar, click Edit Individual Documents…, make sure that "All" is checked, and click OK.
-
22Save your barcode. To do so:
- Windows - Click File, click Save As, double-click This PC, click a save location on the left side of the window, type a name into the "File name" text box, and click Save.
- Mac - Click File, click Save As..., type a name into the "Save As" field, click the "Where" box and click a save location, and click Save.
Advertisement
Community Q&A
-
QuestionWhat costs are involved?Community AnswerApart from the cost of Excel and the cost of internet, creating barcodes is free.
-
QuestionIs the bar code for a single number always the same?Rohit SinhaCommunity AnswerYes. If the input is the same number, the corresponding bar code will be the same, as well.
-
QuestionCan I scan barcodes with a cell phone app?Rohit SinhaCommunity AnswerYes, most phones now have QR code and bar code scanner apps built-in. If you don't have one, you can easily download one from the Play Store or App Store.
Advertisement
References
About This Article
Advertisement