How to Save Arduino Serial Data in TXT, CSV and Excel File

Save Arduino or microcontroller serial or UART data into a TXT or CSV file. This way you can easily save your embedded system logs for further analysis in Excel or Matlab. It will also help to debug your system for finding out the reliability.

I am making these videos out of my hobby. Like, Comment, Share are the only things that will motivate me to make more videos on my experience and don't forget to subscribe to my channel.

—About Me—
I prefer to introduce myself as a passionate engineer who loves to build things. I have completed my undergraduate from BUET, Bangladesh, and currently doing Ph.D. in the USA. I have been working with hardware since 2013 and also worked with a wide variety of things.

—Connect with me—

—Tags—
#arduino #capture #serial #data #txt #csv

[AndrewMoizer]

Thank you for doing this. I was just getting back into some Arduino development after a year or more and had to install the IDE on a new laptop and ended up with 2.0.1. Took me a while to figure out the new Serial Monitor, and then was more than a little annoyed that there was no way to select it all to save. So tried out your solution and it worked a treat on my MacBook Pro (Retina mid 2012) running Catalina connecting by USB to an old UNO board.

Why the Arduino dev people came up with this limitation in the first place, and haven't fixed it in well over a year is beyond me. I can only surmise that the developers aren't actually using the toolset that they are writing. OK, <rant over>, thanks for sharing this, and to Roger Meier for CoolTerm

[dreamzz]

Looked at so many videos before I came to this. Finally a very clear video! Thanks!

[alinatik]

YOU ARE AMAZING !!! Big thanks, i was struggling to do that and finally your video was the solution.

[sofiabottari]

Thank you so much, you saved me from copying them all manually!

[khansa]

Thank you, very helpful with a complete explanation

[seyi]

Thanks So Much, needed this for my disso results

[pepegomez]

Super helpful video! Thank you so much!!!

[carrocesta]

nice video! I have a problem: the text file is created and info travels throughout the port, however I no text is written on the file (file is empty). What could be the issue?.

[racfar]

Thank you very much for the video! It helped a lot!

[NiallFinn]

Thanks, that was super helpful and very clear. It has allowed me to use my arduino uno kiln-control project as a data logger, so useful!

[muzaffarhussainsayyed]

Thanks. sir i want to upload the data of arduino in excel sheet so will i have to keep the computer continuous on and then keep the excel sheet open please reply me

[fauzinurwahid]

Does the Arduino have to be connected to a laptop when you want to store data like this?

[cmiti]

Thank you so much, without this video I would not have succeeded in solving my arduino data capture problem

[heyitsme]

Sir, the txt file that is saved is blank. What should I do?

[qiangli]

I know that the software coolterm is powerful through your viedo. These days, it makes my computer crash when my matlab sample the data from arduinuo via serial communication. Thank you for sharing and give me another way to gather data.

[MengYang-]

Thank you very much. It's very helpful to me !!!

[crafter]

Thank you! Could you tell me please is it possible to save txt in python when in the uart port 115200 from other device we get a lot of information? Couldn’t to make delay :(

[jonathanfreels]

Whenever I have CoolTerm tack on timestamps, it also skips a line between each data packet. Do you know if there is a way to stop this?

[anindambagchi]

Hello Shuvangkar, need help in sending serial data from the sensor data over wifi. i am using arduino rev 2.0 wifi board

[muzaffarhussainsayyed]

Where will the data be saved if the pc is shutdown