How should I organize my import file for importing?

The address file is imported into MAILINGWORK in CSV format. If your file is still an Excel file, you can save it as a CSV file. When saving, select the format ‘csv (delimiter-separated)’. If you are using a Mac, make sure to save the file as “CSV-Windows”, not in Mac format.

A CSV file is an ASCII file where fields are separated by a specified field delimiter. You can choose the delimiter to use (e.g., comma, semicolon, tab). The import file may also contain text delimiters, but this is optional. Note: Do not use a delimiter that appears in your content.

Structure: The first row of the table should contain the field names (e.g., Last Name, Email, Address). Check your file: Are the contents correctly distributed in the appropriate columns? Columns with irrelevant information can be deleted. Ensure your data is not spread across multiple tables (worksheets) in the document.

Example settings for a CSV file:

Character set: UTF-8 (Unicode)* or ISO-8859-1 (Western European)

Field delimiter: ;

Text delimiter: “

• Related Articles

• How can file attachments be personalized?

  First, upload all versions of the attachment, either to your own server or to our webspace (Modules -> Webspace). For example, if you want to use different attachments for target groups by state, the files could be named Bayern.pdf, Hessen.pdf, ...

• How do I import recipients?

  A complete guide for the import process – can be found in the documentation.

• What should I check after importing subscribers?

  After a successful import, MAILINGWORK offers various options to clean your subscriber data under Subscribers > Clean Lists. Key features include removing invalid addresses and duplicate checks. Remove Invalid Addresses Invalid addresses occur when ...

• How can I attach a file to my e-mail?

  Upload the files for the attachment of your email under the Modules tab in the Media administration or Webspace. After that, in your email, go to the Attachments tab, click on Add Attachment, and attach the desired file to your mailing. You also have ...

• Does MAILNGWORK support interfaces for easy address transfer?

  Yes, MAILINGWORK offers several ways to transfer address data easily and efficiently, such as between your CRM system and MAILINGWORK. You can use our general web service interface (API) for this purpose. There are three available methods: 1. Request ...