Go Down

Topic: arduino to excel (Read 1 time) previous topic - next topic

heixin

Jan 16, 2014, 02:41 am Last Edit: Jan 17, 2014, 04:38 am by heixin Reason: 1
Hi!

Im  searching for a simple way to get data from the Arduino into Excel for later processing of the data via Zigbee

any suggestion will be appreciate.
Thanks!!

mrburnette

#1
Jan 16, 2014, 03:06 am Last Edit: Jan 16, 2014, 03:51 am by mrburnette Reason: 1
http://forum.arduino.cc/index.php?topic=135623.0

Yep... Too easy.

Ray

Edit: You can do keyboard HID with the Leonardo if you do not want to go the V-USB route.

Nick_Pyner

#2
Jan 16, 2014, 04:29 am Last Edit: Jan 19, 2014, 02:41 am by Nick_Pyner Reason: 1
You surely can't get it any simpler than using PLX-DAQ.  This is an Excel macro that enables you to send your data direct to an open Excel sheet. It is simply a matter of properly formatting data that you would normally see on the serial monitor. Date/time stamping is done in Excel, no need for a clock on the Arduino. It can also do live graphs in Excel, and it is free!

Check here               http://forum.arduino.cc/index.php?topic=211274.0

You could save the data locally (regular log on sd for example ) in a txt file and seperate the data with commas. Rename the file to .csv and just open with excel.

PaulS

Quote
Rename the file to .csv and just open with excel.

There is nothing magic about the txt extension, or the csv extension. The SD library doesn't care, so save a step and name it .csv to start with.

Go Up