Is there a simple way to export data from a serial monitor to an excel sheet? Maybe some way to directly send data from the program output to a software/excel.
Do a Google search for Excel Data Streamer
Write your data to the 'serial monitor' in csv format.
Then, instead of the serial monitor use a 'terminal with logging functionalities' and you are done.
Or write your own 'serial logger' if you have some specific need ( is nothing more that a program that listen on a serial port and writes to a text file )
maybe worth having a look at plx-daq-version-2
Excel Data Streamer is an Add-in for Office 365 (Now called Microsoft 365).
If you have Microsoft 365 you need to go to 'options' to add it.
Click on the 'Go' button at the bottom to get to the next screen, then tick 'Microsoft Data Streamer for Excel'.
You then get a new entry on the menu bar, called 'Data Streamer'.
Select 'Data Streamer', then you can select which COM port you want to connect to.
I've got 4 COM ports to chose from in the example below, the entries shown as 'USB Serial Device' are Arduino Uno R4s.
You then just send your data to the serial output, and it will appear in your spreadsheet.
