ResourcesKnowledge Base

Manual recipient import

How to manually import subscriber lists from Excel, CSV or TXT files ...

079import.PNGBefore you start importing, first open the list of recipients to which the new recipients are to be bulk imported - either by clicking on their name or the Recipients button in the appropriate row for a specific list. When you open the list, you click the Import button and the first part of the import guide appears in a new window.

Import Wizard

083import1EN.PNGSupported file formats for mailing list import are CSV, XLS, XLSX, ODS, and TXT. Import can be used not only to import fresh mailing list data but to update existing lists and recipient data as well.

Use the Browse or Choose Files button to select a file to import from your computer or use drag & drop to drop the selected file into the import dialog. The import will progress to the next step.

The next part of the import shows a preview of the imported data (only the first 10 lines).

Import step 2

Although the system tries to automatically recognize all the parameters of your imported file, it is sometimes necessary, depending on the format of the imported file (CSV,TXT), to manually change the parameters so that the imported data corresponds to reality (eg. select character encoding, separator character, etc.).

In case your imported file contains a leading row with column names you can select to skip 1st record to avoid the results being skewed by an errorneous record.

In case you are only importing a list of mobile numbers to be used with SMS campaigns it's necessary to select Only a list of mobile numbers without emails.

For each column to be imported, you must select the appropriate field type from the drop-down. Columns that have not been assigned fields will not be imported. Once you have completed assigning the corresponding fields to the columns, click Finish to import your data into the system. In case you have selected a wrong file you can click the Upload again button to select another file for upload.

When the import is complete, an import summary is displayed. It will show you how many records were imported, how many were new, duplicate,  invalid or blocked.

085import3EN.PNG

Click the Close button to close the import wizard window. Your recipient list will contain the newly imported data.