Import from CSV

JW Scheduler can import member data from a CSV (comma separated value) file. This allows you to use import data from lots of sources, such as Excel Spreadsheet, into JW Scheduler.

  • Note: CSV files must be in the format listed below. You cannot import random CSV files into JW Scheduler.
JW Scheduler Import Congregation from CSV

Import from a CSV file

  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the fields
  3. Ensure your CSV file is saved with the extension .csv
  4. Ensure your CSV file only contains Supported CSV Fields below
  5. If you have already created a Congregation in JW Scheduler: See Import Members into an “existing” JW Scheduler congregation
  6. If you have not already created a JW Scheduler Congregation: When you first open JW Scheduler, click Import Congregation from CSV file
  7. Click Import
  • Note: If you have accidently already created a JW Scheduler congregation, please Delete the congregation before you Import from CSV file.

Sample CSV file

JW Scheduler Import Congregation from CSV file Sample

Supported CSV Fields

JW Scheduler currently supports the following Member fields only. The fields must be named exactly as below (not case sensitive)

  • Name
  • FirstName
  • LastName
  • Address
  • Email
  • Phone
  • PhoneHome
  • PhoneCell
  • PhoneWork
  • Gender
  • Male
  • Female
  • Privilege
  • Elder
  • MS
  • Publisher
  • UBP
  • RP
  • AP
  • SP
  • RegularPioneer
  • AuxiliaryPioneer
  • SpecialPioneer
  • Missionary
  • Group
  • Anointed
  • Disfellowshipped
  • ElderlyInfirm
  • Child
  • DPACard
  • RPNumber
  • Notes
  • DOB
  • DateOfBirth
  • DateOfBaptism
  • DateOfDPA
  • DateOfRP
  • DateOfDisfellowshipped
  • DateOfFirstMonth

Problems Importing CSV files

If you have problems Importing from CSV:

  1. Ensure your CSV file is comma delimited
  2. Ensure your CSV file includes a HEADER row which describes the fields
  3. Ensure your CSV file is saved with the extension .csv
  4. Ensure your CSV file only contains Supported CSV Fields
  5. If you have done all of the above and still have problems, please Contact Us for assistance. Please include a copy of the CSV file and screenshots of the steps you are performing, and any errors.
Scroll to Top