“CSV Studio demo - try the online visual editor”
I was struggling to clean up a CSV file for import into tadabase.
I found this website. It helped me with my issues.
It looks to be free at the moment.
PS : I have no affiliation to this site - I found it useful and am sharing it with the community in the hope that it may be of value to someone.