Go Down

Topic: Arduino to Excel How do I do it? (Read 19820 times) previous topic - next topic

Funhough

Dec 29, 2007, 10:19 pm Last Edit: Dec 29, 2007, 10:19 pm by Funhough Reason: 1
Hi!

Im rather new to the Arduino plattform and searching for a simple way to get data from the Arduino into Excel for later processing of the data... How do I do it?

Every suggestion welcomed. I´ve search on the web but so far I haven´t found anything...just a few comment about reading serial and pass it that way but exactly how do I do it?. In the Arduino software and in Excel. Or is it easier to plot it in Processing? ...as in the tutorial files







mem

One way is to get the data into a comma separated file (CSV) on the machine running Excel and import that file into Excel.

To send CSV data using arduino serial, do something like the following:

Serial.print(Value1, DEC);  // send the first value  
Serial.print(",");                    // separated by a comma
Serial.print(Value2, DEC);   // other values get sent as above  
Serial.print(",");
Serial.print(Value3, DEC);    
Serial.println();                    // print a linefeed character      
   
You can receive the serial data using a terminal program that can save the received data as a file (the file extension should be .csv so excel recognizes it).

Google can give you more detailed help using search terms such as CSV excel import.

Good luck

vanneop

Check also

http://www.selmaware.com/selmaDAQ/home.htm

Funhough

Hi!
Thanks for the response. I will try both the code and SELMADAQ shareware. The CSV looks promising I will send only 10 values at each timepoint so its not a huge amount of data. 288 timepoints...Piece of cake...

Would Processing be capable of saving the data in CSV format? I know how to read serial in Processing but not how to save files ... Becauce then I could plot it in Processing and save the file for later viewing...?


mem

#4
Jan 06, 2008, 08:45 pm Last Edit: Jan 06, 2008, 08:45 pm by mem Reason: 1
have a look at the createWriter() function:   http://processing.org/reference/createWriter_.html

Funhough

Great help with the Processing CreateWrite() function...works great! Open in Excel when you save it as .csv file...Nice. Simple and I think... what I wanted. Now back to work...


mem

Good to hear that you have it working. If you can find the time, you may want to do a brief write-up on sending CSV data to excel for the 'interfacing with software' section of the playground so others can follow your example.

Funhough

I will do that when I have the whole project finished. Im taking pictures (hardwarestuff) and saving code, both errors and the code that is functional. That is one of the fun things with this... show others (ask...) and get feedback. Redo and do the finetunings....

Well you all know... Ill keep you posted!

"That is no Arduino,  that is a space station...fully operational..." :)

sswcharlie

Hi

Did you get to post the final result of placing info from Ardinuo into .csv and onto Excel ?

Thanks

Charlie

MikMo

GoBetwino can put data directly into excell sheets for yoiu.

www.mikmo.dk/gobetwino.html

sswcharlie

Hi and WOW!

That is a great program will get it.

Thanks

Charlie

kiltjim

I've been using this:
http://www.parallax.com/ProductInfo/Microcontrollers/PLXDAQDataAcquisitiontool/tabid/393/Default.aspx

It works pretty well.  If you know VBA you can make it do neat stuff.

Haven't used Gobetwino, but I will give that one a shot.

mstadtler

I just used http://www.aggsoft.com/serial-data-logger

and got data to excel to charts in about 10 min

Go Up