Flash code and connect a microcontroller to your PC

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.

Arduino

  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.

micro:bit

  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, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×