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 strongly believes your congregation and member data is your own, and you should be able to Import and Export your data as you wish. We also believe it is fair and right to allow data exchange between other scheduling programs.

Therefore, JW Scheduler supports Importing and Exporting data into a variety of common file formats.

JW Scheduler Import Congregation from CSV

Import from a CSV file

  • Note: If you have already created a congregation, it is best to first Delete the congregation before importing from CSV File. However it is also possible to import data into an existing congregation. Please see the Import Data into an Existing Congregation sub-heading below.
  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 fields described in CSV Format below
  5. Open JW Scheduler
  6. At Getting Started, click Import Congregation from CSV file
  7. Click Import
  8. Your data will now import.
  9. Once the Import is completed, the import log will appear. This shows what data was imported into JW Scheduler as well as any data that could not be imported.
  10. Please carefully check the Import Log, and click Save Import Log if necessary.
    • Note: When you click Save Import Log, you will be asked where to save this file to. Select a location on your computer, e.g. Documents.
  11. If there are any major problems, see Import Problems
JW Scheduler Import Members from Majestic KHS Hourglass TSWin and CSV Import Log

Import Data into an Existing Congregation

It is best to Import data when first creating a new Congregation in JW Scheduler.

However you can import the following data into an existing JW Scheduler congregation:

Note: If the First name and Last name exactly match an existing member, the member will be merged. Otherwise a new member will be created.

Sample CSV file

JW Scheduler Import Congregation from CSV file Sample

CSV Format

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.

Additional Help

Scroll to Top