Below is an example of how a CSV might look in a text editor. Notice there are commas (,) separating each column. The first row contains the heading for each column, and the rows below that contain the field values (or records).
|Name||Email Address||Mobile Number|
If you have a large CSV file (over 10MB), you could run into problems trying to upload it through the browser. If your file exceeds this size, we recommend splitting it into smaller chunks before importing.
If your list contains non-English characters, make sure you save the file in UTF-8 format before running the import. Most text editors (e.g. Notepad, TextEdit) offer encoding options when you save the file.
Many exports include additional columns with titles and empty columns. For usability purposes, we recommend deleting these columns, and any others you’re not wanting to import in to the system.
Check that you are using the correct date format. We support:
Upon running the import script, you can tell the system which format the file contains.
Ensuring that each field is spelt correctly is critical for a successful import. For example, if you’ve created a People Category called ‘Church Members’, having an entry labeled ‘Church Member’, or ‘Members’ in the import file will not be matched accordingly. For this reason, make sure the term and its spelling in both the import file and the account are an exact match.
Depending on what kind of import you’re running through the system (there are separate import scripts for People and Financial data, for example), there may be other more specific requirements to consider. For example, when importing people data through the People import script, there is a specific way to import family relationships and groups. Be sure to read through the corresponding import articles to ensure you’ve added incorrect formatting.
We highly recommend performing a test import before running large amounts of data through the system. This can be done by working with a sample of your import data – trialing the first 20 or so records. Running a test helps ensure that any changes or errors needing to be fixed can be performed before the import is complete.
Need us to review your import file?
Our customer service team can review your import file prior to you performing the import. Feel free to contact us at any time.