Anyone out there know how to live stream BTLE or ANT+ sensor data into Excel or Google Sheets?
When you Google the topic, you’ll find a lot of information about some ways to accomplish this, but I didn’t see anything definitive. A lot of the methods involve collecting the data and then streaming to a web platform. Apparently, no easy way to accomplish this task.
Moxy sells a serial adapter for $149USD that will do what you’re asking. It converts the data stream from several Ant+ device profiles for use in various software, e.g., Excel, Matlab, etc. You’ll likely need a serial port on your PC, unless Moxy has a serial to USB adapter. You’ll also have to prepare your own VBA code to read the device in Excel or find some other DAQ.
Out of curiosity, why stream to Excel live?
Sending live sensors data to a PC
1 Like
You can pull live sensor data into Google Sheets using Google Apps Script. If you’re working with Bluetooth sensors, you might need a bridge like a Raspberry Pi or ESP32 to send data via HTTP requests. For Excel, Power Query or VBA could help, depending on your setup. If you’re deep into Excel automation, some of the Best Excel Books cover scripting and data streaming in detail.