Hello,
ChannelAdvisor provides an API which can be used to automate the reports creation, downloading and transferring to your systems. Apart of csv files, it also supports FTP and XML (of course not necessary to be used, it depends of what exactly you want to get from the final reports).
This can be done via a VBA program, which then can customize the reports the way you want and email them to the address you need them. If the only way you don't use Excel is that by default it changes the IDs to scientific notation, don't worry. Excel can be set to accept data in any format and keep this format. Also, there is no any problem with the special characters like commas or quotes (it is possible to include them in a field and this can easily be handled as a CSV field), you must simply know how to process them. On the other hand, Excel has a great advantage compared to OpenOffice: It contains a lot of very strong functions for analysis, it supports much more and better reporting capabilities and charts, and also, it supports a very strong programming language, the VBA, with which you can do many nice things.
A few words about me: I'm developing VBA programs for more than 15 years. Last 3 years I'm working as a developer for some online sellers, so I have a great experience in this field and also I know many software used for online marketplaces.
But space here is very limited...
Looking forward to hear from you,
Kind regards,
Chriskerpini