Canadian Postal Code^OM Database

Pick the edition by the granularity of Census geography you need to join against — that's the practical line between the three tiers.

• Standard ($169.95/yr) — 8 columns. Postal Code, FSA, city, province, area code, lat/lon, and record-type classification. The lookup layer: useful for validating a Postal Code, surfacing the city/province, dropping a pin, or feeding a shipping-zone calculator. No demographics.
• Deluxe ($279.95/yr) — 18 columns. Everything in Standard plus province full-name, Olson time-zone IDs, DST observance, elevation, and FSA-rolled-up Statistics Canada 2021 Census population and dwelling counts. The marketing-and-analysis layer: enough demographic depth to size a market by FSA without joining external tables.
• Business ($499.95/yr) — 46 columns plus 17 supplemental cross-reference tables (PCCF linkage, street supplements, Federal Electoral Districts, municipality alias, accent variants, and 12 more). Drives down to Statistics Canada's Dissemination Area, Census Tract, CSD / CD / CMA, ER, and PC geography. The GIS-and-enterprise tier: hooks straight into Statistics Canada Census Profile tables for thousands of cross-tab demographics.

View detailed comparison →

Pay only the gap between editions:

• Standard → Deluxe ($110) for FSA Census, time-zone IDs, and DST flags
• Deluxe → Business ($220) for the PCCF linkage and the 17 supplemental tables
• Standard → Business ($330) to go straight from lookup to full Statistics Canada Census geography

Upgrades are pro-rated and the existing 12-month update window carries over, so timing the upgrade doesn't cost you part of your year.

Process it from your account dashboard — the upgraded files and supplemental tables become downloadable on the next page reload, and your renewal date is preserved. Have a multi-product bundle in mind (Canadian + ZIP + ZIP+4), a multi-year discount question, or a custom user-count requirement? Get in touch and we'll quote it manually.

Canada Post varies the publication of their Postal Code each month. This data goes through our manual quality review pipeline and is typically published on the 15th. The result is a database that won't carry through a Canada Post typo or a one-month record drop that gets restored later.

Two ways to pull it:

• FTPS / SFTP: dedicated credentials provisioned with every license; the file shows up at /releases/canadian/ each cycle. Standard cron / Task Scheduler / Airflow setups consume it without intervention.
• Account dashboard: same files, manual download, useful for ops teams who don't want an automated pipeline.

Recommended ingest schedule: the 20th of the month — a five day buffer past our publish date that catches the very rare republication (a corrected Statistics Canada PCCF revision is the most common cause) without you needing to manage two versions in production.

After your 12-month update window closes, you keep every monthly file you downloaded; you only renew if you want the next round.

Canada Post specifically licenses the underlying Postal Code data with a redistribution clause, so our license tiers split accordingly.

A redistribution license is required when:

• You're embedding the database (in whole or in part) into a product, mobile app, or SaaS that other people pay for or sign up for — the dataset reaches an end user outside your organization
• You're packaging the data into a downloadable extract a client receives
• You're running a public-facing Postal Code lookup, autocomplete, or radius-search endpoint that returns Canada Post-derived records
• Examples: store-locator widgets shipped to clients, shipping-rate calculators bundled into checkout, mobile delivery apps, white-labeled CRM enrichment

A standard license covers you if:

• The data stays inside your organization for analytics, route planning, territory drawing, internal CRM enrichment, marketing analysis, etc.
• Queries hit your own application logic; end users never see raw Postal Code records
• Field staff use the data through internal tools, not customer-facing products

Important Canada Post note: "Postal Code" is an official mark of Canada Post Corporation. The redistribution tier carries the attribution requirements Canada Post requires when a derivative product is offered to third parties; the standard tier handles internal use without that obligation.

Redistribution pricing is by end-user volume and stays royalty-free — no per-call or per-record fees. Borderline use case? Send us a quick description via contact and we'll match you to the right tier; it's faster than reading the full ToS.

Every edition includes three formats at no extra cost:

• CSV (Comma-Separated Values): Universal format that works with virtually any application, database, or programming language. Perfect for custom imports and automation.
• Microsoft Access (.MDB): Ready-to-use database file. Open it in Access and start querying immediately. Includes proper field types and indexing.
• Microsoft Excel (.XLS): Multiple Excel workbooks for easy exploration and analysis. Great for quick lookups and business intelligence tools.

Note: Unlike our U.S. ZIP Code Database, SQL import scripts are not available for the Canadian Postal Code Database. However, the CSV format imports easily into MySQL, PostgreSQL, SQL Server, and other database systems using their native import tools.

All formats are included with every purchase and available for download immediately after checkout.

Yes! All three editions include latitude and longitude coordinates for approximately 99% of Canadian Postal Codes. These coordinates allow you to:

• Plot Postal Codes on maps (Google Maps, OpenStreetMap, etc.)
• Calculate distances between locations
• Perform radius searches ("find all Postal Codes within 10km")
• Integrate with GIS systems and spatial analysis tools
• Build store locators and territory management applications

Coordinate precision: Coordinates represent the approximate center point of each Postal Code's delivery area, typically accurate to within a few hundred meters for urban areas. See our FAQ on coordinate accuracy for more details.

Bonus: Every purchase includes our free Radius Finder desktop application for instant distance calculations and radius searches with no internet connection required.

We maintain high accuracy through a rigorous three-step verification process:

1. Source data validation: We license official Postal Code data directly from Canada Post Corporation, ensuring we start with authoritative, up-to-date information.
2. Automated verification: Our systems cross-reference Canada Post updates with Statistics Canada Census data and perform consistency checks across all data fields.
3. Manual review: Our team manually reviews flagged records and customer-reported discrepancies before each monthly release.

Monthly updates: We sync with Canada Post's monthly releases (typically around the 15th), capturing new Postal Codes, retirements, and boundary changes. This ensures your database stays current with real-world addressing changes.

Found an error? Report it to us. We investigate every claim and issue corrections in the next monthly update when verified.

Yes, for Postal Code-level validation. Our database is excellent for:

• Postal Code validation: Verify that a Postal Code exists and is currently active
• City/Province lookups: Confirm the correct city and province for a given Postal Code
• Geographic validation: Check if a Postal Code/city/province combination is valid
• Auto-complete: Populate city and province fields automatically when users enter a Postal Code
• Data cleanup: Standardize existing address databases by correcting city names and province codes

Limitations for full civic address validation:

Due to Canada Post licensing restrictions, we cannot provide street number ranges (e.g., "100-199 Main St"). This means our database can tell you that a Postal Code is associated with "Main Street" but cannot validate specific street numbers or suite numbers.

For complete address validation including street numbers: You'll need Canada Post's official Address Lookup File (CANADA.ADD) or a third-party address validation API service. Our database complements these services by providing the demographic, geographic, and Census data that Canada Post doesn't include.

Bottom line: Perfect for Postal Code validation, geographic lookups, and data enrichment. Not suitable as a standalone solution for full civic address validation with street number verification.

Census data varies by edition, all sourced from Statistics Canada 2021 Census:

Deluxe Edition:

• FSA-level demographics: Population and dwelling counts aggregated at the Forward Sortation Area level (first 3 characters of Postal Code)
• Example: All Postal Codes starting with "K1A" share the same population/dwelling statistics

Business Edition:

• Complete PCCF integration: Links every Postal Code to Statistics Canada's Postal Code Conversion File geography
• Census Metropolitan Area (CMA): Major urban centers like Toronto, Montreal, Vancouver
• Census Division (CD): Roughly equivalent to counties or regional municipalities
• Census Subdivision (CSD): Cities, towns, villages, and municipalities
• Dissemination Area (DA): Small neighborhood-level areas (400-700 people)
• Census Tract (CT): Stable neighborhood areas in large urban centers
• Economic Region (ER): Groupings of Census Divisions with similar economic characteristics
• Population Centre (PC): Urban core classifications
• Federal Electoral Districts (FED): Current federal riding boundaries

Each geographic linkage includes both the unique identifier (UID) and the official name, allowing you to join with detailed Census tables for demographics, income, housing, education, and more.

Note: The Business edition's PCCF linkage is the key to unlocking comprehensive demographic analysis. While we provide the geographic connections, you can pair these with Statistics Canada's free Census Profile tables to access thousands of demographic variables.

Postal Code data: Updated monthly around the 15th of each month, synchronized with Canada Post's official releases. New Postal Codes, retirements, and geographic changes are reflected within days of Canada Post's publication.

Census demographic data: Based on Statistics Canada's 2021 Census (most recent comprehensive census). The next Census will be conducted in 2026, with results typically released 12-18 months later.

Geographic boundaries: Federal Electoral District boundaries reflect the most recent redistribution. Census geography (CMAs, CDs, CSDs, DAs, CTs) follows Statistics Canada's 2021 definitions and remains stable between census cycles.

What changes monthly:

• New Postal Codes added as Canada Post assigns them
• Retired Postal Codes removed from active service
• City name corrections and official name changes
• Coordinate refinements based on validation
• PCCF linkage updates when Statistics Canada revises geographic assignments

Your purchase includes 12 months of these updates, ensuring you always have access to the most current Postal Code information available.

Absolutely! All of our licenses (Standard, Deluxe, and Business) include full commercial use rights for internal business operations.

Regular licenses allow you to:

• Use the data for your business operations, analytics, and research
• Build internal tools and applications for your company
• Perform demographic analysis and market research
• Calculate shipping costs, delivery zones, and logistics planning
• Create sales territories and regional analysis
• Support customer service and CRM applications

If you're distributing the data to others (embedding in software, SaaS applications, mobile apps, or products you sell), you'll need a redistribution license. See our redistribution FAQ for details.

License tiers: Choose the user count that matches your organization size (1-5 users, 6-50 users, or 51+ users for enterprise). The license covers everyone in your organization who needs access to the database.

Simple: 30-day, no-questions-asked, 100% money-back guarantee.

If our Canadian Postal Code Database doesn't meet your needs for any reason, just contact us within 30 days of purchase for a full refund. No hassle, no hoops to jump through.

Why we can offer this: We've been doing this for 23 years, serving Fortune 500 companies and businesses of all sizes. We're confident our data quality and customer service will exceed your expectations. The handful of refunds we process each year are typically due to customers realizing they need a different product (like full address validation) rather than data quality issues.

What happens to the data? If you request a refund, we ask that you delete any downloaded files from your systems. We operate on trust-we're not going to hunt you down or install DRM. We just want happy customers.

After 30 days? Refunds aren't available, but we're always here to help troubleshoot issues, answer questions, or work with you if there's a data quality concern. Our goal is your success, not your money.

FSA stands for Forward Sortation Area-the first three characters of a Canadian Postal Code (e.g., the "K1A" in "K1A 0B1").

Understanding the structure:

• Full Postal Code: K1A 0B1 (6 characters: letter-number-letter space number-letter-number)
• FSA (first 3): K1A (identifies a geographic region, like a neighborhood or small town)
• LDU (last 3): 0B1 (Local Delivery Unit-identifies a specific block, building, or rural route)

For Americans: A helpful analogy:

• FSA (K1A) ˜ U.S. ZIP Code (90210)-Defines a general geographic area
• Full Postal Code (K1A 0B1) ˜ U.S. ZIP+4 (90210-1234)-Pinpoints a specific delivery point

Why FSA matters: Statistics Canada Census data is often aggregated at the FSA level. This means population and dwelling counts in our Deluxe edition represent everyone in the FSA, not just one specific Postal Code. The Business edition's PCCF linkage provides more granular Census geography (Dissemination Areas, Census Tracts) for finer demographic analysis.

Coverage: Canada has approximately 1,620 FSAs covering all provinces and territories. Our database includes all 892,960+ full Postal Codes within these FSAs.

Yes — and it is worth understanding how, because it is not what most people expect.

Canada Post publishes place names without accents. In the delivery address fields, Montréal is stored as MONTREAL, Québec as QUEBEC, and Trois-Rivières as TROIS-RIVIERES. That is the postal standard, and every licensed reseller of this file ships it the same way. Any vendor telling you their Canada Post city names arrive accented is describing something they added.

What's included:

• The accented forms, in Business: the Accent Supplement maps all 8,315 accented names to the unaccented form we ship, both directions — so you can store the postal-standard value and still display Montréal
• French province names: the Business PROVINCE supplement carries both officially — PRENAME “Quebec” and PRFNAME “Québec”. The main table’s ProvinceName is English only
• Proper capitalization: the mixed-case fields carry Montreal rather than MONTREAL, so you are not title-casing strings yourself
• Statistics Canada names, accented: the census geography columns in Business come from StatCan rather than Canada Post and do carry their accents natively — Québec, Saint-André, Beauséjour

Technical details: the CSV is Windows-1252, not UTF-8. It only matters for Business — the Standard and Deluxe files contain no accented characters at all, so they load byte-identically either way. For Business, set the source encoding to Windows-1252 and convert on the way in if your database is UTF-8. The Excel and Access copies carry the accents natively and need no such handling.

Examples — what is in which column:

• City MONTREAL · CityMixedCase Montreal · Accent Supplement Montréal
• City TROIS-RIVIERES · CityMixedCase Trois-Rivieres · Accent Supplement Trois-Rivières
• EconomicRegionName Côte-ouest–Northern Peninsula–Labrador — Statistics Canada, accented in the file itself

Census geography: Federal Electoral District names and Census names include both English and French official names where applicable, sourced directly from Statistics Canada's bilingual standards.

The honest answer: Canada Post does not release official latitude/longitude coordinates for Postal Codes. Canada Post considers precise geocoding data proprietary.

Our solution: We use crowd-sourced and verified coordinates compiled from multiple sources including:

• Statistics Canada PCCF (Postal Code Conversion File) representative points
• Municipal address databases
• OpenStreetMap community contributions
• Customer-reported corrections and validations

What this means for accuracy:

• ~99% coverage: Nearly all Postal Codes have coordinates
• Urban areas: Typically accurate to within a few hundred meters (suitable for most business applications)
• Rural areas: May represent a broader area center point rather than a specific address
• New Postal Codes: Initial coordinates refined over time as we receive validation data

Continuous improvement: We update and refine coordinates monthly based on user feedback and new validation sources. If you discover inaccurate coordinates, report them to us and we'll investigate and correct them in the next update.

Why not buy "perfect" coordinates? Hyper-accurate, commercially licensed geocoding data exists but costs significantly more (often 10-20x our pricing). Our approach balances accuracy with affordability-good enough for radius searches, mapping, and territory analysis while keeping the database accessible to small businesses and developers.

Bottom line: Our coordinates work well for store locators, territory mapping, distance calculations, and demographic analysis. If you need sub-meter precision for specialized GIS applications, consider pairing our data with a commercial geocoding service.

PCCF (Postal Code Conversion File) is Statistics Canada's official linkage between Postal Codes and Census geography. It's the key to unlocking comprehensive demographic analysis.

What PCCF integration gives you:

Every Postal Code in our Business edition connects to multiple layers of Census geography:

• Census Metropolitan Areas (CMA): Major urban centers (Toronto, Montreal, Vancouver, etc.)
• Census Divisions (CD): Regional municipalities and counties
• Census Subdivisions (CSD): Cities, towns, villages-the actual municipalities
• Dissemination Areas (DA): Small, stable neighborhood areas (400-700 people)-the building blocks of Census data
• Census Tracts (CT): Larger neighborhoods in urban areas, designed for demographic trend analysis
• Federal Electoral Districts (FED): Current federal riding boundaries for political analysis
• Economic Regions (ER): Groups of divisions with similar economic characteristics
• Population Centres (PC): Urban core classifications (urban, rural, population center type)

Why this matters: Statistics Canada publishes thousands of demographic variables (income, education, housing, employment, language, immigration, etc.) organized by these geographic areas. With PCCF linkage, you can:

• Join Postal Codes to detailed Census Profile data
• Analyze demographics at the neighborhood level (DA), not just FSA
• Compare areas using consistent Census boundaries
• Track demographic changes over multiple census cycles
• Build sophisticated market segmentation and targeting models

Business edition advantage: PCCF integration is only available in our Business edition. Standard and Deluxe editions include basic FSA-level demographics, but the Business edition gives you the geographic keys to Statistics Canada's entire Census data warehouse.

Where to get Census data: Statistics Canada provides free Census Profile tables on their website. Pair their demographic data with our Business edition's PCCF linkage for powerful demographic analysis without expensive data subscriptions.

Yes! With the included latitude/longitude coordinates, you can calculate straight-line distances using standard formulas:

• Haversine formula: Great-circle distance (most common, accurate for most use cases)
• Vincenty formula: Higher precision for geodesic distance calculations

Implementation options:

• Database functions: Most databases have built-in spatial functions (MySQL's ST_Distance_Sphere(), PostgreSQL's PostGIS)
• Programming libraries: Available for all major languages (Python's geopy, JavaScript's Turf.js, PHP's geodist, etc.)
• FREE Radius Finder Application: Included with every purchase! Desktop application works offline with no expiration. Handles both U.S. ZIP Codes and Canadian Postal Codes. Also available as an online tool in your account.

Performance: With proper database indexing, radius searches across all 892,960 Canadian Postal Codes complete in under a second on modern hardware. Our Radius Finder application is optimized for instant results.

Common use cases:

• Store locators ("find nearest locations to customer's Postal Code")
• Delivery zone pricing ("calculate shipping cost based on distance")
• Sales territory management ("assign accounts within 50km radius")
• Service area coverage ("show all customers within our coverage area")
• Market analysis ("identify demographics within target radius")

Important note: Calculated distances are "as the crow flies" (straight-line), not driving distances. For routing applications requiring turn-by-turn directions, you'll need a routing engine like OSRM, GraphHopper, or Google Maps Directions API.

We offer two update delivery methods for your convenience:

1. Automated FTP/SFTP/FTPS (Recommended for production):

• Free access provided to all customers
• Files published around the 15th of each month
• Set up scheduled tasks/cron jobs to download and import automatically
• Best practice: Schedule imports for the 20th of the month to allow time for any republications (rare, but it happens)

2. Manual download from your account:

• Log in anytime at your account homepage to download the latest version
• Ideal for development environments or occasional updates

Update file options:

• Full database files: Complete dataset in CSV, Excel, and Access formats

Update strategy recommendations:

• Full replacement method (recommended): Most customers replace the entire table monthly. Simplest approach with lowest risk of sync errors.
• Zero-downtime updates: Use database table swapping techniques (e.g., RENAME TABLE old_postalcodes TO backup_postalcodes, new_postalcodes TO active_postalcodes) for production environments.
• Always keep backups: Retain at least the previous month's data before importing new updates.

Import tips: Since we don't provide SQL scripts for Canadian data, use your database's native CSV import tools (MySQL's LOAD DATA INFILE, PostgreSQL's COPY, SQL Server's BULK INSERT). The CSV format is standardized and imports cleanly into all major databases.