How was the data for the Parish and School Lists collected?

  • In the process of compiling the School and Parish Lists, we consulted a number of different sources: national Catholic directories, diocesan websites, parish websites, online church directories, etc. When discrepancies were discovered, we deferred to the most local source possible. Consider it our own application of the subsidiarity principle.
  • Even with such robust data collection and research processes, there remains a degree of disorganization and error. This is especially true of rural parishes/schools, merged parishes/schools, or parishes/schools that are undergoing significant transitions. And then there are those parishes whose websites look like they were last updated when Vatican II was still in session...we'll leave it at that.
  • For those deeply immersed in the "Catholic World," these shortcomings are no surprise. Nevertheless, we have taken every measure within our power to correct these deficiencies in order to give you a state-of-the-art data solution. Such measures included hours of manual data point checks; submitting both lists to a national data firm for verification and standardization; and finally, implementing the feedback we've received from our valued customers.

What is your plan for updating the Parish and School Lists?

  • At the present time, we plan on updating these lists on an annual basis. Returning customers will be issued a special discount code to purchase either list for $500 rather than the full retail amount.

How do I import a file from Catholic Data.Co into my organization's database?

  • While we recommend checking with your organization's database manager, we have found the following approach to be the most feasible and minimize the greatest number of potential errors:
  1. Export all of the contacts in your database into an Excel .csv file. Be sure to include a field for the contact's unique identification number as well as the contact's ZIP code.
  2. In the .csv file, insert a new column adjacent to the ZIP code column. In the newly created column, insert the following function: =VALUE(LEFT(text, num_chars)).
    1. text = the respective cell from the ZIP Code column
    2. num_chars = 5
  3. Once you've successfully completed this step, feel free to flash fill the remaining cells in the column.
  4. Next, insert a column adjacent to the column containing the contact's unique identification number. This column will contain the proper diocese based off of the ZIP code.
  5. Pull up your recently purchased Excel file from Catholic Data.Co. In the newly created column, insert the following function: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) 
    1. lookup_value = the cell containing the respective ZIP code for the contact
    2. lookup_array = the entire column containing ZIP codes in the Excel sheet from Catholic Data.co
    3. return_array = the entire column containing dioceses in the Excel sheet from Catholic Data.co
    4. [if_not_found] = "n/a"
    5. [match_mode] = 0
    6. [search_mode] = optional
  6. Once again, feel free to flash fill the remaining cells in the column after completing the prior step. 
  7. Select the both columns containing the contact's unique identification number and the respective diocese. Copy and Paste as Values. This ensures that all of the formulas are removed and you're left with only text.
  8. Depending on the requirements of you database, you may only need the Diocese and Unique Record ID columns. Feel free to delete the other columns.
  9. Finally, save the file as a .csv and upload to your database!

What database/CRMs are compatible with Catholic Data.co?

  • All of Catholic Data.Co's files are .xls files. Once you've purchased your desired file, simply save as a .csv. Be sure to double check the data in the file as .csv files often alter the file's contents.
  • Once saved, as long as your database accepts data in the form of a .csv file, you're good to go!


Contact form