That may not work if the CSV is escaped/quoted (e.g. because the data contains commas).
Or you could use our Easy Data Transform software. It pretty much handles all that horrible CSV stuff for you. ;0)
Slightly on-topic: I found what LibreOffice Calc has a decent input wizard which most of the time works and good enough.