Formats supported for import
You can import files in XLS format. The XLS format is also often marked as Excel 1997 to 2003 (PC) or Excel 92-2004 (Mac).
The system doesn’t support the XLSX file format. Simply save your file as an XLS file.
CSV (comma separated values)
You can also import files in CSV format. The separator (e.g. semicolon, comma, tab stop) and encoding are automatically detected during the import process.
- Go to Subscribers and select Add New Receiver in the top right
- Select the recipient list or create a new one
- Click on Import and follow the Import Wizard
- The last step of the import process allocates the custom fields. You need to tell our system, for example, which record includes the first or last name. The first three records are each displayed. To assign the fields use the drop-down box to the right of each record. The e-mail address is automatically recognized and assigned.
- You can then start the import.
Why weren’t all of the records imported?
The import automatically checks for duplicates and syntactically incorrect addresses. If your recipient list contains fewer recipients than the import file, the problem could either be duplicate or incorrect addresses. The Import Report provides information on the message system in your account.
Exporting subscribers from popular programs / clients
- Click the File tab.
- Click Options.
- Click Advanced.
- Under Export, click Export.
- In the Import and Export Wizard, click Export to a file, and then click Next.
- Under Create a file of type, click the type Comma Separated Values (Windows), and then click Next.
- Under Select folder to export from, select the contact folder that you want to export, and then click Next.
- Under Save exported file as, click Browse, select a destination folder, and in the File name box, type a name for the file.
- Click OK.
- In the Export to a File dialog box, click Next.
- Click Finish.
- In Outlook, on the File menu, click Import and Export.
- Click Export to a file, and then click Next.
- Click Comma Separated Value (Windows), and then click Next.
- In the folder list, click the contacts folder you want to export, and then click Next.
- Choose a location on your computer to temporarily save the file.
- Type a name for the exported file, and then click OK.
- Click Next.
- To add or remove fields to determine the way the contact information is saved in the new imported file, click Map Custom Fields.
- Click Finish.
- In the top menu bar click on the address book. The address book opens up.
- In your address book’s menu bar click on Tools and then on Export.
- Select where you want to save the export file.
- Select CSV, or comma separated, as file type.
- Enter a file name and then click Save.
- You now have a .CSV format file.
Mac address book
- Open the address book and select the group you want to export.
- Click File > Export > Export Group vCard
- Save the file to your desktop.
- Go to http://labs.brotherli.ch/vcfconvert/
- Select the vCard file on your computer.
- Select CSV as the format, and semicolon as the separator.
- Encoding should be UTF-8.
- Activate “vCards with e-mail only” if you only want to import e-mail addresses and no personal details, e.g. first and last name.
- Now click on convert.
Googlemail / Gmail
- Sign in to Gmail.
- Click Gmail at the top-left corner of your Gmail page, then choose Contacts.
- From the More actions drop-down menu, select Export….
- Choose whether to export all contacts or only one group.
- Use the Outlook CSV option when exporting your list from Google.
- Click Export.
- Choose Save to Disk then click OK.
- Select a location to save your file, and click OK.
- You can now import your CSV file into Clever Elements.