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

Поделиться
HTML-код
  • Опубликовано: 23 янв 2025

Комментарии • 128

  • @AndrewMoizer
    @AndrewMoizer 2 года назад +16

    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

  • @dreamzz90
    @dreamzz90 2 года назад +17

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

  • @sofiabottari724
    @sofiabottari724 2 года назад +8

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

  • @alinatik35
    @alinatik35 2 года назад +10

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

  • @muzaffarhussainsayyed8010
    @muzaffarhussainsayyed8010 Год назад +2

    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

  • @qiangli1578
    @qiangli1578 2 года назад

    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.

  • @cmiti2598
    @cmiti2598 6 месяцев назад

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

  • @NiallFinn
    @NiallFinn 10 месяцев назад

    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!

  • @SashankRajareddy
    @SashankRajareddy 7 дней назад

    hii. i just want to know that does it store the data in ram initially and then save that to the file or directly writes to the file because for high frequency data acquisition if it directly writes to file wouldnt be helpful. from the text file i am assuming that it initially stores the data in ram then writing the data to text file as a batch. can you please confirm my query.

  • @frankwest498
    @frankwest498 3 месяца назад

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

  • @fauzinurwahid4101
    @fauzinurwahid4101 7 месяцев назад

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

  • @carrocesta
    @carrocesta 2 года назад +2

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

  • @floridian080
    @floridian080 26 дней назад

    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?

  • @khansa5799
    @khansa5799 Год назад +2

    Thank you, very helpful with a complete explanation

  • @seyi1510
    @seyi1510 8 месяцев назад +1

    Thanks So Much, needed this for my disso results

  • @muzaffarhussainsayyed8010
    @muzaffarhussainsayyed8010 Год назад +1

    Where will the data be saved if the pc is shutdown

  • @heyitsme370
    @heyitsme370 2 года назад +1

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

  • @jonathanfreels6798
    @jonathanfreels6798 9 месяцев назад

    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?

  • @zhungonlyx
    @zhungonlyx 2 года назад +1

    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
      @gines6234 2 года назад +2

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

    • @benvanzon3234
      @benvanzon3234 2 года назад

      @@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
      @gines6234 2 года назад

      @@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
      @zhungonlyx Год назад +1

      @@gines6234 Yes, this can solve the problem.

    • @zhungonlyx
      @zhungonlyx Год назад +1

      @@gines6234 Many thanks

  • @adambeedle
    @adambeedle 3 года назад +5

    Great video nice one 👍

  • @josephdaquila2479
    @josephdaquila2479 10 месяцев назад

    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?

  • @pasqualepacelli893
    @pasqualepacelli893 Год назад +1

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

  • @dodgeshadow099
    @dodgeshadow099 2 года назад +1

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

  • @jhyland87
    @jhyland87 Год назад

    This helped me out today. Thanks!

  • @taherrad153
    @taherrad153 10 месяцев назад

    Awesome Guide! Thank you so much 🙏

  • @zaidhasan5862
    @zaidhasan5862 Год назад

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

  • @yeya24la
    @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
      @sofiya3733 Год назад

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

  • @marceloitalovirgillito6330
    @marceloitalovirgillito6330 2 года назад +1

    Thanks! It`s working perfectly!

  • @moonedCake
    @moonedCake 2 года назад +1

    Onek Onek, Thanks! 💟😭😭

  • @anindambagchi4602
    @anindambagchi4602 Год назад

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

  • @crafter3190
    @crafter3190 2 года назад

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

  • @investin_selfcare1612
    @investin_selfcare1612 2 года назад

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

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад

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

  • @abanahj5491
    @abanahj5491 2 года назад +1

    How about the time in x-axis?

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад

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

  • @MengYang-
    @MengYang- Год назад +1

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

  • @Atlas-b5t
    @Atlas-b5t 9 месяцев назад

    You are my hero! Thank you!

  • @pepegomez7615
    @pepegomez7615 Год назад

    Super helpful video! Thank you so much!!!

  • @DevMishra-e9x
    @DevMishra-e9x Год назад

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

    • @bjy703
      @bjy703 10 месяцев назад

      any luck with this?

  • @kalyani695
    @kalyani695 2 года назад

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

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад +1

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

    • @kalyani695
      @kalyani695 2 года назад

      @@ShuvangkarDas okay sir, thank you so much!

    • @kalyani695
      @kalyani695 2 года назад

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

  • @racfar1
    @racfar1 Год назад

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

  • @liweiwang6665
    @liweiwang6665 2 года назад

    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?

  • @宏超林
    @宏超林 2 года назад

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

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад

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

    • @gines6234
      @gines6234 2 года назад

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

  • @debanjanborthakur4321
    @debanjanborthakur4321 2 года назад

    For MacBook it says access denied. Any suggestion?

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад +1

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

    • @debanjanborthakur4321
      @debanjanborthakur4321 2 года назад

      @@ShuvangkarDas resolved.

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

    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
      @ShuvangkarDas  2 года назад +1

      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.

    • @রোবটিক্সগুরুজী
      @রোবটিক্সগুরুজী 2 года назад

      @@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
      @ShuvangkarDas  2 года назад +1

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

    • @রোবটিক্সগুরুজী
      @রোবটিক্সগুরুজী 2 года назад +1

      @@ShuvangkarDas Thanks a lot bro. 🙏

  • @takiyashir8712
    @takiyashir8712 Год назад

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

    • @ShuvangkarDas
      @ShuvangkarDas  Год назад

      If you want really automated, then write python script.

  • @ewezungim6541
    @ewezungim6541 Год назад

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

  • @dhyeyshah6732
    @dhyeyshah6732 2 года назад +1

    Great one, thanks !

  • @trushti_1375
    @trushti_1375 Год назад

    Any idea how to use PS2 keyboard with esp

  • @Omhange
    @Omhange 2 года назад

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

  • @only4music725
    @only4music725 Год назад

    Super helpful, thanks !

  • @rear1117
    @rear1117 2 года назад

    how to add date and time in the export Txt file

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад

      Use RTC with Arduino and generate date time.

  • @seejjordan
    @seejjordan Год назад

    Thanks, really helpful!

  • @Br3Br2Br1
    @Br3Br2Br1 2 года назад +1

    Bravo!!!! Grazie!!!!

  • @BlackCat-yz3oc
    @BlackCat-yz3oc 11 месяцев назад

    Thanks for the information

  • @shubhamkumar-gx5vx
    @shubhamkumar-gx5vx 2 года назад

    How can I save data along with time ?

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад

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

  • @midasama3124
    @midasama3124 8 месяцев назад

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

    • @midasama3124
      @midasama3124 8 месяцев назад

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

  • @abirde696
    @abirde696 Год назад

    This worked for me.

  • @shivajoshi9068
    @shivajoshi9068 8 месяцев назад

    Thank a lot really heplful!

  • @Mohamed-uo8nl
    @Mohamed-uo8nl 2 года назад

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

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад

      What link are you looking for?

    • @Mohamed-uo8nl
      @Mohamed-uo8nl 2 года назад

      @@ShuvangkarDas the application

    • @ShuvangkarDas
      @ShuvangkarDas  2 года назад

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

  • @mancer2161
    @mancer2161 Год назад

    thank you brother !

  • @igedearthanegara5682
    @igedearthanegara5682 Год назад +1

    Helpful

  • @waleedtariq3203
    @waleedtariq3203 3 года назад +2

    Thank you

  • @oliver197637
    @oliver197637 Год назад

    nice thanks 4 that its helpfull

  • @chadalavadasivasanthosh3926
    @chadalavadasivasanthosh3926 Год назад

    very helpful

  • @eliyahomar
    @eliyahomar Год назад

    Thank you so much

  • @soherhatem6776
    @soherhatem6776 3 месяца назад

    Thanks ❤❤

  • @anesunyabadza8058
    @anesunyabadza8058 2 года назад

    well done

  • @arshiafas9361
    @arshiafas9361 5 месяцев назад

    Thank you Bro

  • @carolinahenao4707
    @carolinahenao4707 Год назад

    Thank you!

  • @victorparkhomenko4185
    @victorparkhomenko4185 2 года назад

    Thanks a lot!

  • @alejandroguevara3105
    @alejandroguevara3105 Год назад

    TE AMO

  • @jyotiprakashs8394
    @jyotiprakashs8394 2 года назад +1

    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.

  • @AnwinJose-xr7yl
    @AnwinJose-xr7yl Год назад

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

    • @ShuvangkarDas
      @ShuvangkarDas  Год назад

      You will get my email address in YT channel description

  • @amusklb
    @amusklb 5 месяцев назад

    Thanks!

  • @SkullKrish
    @SkullKrish 2 года назад

    Thank you

  • @AdityaSengupta
    @AdityaSengupta Год назад

    Thank you