All columns to be imported must be formatted as text in the Excel sheet. If this is not done, you risk that data will not be imported into 24SevenOffice.
| Contacts or Private Customers | |
| Import Name | Explanation |
| Contact First Name | first name |
| Contact Last Name | Surname |
| Contact Name | First name Last name (This is if you do not separate first name / Last name in each separate column) |
| Contact Role Phone | Phone Job |
| Contact Role Mail | Email Job |
| Contact Role Mobile | Mobile Phone Jobs |
| ContactRoleFax | Fax Job |
| Contact Role Position | Position (Role) Job |
| ContactDateRegistrered | The date the contact is registered. Format: day of year (31.01.2008) |
| ContactDateChanged | The date of contact was last changed. Format: day of year (31.01.2008) |
| ContactDateOfBirth | date of birth |
| ContactAdressStreet | Address |
| ContactAdressPostCode | zip code |
| ContactAdressPostArea | City |
| ContactAddress | visiting address |
| Contact Country | Country |
| Contact Phone | Telephone Private |
| ContactPhone2 | Telephone Private 2 |
| Contact Mail | Email Private |
| ContactEmail2 | Email Private 2 |
| ContactEmail3 | Email Private 3 |
| Contact Mobile | Mobile phone Private |
| ContactMobile2 | Mobile Phone Private 2 |
| ContactFax | Fax Private |
| ContactIsConsumer | Defines whether the contact is private or not. Set to 1 by private customer. If the import consists of both private customers and contacts, this field is set to 1 for private customers and blank for regular contacts. |
| ContactIsEmployee | Defines whether or not the contact is employed. Set to 1 when employed, and 0 = not employed. |
| ContactCustomerId | Private Customer Number (Can be specified. If you do not specify this, the customer is assigned the next available customer number in the customer number series) |
| ContactInvoiceEmail | Invoice email address. Only possible to import to private customers. Therefore, you must also import customer number using ContactCustomerId for this field to update. |
| Contact Nickname | nicknames |
| Contact Note | note |
| ContactOwner | Owner / Responsible for Contact (Employed in your company) |
| ContactRoleCompanyId | Customer number to which the contact may be linked. |