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

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

[@dreamzz90]

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

[@ShuvangkarDas]

Glad it helped!

[@sofiabottari724]

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

[@ShuvangkarDas]

Happy to hear it helped :D.

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

[@cmiti2598]

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

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

[@frankwest498]

this was an amazing video thank you so much helped me with my project in school :)

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

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

[@khansa5799]

Thank you, very helpful with a complete explanation

[@seyi1510]

Thanks So Much, needed this for my disso results

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

[@taherrad153]

Awesome Guide! Thank you so much 🙏

[@jhyland87]

This helped me out today. Thanks!

[@floridian080]

Excellent explanation of coolterm. Very helpful. It beats saving data on SD, which is very temperamental. Any suggestions for saving data when running an Arduino sketch on battery and disconnected from computer? Or in that case are we just left with the SD?

[@moonedCake]

Onek Onek, Thanks! 💟😭😭

[@ShuvangkarDas]

You are welcome!

[@MengYang-]

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

[@ShuvangkarDas]

You are welcome.

[@pepegomez7615]

Super helpful video! Thank you so much!!!

[@marceloitalovirgillito6330]

Thanks! It`s working perfectly!

[@ShuvangkarDas]

You are welcome

[@adambeedle]

Great video nice one 👍

[@ShuvangkarDas]

Thank you 😁

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

[@fauzinurwahid4101]

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

[@racfar1]

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

[@Atlas-b5t]

You are my hero! Thank you!

[@heyitsme370]

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

[@muzaffarhussainsayyed8010]

Where will the data be saved if the pc is shutdown

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

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

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

[@anindambagchi4602]

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

[@abanahj5491]

How about the time in x-axis?

[@ShuvangkarDas]

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

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

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

[@dhyeyshah6732]

Great one, thanks !

[@only4music725]

Super helpful, thanks !

[@ShuvangkarDas]

Welcome

[@dodgeshadow099]

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

[@ShuvangkarDas]

Yes it is possible.

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

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

[@zaidhasan5862]

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

[@BlackCat-yz3oc]

Thanks for the information

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

[@seejjordan]

Thanks, really helpful!

[@ShuvangkarDas]

Happy to help :D

[@রোবটিক্সগুরুজী]

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.

[@রোবটিক্সগুরুজী]

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

[@রোবটিক্সগুরুজী]

@@ShuvangkarDas Thanks a lot bro. 🙏

[@trushti_1375]

Any idea how to use PS2 keyboard with esp

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

[@DevMishra-e9x]

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?

[@宏超林]

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

[@ewezungim6541]

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

[@Omhange]

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

[@ShuvangkarDas]

Yes you can

[@oliver197637]

nice thanks 4 that its helpfull

[@ShuvangkarDas]

Happy to help

[@shivajoshi9068]

Thank a lot really heplful!

[@rear1117]

how to add date and time in the export Txt file

[@ShuvangkarDas]

Use RTC with Arduino and generate date time.

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

[@Br3Br2Br1]

Bravo!!!! Grazie!!!!

[@abirde696]

This worked for me.

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

[@soherhatem6776]

Thanks ❤❤

[@shubhamkumar-gx5vx]

How can I save data along with time ?

[@ShuvangkarDas]

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

[@mancer2161]

thank you brother !

[@chadalavadasivasanthosh3926]

very helpful

[@ShuvangkarDas]

Thank you

[@igedearthanegara5682]

Helpful

[@ShuvangkarDas]

Thank you

[@eliyahomar]

Thank you so much

[@arshiafas9361]

Thank you Bro

[@waleedtariq3203]

Thank you

[@ShuvangkarDas]

Welcome!

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

[@anesunyabadza8058]

well done

[@ShuvangkarDas]

Thanks

[@victorparkhomenko4185]

Thanks a lot!

[@ShuvangkarDas]

You are welcome.

[@carolinahenao4707]

Thank you!

[@alejandroguevara3105]

TE AMO

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

[@AnwinJose-xr7yl]

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

[@ShuvangkarDas]

You will get my email address in YT channel description

[@amusklb]

Thanks!

[@SkullKrish]

Thank you

[@AdityaSengupta]

Thank you