Now that you’ve connected a source for your data, it’s time to start streaming it into Excel.

Capturing Data

For microcontrollers, select the Start Data button on the Data Streamer tab. The data will stream into the Data In worksheet.

Data In

The Data In worksheet is where you can find data entered into the workbook. The data is displayed in a data table that can be 1+ rows tall by 1+ columns wide in size. Size and other parameters can be changed in the Settings worksheet.

There are two tables on the Data In worksheet:

  • Current Data - The Current Data row always represents the most recent set of data points. Link to this table when you need a single data point.

  • Historical Data - The Historical Data table represents a series of data points. The data flows in two directions: 

    • Newest First - The top row shows the most recent set of data points. From there, data flows down the table. 

    • Newest Last - The bottom row shows the most recent set of data points. From there, data flows up the table.

Data Out

The Data Out worksheet is where data is sent back to the microcontroller board. This data can represent program control variables, numbers, or text. Common uses of the Data Out worksheet are to reset a program, set the number of a variable, and more. New data will be sent only if there is a change in the highlighted data table.   

Record Data

How to Save data when using the Data Streamer add-in

  • If you'd like to record the live data coming from your device, select the Record Data button. Recording will begin immediately.

  • When you’re ready to stop, select Stop Recording. You'll then be prompted to save the recorded data to a .csv file:

  • To replay your data, disconnect from your device from Data Sources > Disconnect Device, and then select Import Data File.

 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

Flash code and connect a microcontroller 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.