Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

To visualize real-time data in Excel with the Data Streamer add-in, you'll need to connect a microcontroller and flash code onto it.

Flash Code

Before you can visualize live data, you need to flash code onto your microcontroller board. This code will interpret the signals being sent by the sensor or sensorized device.


  1. Install the Arduino IDE from the Microsoft Store.

  2. Download Arduino code files from the corresponding Hacking STEM lesson plan.

  3. Open your downloaded file to launch the Arduino app.

  4. In the Arduino app, select: Tools > Port > COM 3 (Arduino/Genuino Uno). Your port may be different than COM3.

  5. Select Tools > Board: Arduino/Genuino Uno.

  6. Click on the circular right arrow button to upload the code to the microcontroller board.


  1. Download the .hex code files from the corresponding lesson plan Hacking STEM lesson plan.

  2. Plug your micro:bit to your computer using a USB cable. Install the mbed driver.

  3. In File Explorer, navigate to the micro:bit. It will appear as an external storage device, like a thumb drive or hard drive.

  4. Open a second File Explorer window and navigate to the Downloads folder. Make sure you can see both windows.

  5. Select the .hex file in the Downloads folder, then drag it to the micro:bit window.

  6. Once the LED light stops blinking, the code has been uploaded to the micro:bit microcontroller board.

Now it’s time to start streaming your data into Excel.

Connect a microcontroller

Select Connect a Device to choose a microcontroller (Arduino, micro:bit). A sub-menu will appear that allows you to select a device that’s currently plugged into to your computer.

How to connect a device when using the Data Streamer add-in

If you don’t see any devices, or your device isn’t listed, make sure a compatible device is connected to your computer, and that any necessary drivers are installed. Your device will automatically appear after you’ve connected it.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

What is Data Streamer?

Enable the Data Streamer add-in

Start streaming real-time data with the Data Streamer add-in

Advanced settings for the Data Streamer add-in

Workbook settings for the Data Streamer add-in

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!