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-
LinkedIn : / shuvangkar
GitHub : github.com/shuvangkar
Blog : embedschool.com/
FB Page : / embedschool
Instagram : / shuvangkar_das
Facebook : / sshuvo93
ResearchGate : www.researchgate.net/profile/...
-Tags-
#arduino #capture #serial #data #txt #csv

[@dreamzz90]

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

[@ShuvangkarDas]

Glad it helped!

[@alinatik35]

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

[@ShuvangkarDas]

Glad to hear that it helped :D

[@sofiabottari724]

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

[@ShuvangkarDas]

Happy to hear it helped :D.

[@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, , thanks for sharing this, and to Roger Meier for CoolTerm

[@ShuvangkarDas]

Great to know it helped.

[@khansa5799]

Thank you, very helpful with a complete explanation

[@seyi1510]

Thanks So Much, needed this for my disso results

[@jhyland87]

This helped me out today. Thanks!

[@pepegomez7615]

Super helpful video! Thank you so much!!!

[@racfar1]

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

[@taherrad153]

Awesome Guide! Thank you so much 🙏

[@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!

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

[@marceloitalovirgillito6330]

Thanks! It`s working perfectly!

[@ShuvangkarDas]

You are welcome

[@user-po9yv3eu9s]

You are my hero! Thank you!

[@adambeedle]

Great video nice one 👍

[@ShuvangkarDas]

Thank you 😁

[@MengYang-]

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

[@ShuvangkarDas]

You are welcome.

[@qiangli1578]

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.

[@ShuvangkarDas]

You are welcome.

[@muzaffarhussainsayyed8010]

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

[@dhyeyshah6732]

Great one, thanks !

[@heyitsme370]

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

[@shivajoshi9068]

Thank a lot really heplful!

[@only4music725]

Super helpful, thanks !

[@ShuvangkarDas]

Welcome

[@Br3Br2Br1]

Bravo!!!! Grazie!!!!

[@jonathanfreels6798]

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?

[@crafter3190]

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 :(

[@ShuvangkarDas]

Yes, you can do that

[@BlackCat-yz3oc]

Thanks for the information

[@seejj]

Thanks, really helpful!

[@ShuvangkarDas]

Happy to help :D

[@anindambagchi4602]

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

[@muzaffarhussainsayyed8010]

Where will the data be saved if the pc is shutdown

[@zaidhasan5862]

if i want enter data from text file to Arduino.... against the video what can i do?
please

[@liweiwang6665]

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?

[@ShuvangkarDas]

Try sampling in 8-bit mode

[@mancer2161]

thank you brother !

[@moonedCake]

Onek Onek, Thanks! 💟😭😭

[@ShuvangkarDas]

You are welcome!

[@pasqualepacelli893]

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?

[@yeya24la]

Same. I need to create an app that will capture ESP32 board data over wifi in real time with a save button. I can take all the help I can get.

[@zhungonlyx]

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?

[@gines6234]

In CoolTerm go to Options --> File Capture --> Check Retain termination string :D

[@benvanzon3234]

@@gines6234 Do you also know how to get the commas to show up?
I'm only getting spaces inbetween my values, even though I added commas in the program

[@gines6234]

@@benvanzon3234 No idea honestly, they should appear if you put it in arduino code. Nevertheless try playing with the options in Text or File Capture.

[@zhungonlyx]

@@gines6234 Yes, this can solve the problem.

[@zhungonlyx]

@@gines6234 Many thanks

[@eliyahomar]

Thank you so much

[@abirde696]

This worked for me.

[@takiyashir8712]

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

[@ShuvangkarDas]

If you want really automated, then write python script.

[@josephdaquila2479]

Couldn't you just store the variables in an array while you're measuring?
And then once done measuring say you're done and then loop thru the contents of the array to generate the csv?

[@carolinahenao4707]

Thank you!

[@dodgeshadow099]

do you know if it is possible to save data for about two days?

[@ShuvangkarDas]

Yes it is possible.

[@yeya24la]

The data that I see in the Arduino IDE doesn't display the same in CoolTerm. CoolTerm shows me all sorts of characters. It's like I'm missing some converter. Help?

[@sofiya3733]

can you solve it? if you can, how do you do it?

[@oliver197637]

nice thanks 4 that its helpfull

[@ShuvangkarDas]

Happy to help

[@investin_selfcare1612]

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

[@ShuvangkarDas]

You have to write few lines of Arduino Code. In coolterm there is an option to send command to Arduino.

[@ewezungim6541]

Mine worked initially but I started getting 'access denied'. Help please anyone?

[@SkullKrish]

Thank you

[@trushti_1375]

Any idea how to use PS2 keyboard with esp

[@user-yg9pj9cm8s]

it is showing me access denied error even if I am running the app as an administrator.
what should I do?

[@bjy703]

any luck with this?

[@igedearthanegara5682]

Helpful

[@ShuvangkarDas]

Thank you

[@victorparkhomenko4185]

Thanks a lot!

[@ShuvangkarDas]

You are welcome.

[@user-du2pz6ci1b]

I faced a problem in coolterm.
I need to sote the data in around 6 month or more for thesis perpuse.
But when arduino Restarted or PC Restarted or CoolTerm terminated and when I start to data logging again, then it can't store the data in same file with out lossing previous data.
If i use same name then It replace the previous file. 😪
Please help me.
Have any more similar software???

[@ShuvangkarDas]

In your application, I suggest you to use SD card with arduino instead of collecting data using terminal. You just need a SD card module to connect the card with Arduino. Arduino has an by default example to interface with. You will find a lot of example in google search, how to connect sd card with arduino. Thank you.

[@user-du2pz6ci1b]

@@ShuvangkarDas wow! Thanks a lot.
Is SD Card can store the data in csv or xml formate?
And is SD card can continue update the data in same file without lost previous data if the power is interrupt?

[@ShuvangkarDas]

You can store in any format and data preserves in power cycle.

[@user-du2pz6ci1b]

@@ShuvangkarDas Thanks a lot bro. 🙏

[@kalyani695]

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

[@ShuvangkarDas]

No. You just need to serial print. Cool term save automatically

[@kalyani695]

@@ShuvangkarDas okay sir, thank you so much!

[@kalyani695]

@@ShuvangkarDas sir , it is not showing timing in coolterm but it showing in serial monitor, what should I do now?

[@chadalavadasivasanthosh3926]

very helpful

[@ShuvangkarDas]

Thank you

[@abanahj5491]

How about the time in x-axis?

[@ShuvangkarDas]

You have to get the time fron Arduino. Use RTC or millis

[@anesunyabadza8058]

well done

[@ShuvangkarDas]

Thanks

[@alejandroguevara3105]

TE AMO

[@user-cj2xe2je6l]

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

[@ShuvangkarDas]

Because, you didn't put new line command in your code.

[@gines6234]

In CoolTerm go to Options --> File Capture --> Check Retain termination string :D

[@Omhange]

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

[@ShuvangkarDas]

Yes you can

[@debanjanborthakur4321]

For MacBook it says access denied. Any suggestion?

[@ShuvangkarDas]

That's a security issue you need to resolve. Try searching enabling serial port in macbook.

[@debanjanborthakur4321]

@@ShuvangkarDas resolved.

[@rear1117]

how to add date and time in the export Txt file

[@ShuvangkarDas]

Use RTC with Arduino and generate date time.

[@shubhamkumar-gx5vx]

How can I save data along with time ?

[@ShuvangkarDas]

Enable time in Arduino Serial Terminal
Or write code in to print time

[@Mohamed-uo8nl]

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

[@ShuvangkarDas]

What link are you looking for?

[@Mohamed-uo8nl]

@@ShuvangkarDas the application

[@ShuvangkarDas]

@@Mohamed-uo8nl freeware.the-meiers.org/ here it is

[@midasama3124]

This does not work on Linux unfortunately. As soon as Coolterm connects to the serial port, Arduino starts seeing gibberish on the terminal.

[@midasama3124]

Actually, you need to close Arduino's serial console and just use CoolTerm, then it works.

[@AnwinJose-xr7yl]

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

[@ShuvangkarDas]

You will get my email address in YT channel description

[@jyotiprakashs8394]

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.

[@ShuvangkarDas]

Accepted. Thanks for connecting

[@AdityaSengupta]

Thank you

[@waleedtariq3203]

Thank you

[@ShuvangkarDas]

Welcome!