Correct CSV file format for import

Correct CSV file format for import

When importing subscribers into AppMail, you can do it from text files, csv files or external SQL database.

If you decide to do it from csv files, your csv file has to contain proper header columns and one of the columns must be named email. If you don’t have the email column, the application will not import your file.

Here’s how a proper file should look like:

Email,"First name","Last name","Age"
a@domain.com,John,Doe,25
b@domain.com,Jane,Doe,22
c@domain.com,Joe,Doe,12
d@domain.com,Jen,Doe,15

The first row of the file is considered the file header. If your email list doesn’t contain custom fields for each header column, those custom fields will be created automatically.

    • Related Articles

    • Unable to upload file for importing

      When you try to import your subscribers from a text or csv file, sometimes you might get an error like: Your form has a few errors, please fix them and try again! The file "filename.csv" cannot be uploaded. Only files of these MIME-types are allowed: ...

    • How do I enable command line import for subscribers?

      Importing large CSV files from the web interface, like shown in this article, can be problematic sometimes. This is why we offer an alternative. We offer a way to upload your CSV file which will be queued and then processed by a command line command. ...

    • How to increase PHP upload file size directive

      Many times, trying to upload a file in AppMail for different purposes, like importing a subscriber's CSV list or uploading an email template, you got stuck with this error message: This means that the maximum allowed file size is 2MB (the default for ...

    • How do I import subscribers

      This is a common question and even though the answer is very simple, for a reason or another, seems that many people get confused on how they can achieve this, so I will illustrate this, step by step with images. Step 1: Login as a customer into your ...

    • Enable the file manager for editor files

      Following screenshots show how to enable the file manager so that you can store assets for your campaigns or generally so that they can be accessed from the editor. Step 1: Step 2: Step 3: Step 4: Step 5: That’s it.