RS232 Balance and Scale Software

Collect is a data collection and interface software program that connects to any balance’s RS232 port and reports the balance data directly to Excel®, files or any Windows® application.

Collect interacts with all different makes and models of balances and scales including those from manufacturers like Sartorius, Mettler, Ohaus, Denver Instruments, Adam Equipment, Scientech, Weigh-Tronix, Shimadzu, A & D and many others.

Collect also includes a Library of Excel® templates for many common weighing applications, including:

Check weighing
Loss on Drying
Moisture analysis
Suspended Solids
Counting by weight
Sieving analysis
Density determination
plus many other weighing applications

Connect your Balance or Scale directly to Excel® or Any Program

Collect connects with, and controls any balance or scale through its RS232 serial communication port. 
The raw data packet that is received from a balance, typically contains extra characters that are not required by the receiving program.  Collect extracts only the required data, such as the numerical weight value then transfers that reading into your application. For sending weights  to Excel® , the Collect software has built-in DIRECT-XL™ technology that connects balances or scales directly with Excel®, simply and easily.

Unlike older ‘wedge’ technology, DIRECT-XL™ doesn’t rely on the cursor location for placing data in Excel®. This ensures that data from the instrument is always placed in the correct location in your Excel® spreadsheet  even if you are working in another application during data collection or if data is being collected while the computer is locked.

Collect’s DIRECT-XL™ interface is so smart, that if data already exists in a cell, it will skip over that data and transfer the reading to the next available cell.

DIRECT-XL™ ensures that data is collected correctly every time. 

RS232 Interface to Excel

Library of Pre-configured Instrument Interfaces and Excel® templates

Most balance and scale interface setups are already preconfigured in Collect’s Instrument Library. You select your model from a pull-down list and all of the COM port RS232 default settings and command sets (Print or Send Command, Tare, Zero, and other control commands) are automatically loaded and ready to use.

Features such as Time, Date, Milliseconds, Counter and User ID stamps can be reported along with the weight data. Other Collect features like timed interval data collection or embedding VBA macro’s for advanced control, allow Collect to meet virtually any weighing application requirement.

Simply select your instrument from the list and you’re ready to start collecting data.

View Collect’s Instrument Library

Collect’s Method Library of Excel® templates for common weighing applications contain special macros and equations; Charting, calculations, limit check flags, statistics, name the file by Date and customized views are just some examples that you are free to use for your own applications.

View Collect’s Method Library

Connect Multiple balances and scales at the same time

With a single mouse click, Collect will automatically open your data destination program (eg. Excel®), initialize all balance and scale interfaces and start collecting data.

From a single computer, Collect can interface up to 99 balances and scales at the same time.

View Collect's Main Screen: English – French – German – Italian – Spanish – Japanese

Floating Toolbar and RS232 Command Control

At run-time, every balance and scale gets its own button on the toolbar which floats over top of the program that Collect is transferring data into. Collect makes it easy to add custom commands for any instrument.

• Collect can send commands automatically on a timed interval basis.
• Use any keyboard key as a hotkey to send a command.
• Multiple instruments can share the same hotkey allowing you to send a command to all instruments at the same time.

The Collect toolbar makes it easy for you to send commands to the instruments.

Collect Provides Superior Performance

Labtronics introduced Collect in 1989 as the World’s first RS232 data collection software. Over the years Labtronics has gained a tremendous amount of experience interfacing instruments and it has used this knowledge to keep Collect at the forefront of technology. Continued innovations, such as DIRECT-XL™, ensures that the product meets your needs today and in the future.

Collect’s many out-the-box features include:

• Connect any RS232 instrument to any program: Directly to Excel® using DIRECT-XL™ technology, write directly to files, databases, or ‘wedge’ into any Windows® program.
• Instrument Library: Pre-configured interfaces for over 500 different instrument models.
• Hotkey Commands: Start and stop instrument commands using any keyboard key.
• Method Library: Pre-configured Methods including Excel® templates for many common applications.
• Speedy processing: Send commands at a rate of 10 per second, receive and process incoming data at rate of over 20 per second.
• Extra information for readings: Add Date, Time, Milliseconds and User ID meta-data to instrument readings.
• Timed interval data collection setting: Collect data at a defined frequency with option to stop after a number of readings.
• Multiple instrument support: Connect and run multiple instruments interfaces simultaneously.
• Filter and Discard data options: Filter incoming data to convert characters to strings or strings to characters or discard unwanted or erroneous outputs.
• Powerful Parser: Easy to setup parser handles simple to complex raw data outputs to extract only required readings.
• Communication protocols: Support connecting slave devices using Modbus or clinical analyzers with ASTM 1381.
• Free RS232-to-TCP/IP software utility: Connect remote instruments directly to any computer with Collect installed, over your network.
• TCP/IP Ethernet data collector: Connect instruments or converters TCP/IP Ethernet port directly to any computer with Collect installed.
• SAX Basic editor: Ability to add VBA like macros directly within Collect’s instrument interface setups and Method setups to further enhance its many out-of-the box features.
• Multi-lingual editions available on same CD: Install in either English, French, German, Italian, Spanish or Japanese.

View Collect’s Full List of Features

Who Uses Collect

Collect is used by thousands of customers around the World, across a wide-range of industries, to interface and automate many different types of instruments and their applications.

Whether the need was to automate data collection in QA/QC, R&D, Production lines, Field Research, Clinical, Healthcare, Telecommunications or Plant / Facility monitoring, Collect can deliver the right solution for the job.

View Collect’s Customer List

Technical Support Included

The software comes complete with free technical support for 1 year including telephone, e-mail and internet services. Using our WebEx account we can host remote meetings to view and/or control your Collect computers desktop over the internet to help troubleshoot any communication problems you might be having with the instrument.

How to Order

To order, simply download the Order Form for pricing and ordering information. The Collect software includes a 100% money back guarantee. If you are not completely satisfied with Collect, return it to us within 30 days for a full refund.


Price List and How to Order  |  Free 30-Day Trial Download  |  Collect Resources  |  Contact Us