uploading sensor data to e.g. Excel

Other Hardware Sensors
1

Hi Everyone

I'm a total newcomer with an interest in data logging but with no recent programming experience. I'm seeing incoming sensor data on the serial monitor but I can't find any advice on importing it to e.g. Excel or a similar graphing program.

Can anyone point me in the right direction?

Thanks

2

Search CSV

Look at the Realterm serial monitor and saving data.
http://realterm.sourceforge.net

3

See Capture in Realterm.

Data Logging

Using Capture and SendFile from the commandline, you can log data and control intruments directly from the commandline, without extra software.

realterm.exe senddly=10000 sendrep=0 sendfile=commands.txt capture=results.txt

This will send "commands.txt" endlessly, with a 10sec pause between sends, and capture the replies to "results.txt". This is all you need to do to turn (say) and RS232 multimeter into a datalogger.

4

I have written a excel macro that uses the serial port to get data directly. Another solution would be to write a Pc side program in processing to do the same thing

5

The following link will be useful for you too:

6

If you use an Arduino leonardo you can have it type directly into the spread sheet by making it look like an external keyboard.