Skip to main content

Notes on CSV File Content with E-list Member Lists (Lyris)

One way to add multiple members to a list is by importing a CSV file. This article goes into some detail about the format of that file.

This article applies to: E-lists (Lyris)


Your data must not include any commas.

Each column must have a column heading.

The EMAILADDR_ column is required. This column should contain email addresses only, with no extra characters.

Good example: pqs665@cornell.edu

Bad example: <pqs665@cornell.edu> or pqs665

The FULLNAME_ column is optional. No commas!

The DATEJOINED_, ADDITIONAL_ and COMMENT_ columns are optional. No commas!

The MEMBERTYPE_ (membership type) column is optional, but only the following values are permitted:

  • normal
  • unsub
  • held
  • private
  • expired
  • held
  • needs-goodbye
  • needs-hello
  • needs-confirm

The SUBTYPE_ (subscription type) column is optional, but only the following values are permitted:

  • mail
  • digest
  • index
  • nomail
  • mimedigest

All other columns should be deleted unless you know exactly what you are doing. Contact the IT Service Desk with any questions.

Was this page helpful?

Your feedback helps improve the site.

Comments?