Text Import dialog, with Comma selected as the separator and double quotation mark (“) as the text delimiter. If you do not select Text CSV as the file type when opening the file, the document opens in Writer, not Calc. Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Starting_opening_saving

