The CSV file must contain a header row that maps the values contained in that column to a corresponding field in the MailUp system. In MailUp there are:
MailUp contains the following special fields, which cannot be modified.
|Field Name||Field ID|
|Mobile phone number's country code||222|
|Mobile phone number||333|
|Complete mobile phone number (country code + number)||444|
A file to be imported shall contain a header row and one record for each recipient to be imported. The '|' (pipe) symbol is used as a separator and each row must contain exactly the same number of columns.
Basically, as soon as you respect the rules above, you are free to choose the type, order and number of columns you prefer. In this paragraph you can have a look at some examples,
Let's say that your CSV file contains these columns:
|Date of Birth||3||10||1978-03-16|
*MailUp personal field ID or special field ID (refer to previous table for special fields)
This is an example of the file content
1|2|10|9|8|111|6 Peter|Smith|1978-03-16|M|UKfirstname.lastname@example.org|London Maria|Rossi|1963-12-21|F|ITemail@example.com|Roma ...
For international prefix and mobile number you can either use two separate fields or a single field
1|2|10|9|8|222|333|6 Peter|Smith|1978-03-16|M|UK|123000000|123000000|London ...
1|2|10|9|8|444|6 Peter|Smith|1978-03-16|M|UK|+44123000000|London ...
Mixing the scenarios described above, here is an example with both email and SMS