When you first save a CSV in Open Office, you have to do a SAVE AS, Select TEXT CSV, and be sure to CHECK "Edit filter Settings"....
Click Keep Current Format, Set your Field Delimiter to the COMMA, and Text Delimiter to DOUBLE QUOTE
I believe the defaults are TAB, which is why your import failed.
Bookmarks