DDE Connection: Stream Live Sensor Data into Excel

Live sensor data in Excel

DDE Connection: Stream Live Sensor Data into Excel

DDE (Dynamic Data Exchange) is a Windows link that lets one program send live data to another. A DDE server app reads your sensors; Excel, acting as the DDE client, receives each reading in a cell and keeps it updated – so you can chart, alarm and report on live sensor data without programming.

Excel workbook showing live sensor readings, trend chart and limits, updated through a DDE connection

Monitor real processes, entirely in Excel

DDE connects sensor data acquisition to Excel for real-time monitoring that runs continuously, entirely inside the spreadsheet. Typical examples:

  • Tank level and waste storage capacity
  • Refrigeration and freezer temperature
  • Water flow rate and steam line pressure
  • AC power

What is DDE?

DDE is a program-to-program bridge built into Windows. It links sensor data acquisition software to other applications so they can exchange data, commands and events. It uses a message protocol and shared memory, and supports both one-time transfers and continuous updates whenever new data arrives. DDE works on Windows 10 and 11.

Why it matters: many acquisition devices come with little more than a driver and a command list. If no add-in is listed for the application you use, the device is hard to connect – and some sense-and-control I/O only works with custom software. Windows offers several ways to move data between programs; DDE is the simple bridge that connects otherwise incompatible hardware to common software such as Excel.

Benefits of DDE

  • Standard Windows technology
  • Easy to use and configure
  • Efficient – transfers data quickly
  • Reliable – used in mission-critical applications
  • Periodic updates up to 100 per second (depends on channel count and PC)
  • Set the link up once – data then flows with no user interaction

DDE server and clients

DDE uses a server–client setup. The server (the app talking to your sensor hardware) publishes the readings; one or more clients – for example a chart application and a spreadsheet at the same time – subscribe to them.

How a connection is defined

Service
the server application
Topic
the device or data group
Item
the individual channel
Format
typically ASCII / text

How fast it updates

DDE is a real-time message link, not a high-speed transfer. The maximum is about 100 updates per second, depending heavily on the PC and the number of active links. A single 4-input module typically updates its links 1 to 10 times per second – plenty for temperature monitoring such as freezers and greenhouses.

Some packages extend their own capabilities through DDE – Microsoft 365 Excel is the best-known example. With DDE, Excel can build live reports with no programming knowledge; setup time depends on your Excel experience.

Customize Excel to display and report sensor changes

Through DDE, sensor data arrives in Excel in real time, and signal processing happens in real time too. Use Excel’s graphs and built-in tools to show changes as they happen, add formulas and charts, and auto-save. DDE can also fill an Excel report template, so reports build themselves – ideal for compliance documentation and quality control, such as refrigeration monitoring in food storage. Most companies already have Excel, and many people know how to use it.

An automatic report in seven steps

  1. Collect the data into fixed rows and columns.
  2. Calculate average, minimum and maximum.
  3. Plot the trends.
  4. Show deviation from the expected trend.
  5. Show whether values are within limits.
  6. Format the print page.
  7. Auto-save the report – the cycle repeats, building a folder of weekly or monthly reports.

Database storage

Connect acquisition software to a database for central storage that other applications can read.

Visualization

Feed a visualization tool for real-time displays and custom screens.

Control system expansion

Connect to a control system to switch devices based on sensor data.

Robert Owen DDE apps

Ready-to-run DDE server apps

Robert Owen offers DDE server apps that are ready to run. Each server is device-specific and pairs with a DDE client. Your device may also need its driver package or setup utility in Windows Device Manager.

HardwareConnectionNotes
ROI-RFX Robert Owen2.4 GHz wireless, long distanceWireless sensor collection – no cable runs. Wireless options
ROI-USB analog input module Robert OwenUSB, local PC4 channels: thermistor, 4-20 mA or 0-5 V
ROI-IOM Robert OwenModbus RS-485 wired, long distanceMany points on one cable, in Robert Owen systems

Servers are available or in development for the hardware listed. Each Robert Owen DDE client lists the servers it works with on its product page.

Set up in four steps

  1. Install the DDE server software.
  2. Wire the sensors (for example thermistors) to the terminal panel – instrumentation cable can extend the connections.
  3. Connect the sensor converter to the PC (USB) or wireless receiver.
  4. Run the included DDE server app. When live data appears, open and run the included sample Excel workbook.

Starter kits

A Robert Owen DDE server app and DDE client with your choice of ROI-RFX wireless or USB sensor hardware and thermistor sensors – ask for a quote with your channel count.

Already use DASYLab? A DASYLab ROI-USB thermistor kit is also available – quote on request.

Request a starter kit quote →

Ready-to-run DDE clients

Robert Owen has built Excel-based sensor DDE clients into custom solutions for years. Prewritten, ready-to-run clients can save money if you are flexible on the exact layout:

Recorder

Logs readings over time.

Strip chart & bar chart

Live trend and level displays.

Digital meters & analog gauges

At-a-glance values.

A combined client includes the recorder, bar chart, strip chart and digital meters together. The solutions cover wireless data acquisition and 24/7 monitoring for agriculture, oil, wastewater, refrigeration and building management.

  • Need faster than DDE allows? If the device supports it, direct acquisition software can update at samples-per-millisecond rates.
  • Custom software, screens and recording setups on request.
  • Consulting if the setup looks complex – and data acquisition systems available to verify your application first.

DDE – common questions

What is DDE?

Dynamic Data Exchange – a Windows method that lets programs share data. A DDE server publishes values; DDE clients such as Excel receive them and update automatically.

Can temperature monitoring data be exported to Excel?

Yes. A DDE server app streams live temperature readings straight into Excel cells, where you can chart them, check limits and auto-save reports. Excel files can also be passed on to other systems.

Does DDE still work on Windows 10 and 11?

Yes. If Excel links don’t update, check Excel’s Trust Center settings for external content and DDE.

How fast can a DDE connection update?

Up to about 100 updates per second, depending on the PC and number of links. A 4-input module typically updates 1 to 10 times per second – enough for most temperature monitoring.

What is the difference between a DDE server and a DDE client?

The server talks to the sensor hardware and publishes the readings; the client (for example Excel, a chart or a gauge) displays or records them. One server can feed several clients at once.

Related

Data acquisition software

Software for recording, displaying and reporting sensor data.

See the options →

MQTT to Excel

Update Excel automatically when remote sensor data changes.

Read the guide →

Record a temperature sensor in Excel

Log a USB temperature sensor straight into a spreadsheet.

Read the guide →

Want live sensor data in Excel?

From a single sensor to hundreds, we connect sensors and software – signal conditioning, signal processing and data acquisition, including custom software.

Questions? Contact us – we look forward to answering them.

Like us on Facebook  |  Follow us on X

Scroll to Top