In some cases, Logging Data to Excel from Arduino become necessary for data analysis especially when a graphical analysis of multiple data is necessary. At the same time, we can use Arduino or any kind of device that is sending data to a PC, we can log them. Let’s see how.

Disclaimer: Electricity is always dangerous. Proper skill is required to work with electricity. Do work at your own risk. The author will not be responsible for any misuse or harmful act or any mistake you make. The contents of this website are unique and copyright protected. Kindly don’t do any nonsensical act copying and claiming it as yours. Most of the articles published here are kept open-source to help you. Take the knowledge for free and use it, but if you are interested you can buy the ready resources offered here. If you need any help or guidance feel free to comment below, the author will try to help you. Also, there can be affiliation links in the article. Which will not affect you anyway, but allows the author with some commission. So please don’t take it otherwise. Thanks.

Table of Contents

Advertisements

Step#1: Setup your device

First, set up your device with a USB or Serial cable so that the device can send data to the PC. If you use Arduino, then connect your Arduino and open the serial terminal to ensure data is coming. Then ensure data rate I mean baud rate. Say 9600 or 115200 or so…

excel data streamer
A sample of the ‘data logger’ device

Step#2: Setup your Excel

Microsoft Excel has a feature named Data Streamer. Download it and install it. After installation, you have an option on the top of your Excel file.

excel data streamer

On the top-left corner, you have an option to ‘Connect a Device‘. Connect your device to your PC and click this option.

excel data streamer

Now, you have the option and select your device from the list. And then click on Start Data.

excel data streamer

This will start the data to show, but it won’t record yet. Now, you have to click on ‘Record Data‘ to log your data. But, in some cases, if your data is not coming according to the default settings of Excel, then it won’t show anything. The default baud rate of Excel is 9600. If your data is coming in a different baud rate, then click on ‘Advance‘.

excel data streamer

Now, you have an option to set up the Baud Rate. Select yours and select Data Rows.

Once I select my one, then it starts recording the data instantly.

excel data streamer

Note: For multiple channels, simply keep a coma (,) between the channel data like this:

And you’ll get the result in Excel like this:

Step#3: Save and create the graph

Now, run the device and record the data according to your requirement. Once data is recorded, simply click ‘Stop Recording‘ which will stop recording and allow you to save a copy.

now you can create graphs from your data.

excel data streamer

Now, you can do whatever you need, even with multiple channel data.

End

I think, now you can log your data to an external file and create graphs easily. Thanks, Microsoft for the add-on. And now, we are able to explore more. Hope this helped you.

You can also check some other articles:

Thank you.

For Professional Designs or Help:

Loading

Also let me know what you want to get as the next article, comment below!


MKDas

Mithun K. Das; B. Sc. in EEE from KUET; Head of R&D @ M's Lab Engineering Solution. "This is my personal blog. I post articles on different subjects related to electronics in the easiest way so that everything becomes easy for all, especially for beginners. If you have any questions, feel free to ask through the contact us page." Thanks.

0 Comments

Leave a Reply

Avatar placeholder

Your email address will not be published.

%d bloggers like this: