importing address list from open office spreadsheet to apple contacts

Question

Level 1

26 points

importing address list from open office spreadsheet to apple contacts

Last year I successfully exported my address list for my Christmas card labels to Apple contacts, by saving the sheet as .csv file then importing it.. Today I tried to repeat it but I seem to have imported all the names but none of the addresses.

I also tried importing just the names to a new group by exporting a sheet with the required names (whose addresses I already had in a different group), with each name on a different row, I was told the .cvs v file was not comma separated, (event when I inserted commas in the original). I can export the page to .csv if I leave the address columns in the spreadsheet page , but the addresses seem to be ignored.

Please advise me.

iMac 21.5″, macOS 10.15

Posted on Dec 19, 2020 4:21 PM

Reply

Answer 1

VikingOSX

Level 10

123,308 points

Dec 21, 2020 11:43 AM in response to mandywr

The CSV needs to be saved as a UTF-8 text file, as shown in this LibreOffice 7.0.4 Save As…

You need to be using data formats that the Contacts application requires, as otherwise, the import will fail. There can be no punctuation in the import fields that duplicates the character used for the CSV separator, or the import will also fail.

Reply

Answer 2

mandywr Author

Level 1

26 points

Dec 21, 2020 3:27 PM in response to VikingOSX

Thank you . In a long spread sheet there were three , I removed these commas and I think it worked.

Reply

Answer 3

VikingOSX

Level 10

123,308 points

Dec 19, 2020 4:26 PM in response to mandywr

Import contacts into Contacts on Mac. Review the address formats that Contacts in Catalina supports for your new Contacts group.

Reply

Answer 4

VikingOSX

Level 10

123,308 points

Dec 21, 2020 7:57 PM in response to mandywr

It is those darn martian punctuation marks that sabotage things… Good. I hope it has worked.

Reply

Answer 5

mandywr Author

Level 1

26 points

Dec 21, 2020 3:15 AM in response to VikingOSX

The problem is not with the label format (viking or otherwise) , but with getting addresses from open office spread sheet to apple contacts. I can save the sheet from open office as a .csv but the .csv is not in a fromat recognised by contacts. It is not comma or tab separated even when I use the filter in open office save as to specify comma separation.

Reply

importing address list from open office spreadsheet to apple contacts

Similar questions