Collecting data from Serial Monitor

Hello,

I have a Arduino collecting sensor readings. I need to take the numbers given and have them graph preferably on a spreadsheet to see data overtime.

An example of the output I get in Serial Monitor is:
Red value = xxx Blue value = xxx Green value xxx

Thanks for the help!

See this thread

Have used it here with superb results.

Welcome to the forum

A good start would be to output the data in a format that is more easily used by a spreadsheet, such as a comma separated (CSV) format

Are you prepared to copy the data from the Serial monitor and paste it into a spreadsheet or are you looking for a more automatic method ? If the latter then consider using a terminal program such as Coolterm which can save received data to a file

Which version of the IDE are you using ?

Hello! I have thought about CSV and that would work, although I would like it to be automated.

So would Coolterm automatically put data into a CSV for me?

I am using version 2.0.4 of IDE.

No, it is down to you to send CSV formatted data to the terminal. Also read post #2 again, and check Excel dataStreamer.

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.