Fix Excel Data Streamer Not Working with Arduino Portenta and Nano
Question details
The user is attempting to stream serial data from Arduino Portenta and Nano boards into Excel using the Data Streamer add-in, but Excel fails to receive the data despite working perfectly with an Arduino Uno.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Streaming real-time sensor data from a microcontroller via a USB serial connection into an Excel spreadsheet for monitoring and analysis.
- Observed behavior
- Excel Data Streamer receives no data from the newer Arduino boards, which are identified as generic 'USB Serial Device' rather than specific Arduino boards. The exact same sketch and serial parameters work successfully with an Arduino Uno, as well as with alternative programs like Serial Plotter and PLX-DAQ.
Ensure your Arduino is securely connected via USB and that the Arduino IDE Serial Monitor is fully closed, as the COM port can only be accessed by one application at a time.
Configure the Generic USB Serial Device Settings in Data Streamer
Manually map Excel Data Streamer to the generic COM port assigned to the Portenta/Nano and match the baud rate exactly with your Arduino sketch.
Unlike the Arduino Uno which has a dedicated USB-to-serial chip recognized by Windows by name, newer boards like the Nano 33 IoT or Portenta often handle USB communications natively. This causes them to appear generically as a 'USB Serial Device'. Data Streamer can still read them if configured manually.
Right-click the Windows Start button, select 'Device Manager', and expand the 'Ports (COM & LPT)' section. Note the COM port number assigned to 'USB Serial Device'.
Open Excel, navigate to the 'Data Streamer' tab on the ribbon, and click 'Connect a Device'. Select the COM port number that you noted from the Device Manager.
In the Data Streamer ribbon, click 'Advanced'. Ensure that the selected Baud Rate perfectly matches the rate specified in your sketch's Serial.begin() command (e.g., 9600).
Click 'Start Data' in the Data Streamer ribbon to begin capturing the formatted CSV string from your Arduino.

Use a Terminal Logger and Import the CSV Manually
If the Data Streamer COM Add-in continues to reject generic serial hardware descriptors, bypass the add-in by logging the data to a CSV file and importing it.
Analyze Your Exported Arduino Data with WPS Office
If Excel's Data Streamer add-in restricts your hardware choices, you can log your Arduino data to a CSV file and open it instantly in WPS Spreadsheet. WPS Office is a highly compatible, lightweight, and completely free suite for all your data analysis needs.
- 1. Install WPS Office: Download and install the free WPS Office suite on your computer.
- 2. Open your data file: Launch WPS Spreadsheet and go to Menu > Open to select your exported Arduino CSV log.
- 3. Visualize the data: Highlight your data columns and use the Insert > Chart feature to generate line graphs and analyze your sensor trends.

Frequently Asked Questions
Why does Arduino Uno work with Excel Data Streamer but not Nano or Portenta?
The Arduino Uno uses a dedicated USB-to-serial chip (like the ATmega16U2) that provides a specific hardware identifier natively recognized by Excel Data Streamer. Newer boards like the Portenta or Nano often rely on built-in USB controllers that identify simply as generic 'USB Serial Devices', which Data Streamer may sometimes fail to bind to automatically.
How do I format my Arduino code to send data to a spreadsheet?
Data must be sent as a continuous stream of comma-separated values (CSV). End each data row with a newline character. For example, use `Serial.print(sensor1); Serial.print(",");` for the first value, and finish the row with `Serial.println(sensor2);`.
Can I use PLX-DAQ instead of Excel Data Streamer?
Yes. PLX-DAQ is a classic VBA macro-based tool that relies on standard serial communication rather than strict Windows device descriptors. Since your Portenta/Nano works with PLX-DAQ, you can continue using it to log live data directly into a spreadsheet environment as a reliable workaround.




