Let Us Fill Your Excel Spreadsheet With Barcodes
By:
Siva Katir
- 4/21/2014
<p>Today we are happy to announce the public availability of our Bulk Barcode Generator for Excel. It is an incredibly easy way to bulk insert barcodes encoded from the spreadsheet's data directly into a new spreadsheet. No messing about with fonts or macros.</p> <p>Find it here: <strong><a href="https://posguys.com/BarcodeBulk/Index">POSGuys.com Bulk Barcode Generator for Excel</a></strong></p> <p>Continue reading on a quick rundown of its features and abilities. </p> <h2>Setup your Spreadsheet</h2> <p>The first task is to prepare your data. For ease of use be sure that all of your columns have a header to identify the column. This will make selecting what data to encode much easier. Because columns tend to have headers in Excel the first line is skipped by the encoder and won't be barcoded.</p> <p>If your spreadsheet is password protected you will need to remove the password before upload.</p> <h3>Upload</h3> <p>The next step is to upload your spread sheet. After a quick check to make sure we can process it you will be forwarded to the next step. If the file can't be read for some reason you will be sent back to the first page and given a brief error message.</p> <h3>Select Data</h3> <p>If you have multiple sheets you will be first prompted to select which sheet, by number, you want to use the tool on.</p> <p>Next you'll be asked which column to encode along with which symbology to use, the height and width of the desired barcode images and if you want the original text to be displayed inside the barcode image.</p> <h3>Waiting...</h3> <p>After pressing submit in the previous step you may have to wait some time, depending on how much data you need encoded. If you have JavaScript enabled you'll see a waiting notification that will go away once processing is complete.</p> <h3>Done!</h3> <p>Once all of the barcode images have been generated and inserted you'll be given a link to download your new Excel file. This file will only have the sheet you selected previously in a new file that is specially formatted to properly display the barcode images. </p> <h2>Supported Symbologies</h2> <p>Currently this tool supports the following barcode formats:</p> <p>Aztec, CODABAR, <strong>Code 128</strong>, Code 39, Data Matrix, EAN 13, EAN 8, ITF, MSI, <strong>PDF 417</strong>, Plessey, <strong>QR Code</strong> and UPC A</p> <h2>Questions, Comments, Help?</h2> <p>If you have any issues please leave a comment below and we'll do our best to help out!</p> <p><br /> <strong>Brought to you by the POSGuys.com Operations Team</strong></p>
Share this post:
Recent Posts By Siva Katir
Using ASP.NET Custom Authorization Attribute to Hide Page Elements
Filtering for Bots
Let Us Fill Your Excel Spreadsheet With Barcodes
Easily Generate Barcodes using Microsoft Excel for Free
Introducing POSGuys Barcode API V.0.1
Please enable JavaScript to view the comments.