Check the guidelines below to ensure the platform will recognize your data when you Import Subscribers into a list.
File Format
Make sure you use one of the supported file formats:
-
.xlsx
-
.xls
-
.csv(,)
-
.csv(;)
You can always download a sample file by clicking Subscribers > List > List Name > Import and paste your data inside the newly-downloaded file.
File Content
Make sure you enter the data in the file correctly:
- Include no blank cells or rows in between your data. The platform will recognize them as the end of the file.
- Include all your data in the first sheet. Additional sheets will not be detected.
- Enter every field with subscribers' data (e.g. name, number, e.t.c.) only once. Multiple records for the same destinations (mobile/email) will be detected and excluded automatically from your import.
- Delete all math functions, formulas or filters. Especially if you exported your file from another system, make sure you select all data inside the file (Ctrl + A) and select Clear > Clear Formats from the Excel toolbar.
- Keep the column with the mobile phone numbers first (if there is one).
- You should include at least one destination (email/mobile) for each subscriber. Otherwise, the subscriber will not be imported.
- Pay attention when you match columns of your import file to the fields in your Apifon list. The platform will automatically identify some of the columns for you.
For example, the column that contains email addresses will match the required Email column.