Skip to main content
EN | FR

Free · Canadian · Privacy-First

Free data tools for organizations, analysts and data stewards.

Validate, clean, document and understand your data with professional-grade utilities that run entirely in your browser. No sign-up. No uploads stored. No tracking.

  • No cookies or tracking
  • Files never leave your browser
  • Canadian-operated
  • 100% free — no account required

The Toolkit

Validate and assess your datasets

Data Health Checker
Upload any CSV and receive a comprehensive health report: completeness percentage, duplicate row detection, per-column missing value analysis, data type inference, and an overall quality score out of 100.
CSVQuality ScoreDuplicatesCompleteness
Use this tool
CSV Validator
Run a structured validation pass on any CSV file. Checks delimiter consistency, header quality, row length uniformity, encoding issues, duplicate headers, and more. Results shown as pass / warn / fail.
CSVEncodingHeadersSchema
Use this tool
Dataset Change Monitor
Compare two versions of a dataset side by side. Identify added, removed, and modified records. View changes by category and download a complete change report as a CSV.
CSVDiffVersion Compare
Use this tool
Column Profiler
Generate detailed statistics for every column: inferred type, non-empty and missing counts, distinct value count, numeric min/max/average, text length range, and the most frequent values with counts.
CSVStatisticsFrequencyProfiling
Use this tool

Privacy & Compliance

Protect sensitive information

PII Scanner
Scan uploaded files for personally identifiable information: email addresses, phone numbers, Canadian postal codes, potential SIN numbers, and other personal identifiers. Findings displayed only — no data stored.
PrivacyPIIPIPEDACompliance
Use this tool
Data Anonymizer
Choose which columns to transform before sharing a dataset. Remove, redact, replace with a fixed label, keep only the last 4 characters, or generate consistent pseudonymous IDs. Before/after preview included.
PrivacyRedactPseudonymizeMasking
Use this tool

Documentation

Understand and document your data

Dataset Documentation Generator
Upload a CSV and automatically generate a data dictionary: column names, inferred data types, completeness statistics, unique value counts, min/max values, and sample content. Downloadable as CSV.
Data DictionaryMetadataSchema
Use this tool
Schema Profiler
Get a structural profile of a flat CSV: inferred column types, nullability, uniqueness, candidate single-column keys, constant columns, mixed-type warnings, and formatting inconsistencies. All findings labelled as candidates or warnings.
SchemaStructureKeysWarnings
Use this tool

Data Preparation

Clean, merge, and transform your data

Dataset Merger
Combine two CSV datasets using a shared key column. Supports inner, left, right, and full joins. Warns on duplicate keys, handles column name collisions, and previews the merged result before download.
CSVJoinMergeCombine
Use this tool
Data Standardizer
Normalize formatting in a selected column: trim whitespace, fix case, standardize Canadian province names or abbreviations, reformat postal codes, normalize dates to YYYY-MM-DD, and reformat phone numbers. Preview before applying.
CSVNormalizeCanadaFormatting
Use this tool

Geographic

Work with Canadian locations

Postal Code Lookup
Look up Canadian postal codes and FSAs (Forward Sortation Areas) to get province, territory, city, and area information. Works entirely offline — no API calls, no network required.
CanadaFSAOfflineProvince
Use this tool
Address Geocoder
Convert Canadian street addresses to latitude and longitude coordinates. Returns standardized address format. Uses OpenStreetMap Nominatim — your query goes directly from your browser to their service.
GeocodingLat/LngCanada
Use this tool

Why It Matters

Bad data is expensive. Good tools help.

Poor data quality costs organizations significant time and resources. These tools help you catch issues early — before they affect decisions, reports, or downstream systems.

Catch issues before they compound

Duplicate rows, blank fields, and encoding errors are cheap to fix early and expensive to find later. Run a health check on every dataset before it enters a pipeline or report.

Protect personal information

Privacy obligations under PIPEDA and provincial legislation require you to know what personal information your datasets contain. The PII Scanner helps you find it before sharing.

Document what you have

Data without documentation degrades over time. Generate a data dictionary automatically so your team understands each column's meaning, type, and quality without manual effort.

Privacy by Design

Your files never leave your browser.

Every tool on this site processes your data entirely client-side using JavaScript in your browser. We do not operate a processing server. Files are never uploaded, stored, logged, or transmitted.

No cookies. No analytics. No tracking.

We do not set cookies, load analytics scripts, embed third-party pixels, or use any form of behavioural tracking. This site is static HTML with first-party JavaScript only.

Static site. Client-side processing only.

There is no server application processing your data. When you upload a file, it is read by your browser's built-in JavaScript engine and never leaves your device.

Canadian-owned and operated.

MyDataTools is operated by MyWaypoint Technologies Inc., a Canadian company. We do not rely on foreign surveillance-economy platforms to deliver this service.

No sale of personal information.

We do not sell, share, or trade any information about visitors. Our contact form collects only what is necessary to respond, and nothing more.

Read our Privacy Policy

MyWaypoint Ecosystem

Explore the Full Ecosystem

Looking for datasets, learning resources, digital services, governance information, or additional data products? Visit MyDataHub.ca to explore the complete MyWaypoint ecosystem.

Explore MyDataHub Contact Us

NEW TO DATA?

Want to understand the concepts behind these tools?

Explore free, beginner-friendly lessons covering data, software, AI, privacy, cybersecurity, and digital skills at MyData101.ca.

Start Learning