Great point, there are so many gotchas with CSV.
Could the app handle this one?
"First Name","Last Name","Address","Town","Postcode"
David,O'Leary,"12 Acacia Avenue",London,NW5 3DF
June,Robinson,"14, Abbey Court","Putney",SW6 4FG
Greg,Hampton,"",,
Stephen,James,"""Dunroamin"" 45 Bridge Street",Bristol,BS2 6TG
Daisy,Smith,"Flat 6,
Porchester Court,
24 Dragon Road",Newcastle,NE3 4FG
(i.e. some fields enclosed in speechmarks and some not, commas in text, blank values, escaped speechmarks, carriage returns)edit: I tried it with the csvbox.io demo - it seemed to deal with it ok!