Hi,
Depends what you have access to. If I was doing personally I would just use send via email as CSV to a mailbox and use Power Automate as it has all the MS-based functions to do it all - trigger a flow on email with attachment; make changes to the data; convert to other formats and whatever you want and then store file to SharePoint. It’s all in pretty straight-forward UI-driven automation; with logging and so on.