Print barcodes, data matrix codes, part numbers and more directly from Excel without using labels! Process optimisation in production: cost-effective barcode generation in Excel.

Many production companies, and in particular the medium-sized ones, still mark materials and components with the "classic" felt-tip pens and hand stamps, often ignoring that this is a major source of error. Manual marking never produces machine-readable codes either.

This is why process owners, production managers and QM managers often go looking for cost-effective solutions to produce barcodes or data matrix codes on site at the respective workstations. Two questions always come up:
• What system environment will be used to design the machine-readable imprints? Will it be used from a database?
• How can direct printing be done in the end?

The ideal solution:
• is "very simple" throughout,
• has a high degree of automation,
• can be used on any material,
• offers cost-effective printing, and
• ensures reliable label replacement!

Direct printing from Excel with the mobile identification devices

Combining REINER® marking devices with the common spreadsheet software Microsoft Excel is a good way to make barcode printing more efficient!

A free barcode generator is integrated into the device software on REINER® marking devices.

The diverse imprint range of jetStamp® products includes the option of printing freely-adjustable sequential numbers. Date, time or a count can be pre-set and sequentially integrated into the barcode. Combinations with text, figures, numbers or graphics, such as the company logo, are part of the basic functions as well. The desired print images can be designed, administrated and directly printed with the included "PCset graphic" software as desired. The REINER jetStamp® 1025 inkjet printer prints sequential numbers directly just as reliably as it completes any other marking task. The format can be as large as 85 x 25 mm!

What do you do if you need to combine more data? Can additional, further and/or different information be integrated into the data matrix code or the barcode in the scope of work processes, without missing traceability requirements?

A custom, extended programming function permits data transfer from Windows-based programs, e.g. as an Excel macro, an integrated Excel data form (Excel input mask) or an Excel add-in. Sequential lot or batch numbers can be included in 1D or 2D barcodes with their associated additional process data. Barcodes and QR codes are created equally easily in Excel.
Find some practical examples for the vast variety of process information that can be easily provided via a barcode generator or data matrix code generator in Excel below. The final transfer of the QR code from Excel to the mobile REINER® marking device is a breeze at the end. It's become just a simple print job.
Marking of date, time, counting function continuous, barcode

Barcode and data matrix code generator for code creation and data transfer to the mobile inkjet printer with an Excel add-in

Industrial production has many interfaces where certain data from the planning and production program are to be printed onto a product. The data may need to be re-imported to identify the component in the following production step, or the product may need to be clearly identifiable for traceability if any faults or complaints occur at a later time. Efficient processing requires machine-readable marking!

Excel barcodes: How can various pieces of information from an Excel table be integrated into a machine-readable 1D barcode?

If the required data are kept in a table or database already, they can be used to create the Excel barcode or data matrix code to match. The code can then be printed easily. Certain workstations may add associated necessary data in the form of additional information. This can be done using an input option or via an existing barcode, followed by review, potential supplementation with further data, and finally conversion into a barcode. Excel as a barcode generator is useful in connection with the REINER® handheld printers.

Microsoft Excel offers many great functions that bring about amazing results very easily. One is its simple input mask to insert data of any kind into tables regularly and recurrently. Finally, one of Excel's many useful add-ins, a barcode generator, will convert the data line into a 1D barcode or into various 2D codes such as data matrix or QR codes.

Direct printing: The benefits of creating changing QR codes with Excel and applying information directly to products.

Specific codes or individual information like the lot number make it possible to trace a product or component back to production. Learning from mistakes is important for technical progress and good, successful products. This makes it necessary to be able to determine the cause of an error, or to "trace it back" to its source.

There are hardly any industrially manufactured products or components without individual numbering or at least a batch number! Large series or industrial production on the assembly line often use laser engraving or stationary printers. Many small series and multi-stage production processes also require marking of workpieces or products. Since this must be done manually, the barcode printer is vital for mobile use in such an environment. Marking must be permanent and machine-readable as far as possible for reliable traceability.
Direct Printing Data Matrix Code

How can the barcode generator in Excel cost-effectively create, print and apply barcodes without labels?

Printing labels in Excel, especially with sequential numbers, is an elaborate and error-prone option, even more so if additional production data are to be integrated at different workstations!

A handy marking device from the REINER jetStamp® family uses the part number, lot number or batch number right from Excel. The output range of the final imprint is determined in Excel once using the "Set print area" function. All other settings and combinations of information can be made directly in Microsoft Excel.

Automation: What other options does Excel offer for automatically importing, combining and printing data?

Direct printing of batch and lot numbers onto packaging or product with an Excel macro

The special features of printing via Excel macro with REINER® marking devices at a glance:

• Saving time by optimising work steps
• Preventing errors by automatic data transfer to the device
• Cost-effective marking by connection to existing software via Excel macro
• Fast printing and transfer
• Marking dimensional, machine-readable codes as well as batch IDs
• Traceability of the produced parts is ensured by clearly legible and smear-resistant marking.

Mobile inkjet printers from REINER® offer modern documentation and marking "Made in Germany"!

REINER® offers a hand-held label printer without labels! Employees at incoming goods, in the warehouse or in production alike can set up the labels they need right at their work stations. Stationary printers or label printers are things of the past. "Paper labels" as a consumable are obsolete. The quick-drying REINER® P3-MP3 ink guarantees the best adhesion to a vast variety of materials. In contrast to paper or film labels, it cannot peel off under moisture, oil contamination or abrasion. Economical ink consumption and a long battery life turn the REINER® marking devices into valued team members. A special protective mechanism above the print head ensures that they can patiently take longer work breaks without drying up. All the precision and technical sophistication has gone into REINER® barcode printers for mobile use that stand out for their robustness and reliability.
smudge-resistant labelling of cans, containers