Download CRA Charity Listing CSV and Filter It in Excel

A step-by-step tutorial to download the CRA Charity Listing to CSV and filter it in excel, that you can easily follow along. Here’s your full tutorial:

How to Download the CRA Charity Listing CSV and Filter It in Excel

The Canada Revenue Agency (CRA) Charity Listings are available online as a searchable database. You can also download the complete CSV file of all registered charities in Canada for your own analysis. Here’s how you can download it and filter it using Microsoft Excel.

Step 1: Go to the CRA Charity Listings Website

1. Open your web browser and go to: CRA Charities Listings
2. Scroll down to find the Charities Listings Downloadable Data section.

Step 2: Download the CSV File

1. You will see options for CSV format and sometimes XML.
2. Click the CSV file link (it may be large, sometimes 100MB+).
3. The file will be downloaded to your computer (usually in the Downloads folder).

Tip: The file name is usually something like Charities.csv or RegisteredCharities.csv.

Step 3: Open the File in Excel

1. Locate the downloaded file in your computer.
2. Right-click – Select Open With – Microsoft Excel.
3. If Excel warns about formatting (since it’s a CSV), just click Yes/Open.

Step 4: Review the Columns

The CSV file will contain multiple columns, such as:

• BN/Registration Number
• Charity Name
• Status (Registered, Revoked, etc.)
• Category (Education, Religion, Health, etc.)
• City / Province

Step 5: Apply Filters in Excel

1. Click anywhere inside the data.
2. Go to the top menu – Data – Filter.
3. Little dropdown arrows will appear at the top of each column.

Step 6: Filter the Data

• To filter by Province: Click the arrow in the “Province” column – select only the province you want (e.g., Ontario).
• To filter by Charity Status: Click the arrow in the “Status” column – choose “Registered” to see only active charities.
• To filter by Category: Use the dropdown in the “Category” column to focus on specific causes (e.g., Health, Education).

Step 7: Save Your Filtered File

1. Once you have applied filters, go to File – Save As.
2. Choose a new name like Charities_Filtered.xlsx.
3. Save it as an Excel Workbook (.xlsx) so your filters remain active.

People Also Read: CRA Business Registration Online Process

Example Use Cases

• Find only registered charities in Ontario.
• Create a list of health-related charities across Canada.
• Filter out revoked charities to keep only valid ones.