The Arduino IDE's serial monitor is just one of many tools that can open a serial port and collect information from it. The first step is to make sure the data you are writing to the Serial object in the Arduino is in a format suitable for importing into Excel.
![Mega Mega](/uploads/1/2/5/6/125614452/372666932.jpg)
Separate multiple values on one line with a comma ',' or tab ' t' character. If you are running windows, you can often just use the built-in type command from a command prompt to write the serial port to a file: type COM4 log.txt (Assuming the Arduino is on COM4 and you want to write the data to a file called log.txt.) If you're on a Mac, open the Terminal app and type: screen -L /dev/tty.usbmodem14 (Assuming your Arduino is on serial port named tty.usbmodem1441335 and your port speed is 9600 bps.) The session will be written to a file called screenlog.0. Then you can open the text/log file in Excel. If you rename it to end in.csv, that may also help Excel recognize it as tabular data.
> VBA Communication with Arduino; Print. I'm trying to control an Arduino via Excel VBA using the MSCOMM control The following sketch accepts serial input, and controls the brightness of a led It works fine when data is entered via a serial monitor.