There is documentation about how to import Contacts into the Roundcube address books from CSV files: https://docs.roundcube.net/doc/help/1.1/en_US/addressbook/importexport.html

Unfortunately, that documentation does not come with a description of the columns supported.

I had a look at the source:

From that you can see, that the import from GMail and from Outlook is supported via CSV files.

So I tried an export with GMail (see https://support.google.com/mail/answer/1069522?hl=de, over the old interface of the GMail address book you can export via CSV).

Here is a sample CSV file, that should work:

First Name,Middle Name,Last Name,Title,Suffix,Initials,Web Page,Gender,Birthday,Anniversary,Location,Language,Internet Free Busy,Notes,E-mail Address,E-mail 2 Address,E-mail 3 Address,Primary Phone,Home Phone,Home Phone 2,Mobile Phone,Pager,Home Fax,Home Address,Home Street,Home Street 2,Home Street 3,Home Address PO Box,Home City,Home State,Home Postal Code,Home Country,Spouse,Children,Manager's Name,Assistant's Name,Referred By,Company Main Phone,Business Phone,Business Phone 2,Business Fax,Assistant's Phone,Company,Job Title,Department,Office Location,Organizational ID Number,Profession,Account,Business Address,Business Street,Business Street 2,Business Street 3,Business Address PO Box,Business City,Business State,Business Postal Code,Business Country,Other Phone,Other Fax,Other Address,Other Street,Other Street 2,Other Street 3,Other Address PO Box,Other City,Other State,Other Postal Code,Other Country,Callback,Car Phone,ISDN,Radio Phone,TTY/TDD Phone,Telex,User 1,User 2,User 3,User 4,Keywords,Mileage,Hobby,Billing Information,Directory Server,Sensitivity,Priority,Private,Categories
Max,,Mustermann,Herr,,,,male,,,,,,,test@example.org,,,,,,,,,,Beispielweg 2,,,,Beispielhausen,,12345,Deutschland,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Eva,,Musterfrau,Frau,,,,female,27.03.1970,,,,,,example@example.org,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

 

Import Contacts via CSV into Roundcube
Tagged on: