Hello,
only one question: live data from CSV is appended to the existing CSV or it is overwrited each time the data is sent? In other words, the CSV only contains one line on each data update?
If so, it's a really simple project that can be done in no more than 2 hours. But, I don't think excel is the best tool to do it, as it has to manage some timers (not possible to do it with events) to check changes on CSV. Maybe a .NET program can accomplish this task far better.
Anyway, it's doable with excel, so, if you agree, we can talk further.
Thanks for reading!