Importing contacts from an Open Office spreadsheet
Select the .CSV format when you save your document. Select the semicolon as a field separator and do not specify anything as text separator (leave it blank or delete the content if something is written there).