CSV Files

AddressBox can import csv text files. These are text files that contain one contact entry per line. The fields are separated by a comma, a tab or some other character. Most spreadsheet and database programs can export files in this format.

Preparation

You can import a file into an existing data source or into a new one. If you would like to create a new data source with just the imported data then it is often best to do so before using the import function. This allows you to also create the fields (best done in the list view) of the right type.

If you have separate city/street/country fields in the file, it would be best to create a proper address field first. This makes it easy to properly arrange the imported data.

Import settings

When selecting the excel file in the open dialog, you can specify whether the first row in the file should be used to name each imported column/field. You can also select the delimiter and the encoding of the text file.

The delimiter is the character that separates the fields in each line. If AddressBox seems to only find a single field in your file, then you probably selected the wrong delimiter. In most cases it is either a comma or a tab.

The encoding is the format in which special characters are saved. If some characters (like umlauts) are not imported correctly, then changing the encoding will fix the issue in most cases.

Assign Fields

In the last step you assign the fields from your file to the ones you have in AddressBox. Fields created while importing will default to be plain text fields. In most cases it is best to manually create the required fields before importing the data. This will give you more control over the type and format of the fields in AddressBox.

You can create a new group for the imported contacts. This can be especially helpful if you add the contacts to an already existing data source and do not want to lose track of the imported records.

AddressBox can avoid importing contacts that are already in the data source. Once you enable the Avoid Duplicates checkbox, you can select an imported field to check against. If any of the existing contacts have a field with the same data as the imported field, the contact will not be imported.