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

May 9, 2023

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—
LinkedIn :
GitHub :
Blog :
FB Page :
Instagram :
Facebook :
ResearchGate :

—Tags—
#arduino #capture #serial #data #txt #csv…(read more)

Convert Word 2 PDF: Word to PDF Converter

Convert PowerPoint 2 PDF: PPT to PDF Converter

Convert Excel 2 PDF: Excel to PDF Converter

Convert an Image 2 PDF: Image to PDF Converter

Convert HTML 2 PDF: HTML to PDF Converter

More Tools: PDF Converter

PDF Converter

38 thoughts on “How to Save Arduino Serial Data in TXT, CSV and Excel File”

I should create a web app that should allow me to read and view Arduino data in real time (maybe even graphs like in the video). Advice? Could I save the data to an excel file and have the webapp read the value later?

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

Super helpful, thanks !

Sir can I get ur mail id , I hv some doubts

Helpful

Where will the data be saved if the pc is shutdown

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

TE AMO

nice thanks 4 that its helpfull

Thanks for your video, but can you please suggest a process which is completely automated in the real time?

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.

Thanks a lot!

Thank you

How can I save data along with time ?

For MacBook it says access denied. Any suggestion?

Sir what if i want to send a command of time synchronization on the serial port and store data also

Thanks! It`s working perfectly!

Hi, my data is printing horizontally in the text file. My data is separated by a comma exactly like yours. How do I get the data to print in columns?

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

well done

Hi, I got a problem in data saved in text file. Each line of the data is separate by the println () command in aduino. In the view plain, the data look good with every line is separated. However, I checked the text file and there was no enter in the data, that mean all numbers were recorded in one line in the text. What should be the problem of this?

I dont know why my result is all in row data, cannot be column format like ur video shown

how to add date and time in the export Txt file

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?.

Great one, thanks !

Sir, I already have code for Arduino, do I need to write another code to save data in coolterm ?

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 🙁

can you send me the link, so it is not working?

How about the time in x-axis?

bro can we save data from nodemcu + arduno ide +excel

Hi sir, I need to store audio data. Right now, the sample rate is 16k. In this way, I think the serial print is not fast enough to print out every sample. Any suggestions here?

sir, I am passionate about learning and in this I need your help. I had tried to connect you through Linkedin but still my request is pending. please let me a way so that I can contact you. please sir.