ZIP Code Database|
Our Products
FREE ZIP Code Finder
Find ZIP+4 of Address
Other FREE Lookups
FREE Radius Search
FREE Distance Calc
|
Canadian Postal CodeOM DatabaseQuestions? 1-800-425-1169Postal Code List
What is a Postal CodeOM Database?A set of data put into row and column format for easy use and manipulation. With over 30 unique fields of information, it virtually gives you an unlimited number of ways to analyze all the Canadian Postal CodeOM information.
The Lat/Lon coverage is approximately 99%. The latitude/longitude data for Postal Codes comes from a crowd sourced system. Canada Post does not release this data and therefore there are no official coordinates for these postal codes directly from the source. There will be some inaccuracies in the data but it is the best data available while keeping the cost of the database reasonable. As mistakes are found, they are corrected daily from the crowd sourcing.
Purchase the Canadian Database
Redistribution LicenseIf you are developer looking to distribute any part of our data with your product, then the redistribution license is what you need. With our unlimited, royalty free license, you can package it with any software you need such as store locators, zip code lookups, demographic lookups, data validation, or mobile devices, to name just a few. All licenses come with a full 12 months of updates.
Redistribution LicenseIf you are developer looking to distribute any part of our data with your product, then the redistribution license is what you need. With our unlimited, royalty free license, you can package it with any software you need such as store locators, zip code lookups, demographic lookups, data validation, or mobile devices, to name just a few. All licenses come with a full 12 months of updates.
License AgreementGeneral You are permitted to: 1) Provided that you have purchased a Redistribution License, distribute the Data (without royalty) as part of a distinct application; You are not permitted: To sell the data in whole or in part and market it as a "ZIP Code Database", "Postal Code Database", or any other similar designation. This restriction includes any manner that directly competes with our Zip-Codes.com website data sales. Acceptance Term Ownership Disclaimer Of Warranties THE SERVICES AND ALL INFORMATION, PRODUCTS AND OTHER CONTENT (INCLUDING THIRD PARTY INFORMATION, PRODUCTS AND CONTENT) INCLUDED IN OR ACCESSIBLE FROM THIS WEB SITE ARE PROVIDED "AS IS" AND ARE SUBJECT TO CHANGE AT ANY TIME WITHOUT NOTICE TO YOU. TO THE FULLEST EXTENT PERMITTED BY LAW, ZIP-CODES.COM DISCLAIMS ALL REPRESENTATIONS AND WARRANTIES (EXPRESS, IMPLIED AND STATUTORY, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, AND ON-INFRINGEMENT OF PROPRIETARY RIGHTS) AS TO THE SERVICES AND ALL INFORMATION, PRODUCTS AND OTHER CONTENT (INCLUDING THIRD PARTY INFORMATION, PRODUCTS AND CONTENT) INCLUDED IN OR ACCESSIBLE FROM THIS WEB SITE. Limitation of Liability Indemnity Minimum Protective Terms One such third party supplier is Canada Post Corporation ("Canada Post") who has granted Licensor certain rights with respect to certain Canada Post Data (the "CP Licensed Data") under which Licensor may include the CP Licensed Data, in whole or in part, in the Licensed Content and distribute the same to its sublicensees of the Enhanced Value-added Product subject to the sublicensee's (in this case your) prior agreement to the terms and conditions set out in these Minimum Protective Terms. 2. You acknowledge that Canada Post is the owner of the copyright in the Canada Post Data. You acknowledge that it is only licensed to use the CP Licensed Data in conjunction with Canadian Postal CodeOM Database and the Enhanced Value added Product. You acknowledge that it may only grant rights to third parties to use the CP Licensed Product in conjunction with the Enhanced Value-added Product. Without limiting the generality of the preceding sentence, You have no right to distribute any CP Licensed Data on a stand-alone basis or for the purposes of use with any product other than the Enhanced Value-added Product. 3. You acknowledge, and agrees to provide notice to parties to whom it distributes the Enhanced Value added Product, that the damages that Canada Post may incur as a result of parties using out-of-date data for mail preparation include costs that Canada Post will incur in processing and delivering that mail. Such costs include, but are not limited to, the costs incurred by Canada Post (i) for the manual readdressing and resorting of mail that was diverted from the normal automated mail processing stream because it was addressed with an invalid address, or the Postal CodeOM element of the address was invalid, or (ii) if the mail was delivered to the wrong address as a result of having been addressed with an invalid address, or as a result of the Postal CodeOM element of the address being invalid, the cost of the original sorting, processing and delivery of the mail as well as the extra costs incurred for the manual readdressing and resorting of the mail. (Postal Code is an official mark of Canada Post.) 4. In order to reduce the risk of Canada Post suffering damages as a result of out-of-date data being used for mail preparation and given that CP Licensed Data will be distributed as a component of the Licensed Content, You agree: (a) not to distribute the Licensed Content until after you have put in place safeguards to reduce the risk of "data scraping" or "bulk downloads of data"; You agree to keep abreast of developments in technology and to update the safeguards in place to further reduce such risks as improved technology becomes available from time to time, and (b) to ensure that the parties to whom the CP Licensed Data is distributed, whether as a component of the Enhanced Value-added Product or as a, or component of a, data file, to be used in conjunction with an Enhanced Value-added Product, are informed that the same is not to be used for mail preparation purposes and that this prohibition applies, without limitation, to each of the following: (i) addressing mail; (ii) presorting addressed mail; (iii) preparing unaddressed mail by householder count for delivery. 5. You also acknowledge that if you develop any product that uses data for which the original source of that data is Canada Post, which product is intended to be used for any of the purposes listed in clause 4(b)(i), (ii) or (iii), You have no right to use or distribute such a product or to offer any services in relation to such a product unless you have a then current right to do so under a written agreement signed by both you and Canada Post. 6. You agree to include (a) in the hard copy or electronic copy of the license agreements, which you represent will accompany all copies of the Enhanced Value-added Product and of the Licensed Content distributed by you that contain CP Licensed Data, and (b) on the start-up screen of the Enhanced Value-added Product and in the terms and conditions of use posted on any website by which a user may access the Enhanced Value-added Product, a notice stating that the Enhanced Value-added Product contains data copied under license from Canada Post• Corporation and indicating the date of the Canada Post Corporation data file (or the date of the earliest Canada Post Corporation data file, if more than one) from which the data was copied. Where the language of your product or service is French, you shall use the French version of the pro forma notice that is set out further on below, but if the product or service is in a language other than English or French, you shall include the equivalent notice but in the relevant language. Each such notice shall be tailored with the appropriate information by replacing the "[Insert ... )"/ « [Indiquez ... ) » « [Inserez ... ) » instructions with the information contemplated: "This [Insert appropriate reference to medium, i.e. diskette, tape, etc.) contains data copied under license from Canada Post Corporation. The Canada Post Corporation file from which this data was copied is dated [Insert date)." French version of the pro forma notice "[Indiquez Ie support approprie, c'est-a-dire «Cette disquette», « Cette bande magnetique», etc.) contient des donnees qui ont ete reproduites avec i'autorisation de la Societe canadienne des postes. Le fichier de la Societe canadienne des postes d'ou proviennent ces donnees est date du [Inserez la date)." 7. You acknowledge that the CP Licensed Data is licensed to you on an "as is" basis and that Canada Post makes no guarantees, representations or warranties respecting the CP Licensed Data, either expressed or implied, arising by law or otherwise, including but not limited to, effectiveness, completeness, accuracy or fitness for a particular purpose. You will include a provision in its terms of use requiring a user of the CP Licensed Data to acknowledge that the CP Licensed Data is licensed on an "as is" basis and that Canada Post makes no guarantees, representations or warranties respecting the CP Licensed Data, either expressed or implied, arising by law or otherwise, including but not limited to, effectiveness, completeness, accuracy or fitness for a particular purpose. 8. Neither Licensor nor Canada Post shall be liable in respect of any claims whatsoever alleging any loss, injury or damages, direct or indirect, which may result from your, or any of its user's, possession or use of the CP Licensed Data. Neither the Licensor nor Canada Post shall be liable in any way for loss of revenue or contracts, or any other consequential loss of any kind resulting from any defect in the CP Licensed Data. 9. You shall indemnify Canada Post and its officers, employees and agents from all claims whatsoever alleging loss, costs, expenses, damages or injuries (including injuries resulting in death) arising out of your possession or use of the Licensed Content. You will include a provision in its terms of use requiring a user of the CP Licensed Data to indemnify Canada Post and its officers, employees and agents from all claims whatsoever alleging loss, costs, expenses, damages or injuries (including injuries resulting in death) arising out of such user's possession or use of the CP Licensed Data. Changes to Sites Zip-Codes.com may change or modify the information, services, products, materials, and any other resources contained on or accessible through their sites, or discontinue their sites altogether, at any time without notice. If Zip-Codes.com discontinues its service for any reason, it will refund any prorated portion of the database cost not already used by the customer. Law If any part of this Agreement is found void and unenforceable, it will not affect the validity of the balance of the Agreement, which shall remain valid and enforceable according to its terms.
Database Technical SpecificationsDownloads
Canadian Postal CodeOM Database FAQs
Q. What methods of payment do you accept?
A. We accept Visa, Mastercard, American Express, and PayPal for immediate download. You can also place your order choosing Mail In Check or Purchase Order but you will be unable to download the database until your payment is received.
Q. Do you accept purchase orders?
A. Yes, we can accept purchase orders. Simply go through the order process as normal. When you come to the payment screen, choose Purchase Order as the payment type and complete your order. You can then print out a purchase order and mail in the payment. Once payment is received, access to download the database will be turned on.
Q. What format does the database come in?
A. Our Canadian Postal CodeOM Database is provided in three (3) formats: Microsoft® Access [MDB], Microsoft® Excel [XLS], and ASCII Comma Delimited [CSV].
Q. How do I get the monthly database updates?
A. When you purchase, you setup a username and password. Each month, we will notify you via email that an update database is available. Visit our site and login using your username and password. The updated databases will be available for download in any format we provide.
Q. Will a CD be mailed to me? How do I get the database?
A. No, our Canadian Postal CodeOM Database is not mailed to you on CD. Once your order is completed, you will be able to download immediately. This ensures fastest delivery as the database is updated each month.
Q. What happens after my 1 year subscription?
A. When your Canadian Postal CodeOM Database subscription is expiring, we will notify you by email 30, 10, and 1 day in advance. You can choose to renew at the current rate, or let your subscription expire. You can continue to use the database after your subscription has expired, but the data will become outdated very quickly.
Q. How much does it cost to renew?
A. Currently, renewal prices are the same as the original purchase price.
Q. Do you include Postal CodeOMs for all of Canada?
A. Yes. Postal CodeOM data is provided for all Canadian provinces and territories.
Q. How often do you update the database?
A. Our Canadian Postal CodeOM Database is updated every month.
Q. How current is the data?
A. Our Canadian Postal CodeOM Database is updated every month. the data is current as of August, 2017
Q. How accurate is the data?
A. Accurate data is critical to the success of your business and ours. Zip-Codes.com implements a very rigorous set of data integrity checks to ensure our database is as accurate as possible. In the unlikely event that a portion of data is confirmed as inaccurate, we will correct it within 2 business days.
Q. Do you have any other countries besides Canada?
A. Yes. We also have the U.S. ZIP Code Database.
Q. How long does it take to get the data?
A. Instantly. As soon as your order is confirmed and payment is received, you will get the database immediately after purchase.
Q. Can I automate the database delivery?
A. Yes! Please email us requesting an FTP Account be setup for you to use in automating your processes. Please include your username or order number for reference. We will have it up and running within 1 hour.
Postal CodeOM Tools & ResourcesZip-Codes.com offers it's client several free applications, tools, and sample code to all of it's client's. It's our way of saying thank you and helping you make the most of what we offer.
Database ScriptsThese scripts work on yourSQL Server or MySQL Server establishing the table, columns, and column definitions before importing the data. To use them, execute the full file contents in Enterprise Manager, SQL Server Management Studio, phpMyAdmin, or other SQL Command Interface.
Sample CodeThe sample code provided here is meant as an example of how some functions can be performed.
Radius Finder
The Radius Finder Application is free for our all of our Canadian Postal CodeOM Database Customers and comes bundled with the Access Database. It features:
Why Choose Us?
Who Else Uses Our Products?These are some of the more recognizable customers of Zip-Codes.com:
Customer TestimonialsThese are actual emails from some of our customers: 11/6/2015 Thanks for this. And I wanted to say thank you to the very kind representative that I spoke with on the phone today - very helpful. Denise xxxxxxxxx 5/22/15 Hi, 6/12/15 Wow Jennifer, that is truly fantastic customer service. I've been able to log in so everything seems to be working. Thank you very much. Hugh xxxxxxx 7/28/15 Hi Jennifer, Thanks, you have been very helpful and I appreciate it. It is now working great. It was nice talking to you. On a scale of 10, I give you 20 for Customer Satisfaction. Have a nice day. Thanks, 9/11/15 Jim; I've always used usps.com and gotten the appropriate zip code - by using the address. Anyway, thanks for this new information....... 9/25/15 Thank you so much. I appreciate your prompt help with this matter. I have been a customer of yours at almost every company I work at, and I am always pleased with your products and service. 12/11/15 Hi Jim, Fábio xxxxxxxx 9/2/14 Excellent – Thank you Jennifer. I appreciate your quick response and the consistency of your data and its delivery. Have a great week! Richard xxxxxxx 5/7/14 Zip-Codes.com Team 3/26/14 Good Morning, Thank you very much for the response. Thank you to your team for their suggestions. Regards, Wade xxxxxx 2/21/14 Thanks so much. I’ve been very happy with the data you provide, the support, and the affordability. I’ll definitely recommend you as the best out there, having looked at several. Randy 1/8/14 Jennifer, The research you did on this alone was worth the $50. Thank you for your professionalism, expediency and impeccable customer service. Thanks again, 11/15/13 Thank you Jennifer, I appreciate your firm’s consideration. I will spend some time experimenting with DC over the next few days. I hope to have a nice set of DC maps soon. Your level of customer support is excellent. It’s already obvious that your company cares about its customers and will go the extra mile to make sure your products are useful. Karl www.dyngeo.com 10/25/13 Hello Jennifer, Thank you so much for the sample information. I appreciate your prompt reply and great service. Have a good day, Insurance Brokers for Seniors, Inc. 10/16/13 Hi Jim, 9/20/13 Thank you very much for your quick response. We look forward to working with your data and are gratified to see that your customer service is at such a high level. Kind regards, Sue xxxxxxx 8/28/13 Thank you so much. This was super fast and extremely kind of you to refer me to a place that might help. 7/31/13 Thanks Jennifer - I really appreciate all your help and guidance. You are an outstanding asset for your organization and their customers! Alok 07/05/2013 Jim,I tried that after I sent the message - and I got it thanks! Great product and will be ordering more for North and Central Texas. Thank you so much!!! 06/14/2013 Have enjoyed using your database and the radius tool. Super things. Have just spent a lot of money on a new customer dB system that includes Zip Code radius search. I do not think that it is as up-to-date and comprehensive as yours, but we have to live with it. Thanks for several years of service. 05/31/2013 Jim, your quick response is certainly appreciated, especially with the nature of this project.I may be logging on this weekend, and your explanation will really help me! THANK YOU!! Sincerely, Dave xxxxxxx, MBA, JD University of Phoenix 05/01/2013 HiYour service has been excellent and the data base has been useful to us. I invested in it to assist a non for profit organization analyze their donor pool and it was very helpful. However, that project is done and I havent a need for the data base at the moment. If I do need it again in the future, I will reach out to you (and hope that you will still recognize me as a client). Great product, great service.... Thank you Nancy 12/03/2012 Hi There -I'm a happy subscriber to your service and just wanted to give a big THANKS for the SQL formatted database. I don't think I saw this last time I grabbed the data. Really makes things a lot easier. Cheers! 09/23/2012 This ROCKS ! ! Thank you for this information it was a huge help...and free...what up?Own The Day ! Debra -- Debra xxxxxxx Senior Distributor "Send Out Cards" 09/27/2012 I have a lot of demographic research experience in prior jobs. I was asked to do a task for my present employer so I needed an inexpensive database to work with. This program was absolutely one of the best tools I have ever used. I cant believe it only cost $80. Thanks for making a great product. I would recommend to anyone.Thanks, 09/27/2012 Awesome! Thank you so much for that info, I've been dealing with this issue for years. You must get this question all the time. Thanks, again! Joan 8/23/12 Great site. Very Helpful and easy to use. Bob Fryer 4/10/12 You guys are fantastic. I’m very happy we went with your database; your support has been flawless. Great job. Really. Thank you very much for your help, Jennifer. Have a great day! www.revivemediaservices.com 3/20/12 Jim, For my first question, our app is allowing users to search up to a maximum of an X miles radius (maybe 50 miles) around a zip code. I believe that your database allows us to determine the center zip code for a selected metro area. So we will determine all the zip codes within a metro area and then calculate the maximum distance from the center zip code to the outermost zip code and make that our search radius. However, if any metro areas are larger than our maximum radius it will complicate things. So I am interested to know, if you can tell me, how large the largest metro area is. Thank you, 3/19/12 Hi Jim, Thanks for the quick response. Your answer was perfect for me. I appreciate your great customer service and your fine product. Best, Alan Maitland 2/23/12 You guys are awesome about this stuff! Wish all companies ran like you. William Rodriquez 12/27/11 Hiya Jim, Happy Holidays! Thanks for the update. I will certainly be renewing and upgrading real soon. I love your services =) Have a stupendous week. Quang 12/5/11 Jennifer: 10/20/11 Dear Jennifer's Supervisor, AHA; so by including the Primary Record field in my query and also including the letter "P' in the Criteria field my problem was solved. Once again; 'Little Nell' (i.e. me); the proverbial person in a crisis was saved - by Jenifer. Let me know how all this was received - conceptually. 9/23/2011 Hi: As my subscription is about to expire in about ten days, I thought I'd check the web for other similar offerings. I didn't spend an inordinate time searching but after about twenty minutes it became reasonably clear that there was nothing remotely approaching the level of detail provided in your US zip code database by any of your competitors. Accordingly, when it expires I'll not only renew but also upgrade my subscription. Thanks for a very good product. John W. xxxxxxx 9/2/2011 Thank you for this unbelievably wonderful App!!!!!!!. 6/14/2011 Hi Jennifer, Thank you so much for all your help today. I really appreciate your patience, and look forward to working with your company in the future. Best regards, 11/12/2010 Good morning, I have been very pleased with your company and your product over the years. But in particular, I wanted to let someone know that Jennifer (telephone support) helped me out with some problems today in trying to get and extension on our purchase of your zip code deluxe product. She was a wonderful person with which to work. Jennifer was knowledgeable, responsive, and had a very pleasant and caring attitude. Sometimes rare these days. Ray xxxxxxxxxx 9/21/2010 I don't usually write to website contact email addresses. I have a comment and couldn't help myself . . . WHAT A GREAT WEBSITE !!! WOW! What an absolute joy to find a site where the site owner(s) have gone to the trouble of making it as useful as you have without compensation. If there's a prize for having a really useful website, if you haven't already won, you surely will. I'm only one person, but wish to simply say "Thank You!". You're officially "Bookmarked" permanently. Robb Blodgett 6/28/2010 Wow! That is fantastic James :-) I believe you may be right! I have tried some zip codes that were past issues, some random areas (in the recent-past it wasn't hard to find some that fail) and all have worked! I appreciate you monitoring the error-reports, and for taking time to explain what was occurring and solutions you were looking into. Thank you James. Thank you for all your hard work, skill and time applied to working a solution to this. :-) Really terrific, thank you again! John John xxxxxx 5/19/2010 Jim, It's refreshing to know there are still good customer support people out ------ Adam xxxxxxx 5/17/2010 Thank you Jim. Michael xxxxxxx, CPCU, AIM - MetLife Auto and Home - Senior Technical Coordinator - Home Ops Team 5/13/2010 Hi James, Thank you so much for your help. You have an excellent customer support team. Your prompt help saved us a huge time on implementing one of our application. Again thank you for your excellent support. Regards, Monty 3/29/2010 Thank you for your quick response. One more thing that puts your site above the others. 3/29/2010 You guys are the best --- Thank you! 3/6/2010 Hey Folks, It's a great tool for me; as a real estate investor it allows me to quickly focus my property searches. -- Vicki xxxxxx White Rabbit Enterprises, Inc. 11/6/2009 Wow, thanks so much. I am truly amazed at your customer service. The phone was answered by a real person and not a machine, and my email was answered so quickly. As well you fixed my problem, it is now working for the Canadian locations. I just don't run into great service like this very often, not for paid services never mind a free one. Thanks again Wednesday, January 14, 2009 8:50 AM I don’t know if it’s first date syndrome or what but I somehow came across your site this morning and am AMAZED!!! The zip distance calc is awesome!!Then put in my zip and CAN NOT BELIEVE the details!!!!!! Plus weather and a map!! No I remember, I was looking for a way to map a radius!! Friday, January 23, 2009 3:23 PM Jim, Monday, January 26, 2009 6:56 PM Perfect!!!!! Friday, February 06, 2009 5:38 PM Jim, Yutthichai (U.T.) xxxxxxxxx Monday, February 09, 2009 10:10 PM Thank you for your prompt reply. Impressive. Tuesday, April 07, 2009 6:15 PM Dear Mr. Jim xxxxx: Adjunct Assistant Professor, Tuesday, May 05, 2009 8:57 AM Thank you so much for your personal reply. I've found only two instances in the past year where I believe USPS was incorrect. Therefore, I will continue to have great faith in the info you provide. Again, your website is so helpful. I do appreciate your assistance. Dee xxxxxx Thursday, June 11, 2009 5:26 PM Great. Thanks. I’m using 2007, so I’ll combine them into one file. Thanks again for your help. It’s a great product, especially the Radius Finder. Thursday, July 23, 2009 10:48 AM Dear James, I just want to thank you for all of your assistance! I am enjoying the use of the US zip codes program, which has proved to be very useful. Thank you very much!! Sylvia xxxxxx Wednesday, September 30, 2009 1:44 PM What a great site you have! It is full of wonderful, valuable information. I just found it and will recommend it to others. I love that you give away a lot of info but sell software, maps and other tools that are helpful to many different applications. Thanks for having such a great site! Sheila Adcock I appreciate the quick turn around on this question. We are working with a vendor that uses this level of reporting. We wanted to be able to create the same reporting level in-house with your up to date ZIP Code products. These additional codes will be very helpful. Thanks for going above and beyond the call of duty to provide this list of CBSA divisions. This level of service makes me glad we chose to do business with your company. Thanks, I rarely write to applaud a product, but the usefulness of your software to my job is very relevant. Your zip code software, used in conjunction with your software to find radii from a specific locale is excellent--simple to use and a valuable resource for any direct mail marketer. Thank you very much. Sincerely, Jim, Thank you for resolving this so quickly. The support you provided me with on the phone today along with the quick manner in which you responded to my refund request says a lot about you and your company. Sincerely, My only comment would be that your customer service is fantastic. Sue, thank you! I shared with James ********* how helpful and prompt you have been regarding this matter. A nice company to work with! Hi James – Thanks again, Thanks for the info, Jim. I'll have to purchase from scratch, as my company will require a purchase order and multiple levels of approvals and all that. But again, thanks for that. You guys have a great product. Hi, Randi Good morning. No questions - just wanted to say that we ordered our first map from y'all yesterday, and we LOVE it! Taking disk with pdf file to Kinko's to get large version printed. My boss is bouncing off the walls he's so happy. Incredible market planning tool for us as we work to determine target clients. Hello, I ordered the incorrect zip code map and would like to request a refund. I was looking for an actual map and not the database. My order number is 267750. I spoke to your customer service area (whom by the way was very helpful!) and he informed me how to order the correct item. Thank you, Tammara ******** Thank You very much for your prompt reply Thank you for the excellent customer service. This will give us the entire directory and not just updates; is that correct? Dahlia Thanks for your speedy reply! Amelia Thanks for the quick response Jim. A pleasure doing business with you ! Ray Hi Jim, James: I just want to say thank you for your patience with me. I finally got what I needed, transferred the zip codes onto the Excel sheet that was required and got them emailed to our national office so they would send us the leads for our area that we need to grow our business. It was a challenge. Much appreciation, Nellie ******** The reason I bought from you is: A few days a go I asked you how many individial zip codes there were. Wham! The answer came back quickly. I was impressed. Isn't that much good customer service these days. My congratulations!!!! Armond ***** Hi James, Thanks a lot, so quick to respond, this is the better way to do business!!! Ok, we'll setup a program to get it every 5th. Thanks - - - THANK YOU . . . the new map certainly fits my needs better. You get my 2008 award for being “customer friendly”. Thanks again. Jim, Glenn |