Skip to main content

Member Import and Data Issues

Resolve CSV import errors and data quality problems.

Matt Thomas avatar
Written by Matt Thomas
Updated this week

Common import issues and how to resolve them.


Issue 1: "Missing Required Field" Errors

Your CSV must have columns named exactly "name" and "email" (case-insensitive). Check for typos in column headers. Extra columns are allowed but these two are mandatory.


Issue 2: "Invalid Email Format"

Ensure all email addresses are properly formatted (e.g., user@example.com). Remove any rows with blank or malformed emails before importing.


Issue 3: Rows Skipped as Duplicates

If a member with that email already exists, the row is skipped. This is by design to prevent overwriting existing data. If you need to update existing members, edit them directly from the Members page.


Issue 4: Special Characters or Encoding

Save your CSV as UTF-8 to ensure names with accents or special characters import correctly. Some spreadsheet applications default to other encodings that can cause garbled text.


Best Practices

  • Download the sample CSV template before creating your own file.

  • Always export your current members from the Members page as a backup before large imports.

  • Preview the first 10 rows carefully before clicking Import to catch formatting issues early.


Tips

  • Keep your CSV clean — remove empty rows, trailing commas, and extra whitespace.

  • If your import fails partway through, any rows already processed will have been imported. Re-importing the same file is safe because duplicates are skipped.

  • For very large imports (10,000+ members), consider splitting into smaller files to make it easier to identify issues.

Did this answer your question?