Just my personal take - but I would open the CSV in an intermediate app, clean it up and “prepare” it for import into Tbx. By this I mean - name the columns properly, ensure that all the data is correctly entered, deal with special characters, and populate Comments, Tags, and other similar Attribute values.
I would consider not that you have to do this task manually every day, but that by daily monitoring of the files you allow INTO your Tbx project, you are potentially saving time down the road in dealing with Note proliferation. This is what I do, and it works well for me.