I want to extract data from two sensors using Coolterm and plot them in excel.
I can see the data line by line as below in the serial monitor and Coolterm:
I'm not very familiar with coolterm, but have a look to see if there is a setting that may affect the handling of CR & LF. It may be that coolterm is translating them.
I would have suggested the "Handle CR as real Carriage Return" option but you don't seem to have that!
I'm guessing that from the way the dialog looks in your screenshot, that maybe you are on a Linux system? I wonder if that's the issue as I know Linux and Windows have different ideas about CR & LF.
I assume that you are sending out a CR & LF in your sketch?