Canadian Radio-television and Telecommunications Commission (CRTC)
Symbol of the Government of Canada

How to Use the National Do Not Call List

Once you have successfully registered with the National Do Not Call List operator, you may access the subscription functions of the Web site. In order to use the National DNCL, you must first purchase or have been given access to a client’s subscription.

Under the heading of “My Account” in the left hand navigation bar, there are two options relating to subscriptions:

Purchase Subscriptions
Allows you to purchase access to the National DNCL.
Access Subscriptions
Provides you with access along with various options relating to subscriptions you have either purchased or have been given access to.

How to Purchase the National DNCL

After signing in, select “Purchase Subscriptions” from the left hand navigation bar. From this page you can select one of the two types of subscriptions offered:

Download Subscription - provides you with the option to purchase a new download subscription for a 1, 3, 6 or 12-month period. You can subscribe to a single area code, multiple area codes, or all Canadian area codes. Download subscriptions are payable via credit card or via electronic funds transfer (EFT) directly from your bank account. For new download subscriptions, payments made via credit card provide you with immediate access to the download subscription, while payments made via EFT are subject to a 5-business day hold.

To purchase a new download subscription:

  1. Select Download Subscription, click “Continue”;
  2. Read and accept the terms and conditions of the subscription (you may also choose to print the terms and conditions for your records);
  3. Choose your selected subscription options;
    1. Duration for your subscription in 1,3,6, or 12 month increments;
    2. Enter an optional description for your subscription. For example this could be the name of the marketing campaign, or the name of the marketing territory;
    3. Select the individual area codes for the subscription or click All Canada;
  4. Click “Continue”;
  5. Enter a download contact if desired – if you do not provide a download contact the system will assume that the primary account manager is the download contact;
  6. Confirm your purchase by ensuring your selected subscription options are correct, and select your desired payment option:
    1. Credit Card – if you elect to pay by credit card you will be asked to select your credit card type, enter in your credit card number and expiry date. Click “Complete Payment” to submit your payment for authorization. If the payment authorization is successful, you will be taken to a Purchase Confirmation page where you can print out a copy of the transaction for your records. Additionally the account managers and the download contact will receive an e-mail with this information.
    2. Electronic Funds Transfer – if you elect to pay by EFT you will be asked to agree to a Pre-Authorized Debit (PAD) agreement before you can proceed. Once you have agreed to the PAD you are requested to contact the Centre of Excellence at the telephone number provided. To complete the transaction you will have to provide the operator with the Subscription Access Number and Transaction ID information listed on this page along with banking information necessary to process the transaction. Remember EFT transactions are subject to a 5-business day hold before you can download the subscription.

Step 6 completes the purchase process. You may immediately access your subscription by selecting the “Access Subscriptions” link from the left hand navigation menu if you paid by credit card. If you paid via EFT, you will receive an E-mail when you can access your subscription from this menu.

To renew an existing download subscription:

After signing in, select “Access Subscriptions” from the left hand navigation bar. If a subscription can be renewed, a “Renew” link is displayed beside the Subscription Access Number.  The renewal option is accessible in the final month of your existing download subscription.  

  1. Select the Renew link next to the SAN you want to renew.
  2. Read and accept the terms and conditions of the subscription (you may also choose to print the terms and conditions for your records).
  3. Review and/or change your selected subscription options. Click “Continue”.
  4. Review and/or change your download contact. Click “Continue”.
  5. Confirm your purchase by ensuring your selected subscription options are correct, and select your desired payment option:
    1. Credit Card – if you elect to pay by credit card you will be asked to select your credit card type, enter in your credit card number and expiry date. Click “Complete Payment” to submit your payment for authorization. If the payment authorization is successful, you will be taken to a Purchase Confirmation page where you can print out a copy of the transaction for your records. Additionally the account managers and the download contact will receive an e-mail with this information.

      Important Note: Your renewed subscription will appear in the Subscriptions list when you select the “Access Subscriptions” link from the left hand navigation menu.  Until the Effective Date, you can only view the details of the subscription; you cannot use it to download.

    2. Electronic Funds Transfer – if you elect to pay by EFT you will be asked to agree to a Pre-Authorized Debit (PAD) agreement before you can proceed. Once you have agreed to the PAD you are requested to contact the Centre of Excellence at the telephone number provided. To complete the transaction you will have to provide the operator with the Subscription Access Number and Transaction ID information listed on this page along with banking information necessary to process the transaction. Remember EFT transactions are subject to a 5-business day hold before you can download the subscription.

      Important Note: Your renewed subscription will only appear in the Subscriptions list following the 5-business day hold.  To access your Subscription list, select the “Access Subscriptions” link from the left hand navigation menu.  Until the Effective Date, you can only view the details of the subscription; you cannot use it to download.

Query Subscription - Allows you to query the National DNCL up to 100 numbers at a time. Once you select the query option, you can type telephone numbers individually into the input box, or you may copy and paste telephone numbers into the input box.

To purchase a query subscription:

  1. Select Query Subscription, click “Continue”;
  2. Read and accept the terms and conditions of the subscription (you may also choose to print the terms and conditions for your records);
  3. Enter the telephone numbers you wish to query against the National DNCL into the query box.  You may either:
    1. Type telephone numbers individually into the query box or;
    2. Copy and paste telephone numbers from a text file or other program into the query box;
  4. Click Continue;
  5. Confirm your purchase by insuring your selected telephone numbers are correct;
  6. Click Confirm;
  7. Select your credit card type and enter in your credit card number and expiry date. Click Complete Payment to submit your payment for authorization. If the payment authorization is successful you will be taken to a Purchase Confirmation page where you can print out a copy of the transaction for your records. In addition the account managers will receive an e-mail with this information.

The Purchase Confirmation page and the Purchase Confirmation e-mail will identify which numbers you queried are on the National DNCL and which numbers are not.
They are categorized as follows:

Query Results
REGISTERED (MUST NOT CALL):
XXX-XXX-XXXX

NOT REGISTERED (YOU MAY CALL):
YYY-YYY-YYYY

Downloading the National Do Not Call List

Now that you have successfully purchased access to the National DNCL, this section provides details on how to download the National DNCL to your computer.

Download subscriptions are the only subscriptions that can be downloaded. Query subscription results are displayed after the purchase is complete and e-mailed to the account manger contacts listed in the account profile.

Before you get started downloading your subscription, you should be aware of the following:

The National DNCL list is refreshed daily at 6:00 am Eastern. If you are downloading the list before 6:00 am you will receive the previous day’s list.  There is a one and a half hour window between 12:01 am and 6:00 am during which no lists will be available for download. Please try again after 6:00 am Eastern. To download the National DNCL, please select the preferred file format and click Download List.

If your subscription is for all of Canada you will receive one compressed ZIP file containing a single CSV or XML file containing all area codes. If your subscription is for a single area code or multiple area codes you will receive one ZIP file containing multiple CSV or XML files corresponding to the individual area codes selected as part of your subscription.

A ZIP file is a popular file format used for compressing data. A compressed file is quicker to download and takes up less hard disk space. The National DNCL operator forecasts that at the end of the first year of operation, the approximate file sizes and download times for the lists are projected to be:

  • 32.5MB for the zipped all of Canada CSV file ~ 5 minutes to download
  • 62.5MB for the zipped all of Canada XML file ~ 10 minutes to download

The download times are based on 1 Mbps internet connection.

If you do not have a ZIP decompression program, you can download it from one of the Web sites that offer such software:

Note: A quick search on the internet for “zip file” will provide links to download other free and purchasable software to allow you to decompress the ZIP file and obtain access to the CSV or XML area code files contained within. The Canadian Radio-television and Telecommunications Commission (CRTC) and the National DNCL Operator do not endorse any Web sites, vendors or software products. This list is provided simply for your convenience.

To download your subscription, click on “Access Subscriptions” from the left hand navigation menu.  On this page you will see a list of the subscriptions you have either purchased or have been given access to.

Subscription Access Number
Is the computer-generated number assigned to each subscription purchased.
Organization
The name of the organization who purchased the subscription.
Description
At the time of a subscription purchase the purchaser may have elected to provide a name for this subscription.
Expiry Date
The expiry date of the subscription.

From within the Access Subscriptions page, you can also perform the following actions:

  • Add Subscriptions – allows you to add access to a download subscription purchased by another organization on whose behalf you are downloading. In order to add a subscription provided to you by another organization, you require the following information.
  • Registration Access Number – is a unique identifier associated with an organization’s registration on the National DNCL.
  • Subscription Access Number – is the computer-generated number assigned to the subscription provided.
  • Download Key – is a unique number associated with a Subscription Access Number. The owner organization has the ability to regenerate the download key. Unless you are provided with the new download key, you will no longer be able to access the subscription.
  • View Expired Subscriptions – allows you to view a list of your subscriptions that are no longer downloadable.

Clicking on a Subscription Access Number will provide full details about the particular subscription including:

  • Subscription Access Number – is the computer-generated number assigned to each subscription purchased.
  • Renewal of – if this subscription is a Renewal of a previous subscription, the Subscription Access Number of the original subscription is displayed here.  For original subscriptions, there is nothing displayed.
  • Download Key - facilitates the usage of a subscription by a party other than the subscription owner. For renewed subscriptions, the subscription owner must provide the download key of the renewal since it is different from the original.
  • Description – at the time of a subscription purchase the purchaser may have elected to provide a name for this subscription.
  • Subscription Owner – the name of the organization who purchased the subscription.
  • Purchase Date – the date the subscription was purchased.
  • Effective Date – the first date on which the subscription can be downloaded.
    For an original subscription, the date is the same as the Purchase Date. For a renewal subscription purchased prior to the expiry of the original subscription, the Effective Date is the day following the Expiry Date of the original subscription.
    For a renewal subscription purchased after the Expiry Date of the original. subscription, the Effective Date is the same as the Purchase Date.
  • Expiry Date – the expiry date of the subscription.
  • Number of Months – the number of months the subscription was purchased for.
  • Area Codes – the area codes contained within the subscription.
  • Last Download – the date that the subscription was last downloaded.
  • Download Contact – a contact assigned by the subscription purchaser to be responsible for the subscription from a technical perspective.

The “Remove Subscription” button allows you to remove a subscription provided by another organization from your subscription list.  You cannot remove a subscription purchased by your own organization.

In order to download the subscription you must:

  1. Select a file format for download (CSV or XML);
  2. Click “Download List”;
  3. Follow the instructions provided by your internet browser to store the file on your computer.

You may receive a message stating that the National DNCL file you have downloaded is invalid or corrupted. For users of Internet Explorer (all versions), try downloading the file again, paying particular attention to the two dialogue boxes that appear after selecting “Download List”.  The first dialogue box prompts you to “Run, Save, or Cancel”. You must select the “Save” option. The second dialogue box prompts you to select a location to save the file. Browse to the desired location on your computer and select “Save”. For security and performance reasons, you must respond to these two dialogue boxes within 30 seconds of their appearance, otherwise the file you download may be corrupted. If you use an internet browser other than Internet Explorer and continue receiving a corrupted version of the List, please contact the Centre of Excellence for support at support@req.lnnte-dncl.gc.ca.

Detailed information about the subscription format and download process is included below for your reference.

A CSV file is a comma-delimited text file containing one area code and telephone number per line, separated by a comma. For example:

  • 416,1234567
  • 416,1234568
  • 416,1234569
An XML file is a formatted file containing both data and markers ("tags") with information in angle brackets that indicate the nature of the data.

When a subscription contains all area codes, an element indicates what level and value of data are contained in the file. For the complete national list, the level is “all” and the value is null (Example 1). For a single area code list, the level is “ac” and the value is the area code, such as 416 (Example 2).

Example 1: National List
    <list type='full' level='all' val='' >
      <ac val='416'> 
        <ph val='1234567' />
        <ph val='1234568' />
        <ph val='1234569' />
      </ac>
    </list>      
    
Example 2: Single Area Code List

    <list  type='full' level='ac' val='416' >
      <ac val='416'>
        <ph val='1234567' />
        <ph val='1234568' />
        <ph val='1234569' />
      </ac>
    </list>    
    

Subscriptions files are refreshed nightly. Subscriptions files containing consumer telephone number registrations up to 11:59 pm Eastern the previous day are ready to download by 6:00 am Eastern.

Once you have downloaded the ZIP file and have installed a program to enable access to the ZIP file all you should have to do is double click on the ZIP file to “open” it. The CSV file or XML file(s) should be visible. Clicking and dragging the CSV or XML file to your computer should result in the file being decompressed and available for use. Refer to the documentation for your selected decompression software for more details.

How to Open the National Do Not Call List File

Once you have decompressed the National DNCL from the ZIP file and saved it to your computer, you will need to open the file to view its contents. The following instructions on how to open the National DNCL are provided for informational purposes only. Different versions of software or different operating systems may change or invalidate some of the instructions provided. The following instructions assume Microsoft XP as the operating system.

Note: The Canadian Radio-television and Telecommunications Commission (CRTC) and the National DNCL Operator do not endorse any Web sites, vendors or software products. These examples are provided simply for your convenience.

The instructions below apply if you downloaded the CSV file.

How to open with Microsoft Notepad (CSV):

  1. Hold down the Shift key and right-click with the mouse on the CSV file;
  2. Choose Open With;
  3. Select Choose Program;
  4. Scroll down the list;
  5. Select Notepad;
  6. Uncheck the box that reads “Always use the selected program to open this kind of file” – unless you want to default the opening of CSV files to Notepad;
  7. Click OK.

The CSV file will now open up and your selected subscription to the National DNCL will be available for use.

How to open with Microsoft Word 2003:

  1. Hold down the Shift key and right click with the mouse on the CSV file;
  2. Choose Open With;
  3. Select Choose Program;
  4. Scroll down the list;
  5. Select Word;
  6. Uncheck the box that reads “Always use the selected program to open this kind of file” – unless you want to default the opening of CSV files to Word;
  7. Click OK.

Please note: It is also possible to open a CSV file in spreadsheet software such as Excel. However please be aware that some spreadsheet software may truncate a file greater than 65536 rows. It is possible that by using spreadsheet software or Excel to view the CSV file you will not see the entire contents of the National DNCL.

The instructions below apply if you downloaded the XML file.

How to open with Microsoft XML Editor (XML):

  1. Hold down the Shift key and right click with the mouse on the XML file
  2. Choose Open With
  3. Select Choose Program
  4. Scroll down the list
  5. Select XML Editor
  6. Uncheck the box that reads “Always use the selected program to open this kind of file” – unless you want to default the opening of XML files to XML Editor
  7. Click “OK”

The XML file will now open up in XML Editor and your selected subscription to the National DNCL will be available for use.