Built for practitioners who care about data quality.

What is MyDataTools?

MyDataTools is a public-facing set of free data utilities operated by MyWaypoint Technologies Inc., a Canadian company. The tools are designed to be immediately useful to data analysts, developers, GIS practitioners, data stewards, and anyone who works with structured data as part of their work.

Every tool runs entirely in the browser using client-side JavaScript. No files are uploaded, no data is retained, and no account is required. You can use any tool immediately, on any device, without identifying yourself.

Why free tools?

Data quality problems are universal. Whether you're a small municipality managing open data, a nonprofit working with grant data, or a developer building a data pipeline, you'll encounter the same categories of issues: missing values, inconsistent formatting, undocumented columns, files with encoding problems, and datasets that may contain personal information they shouldn't.

These are solvable problems. Good tooling should not require a subscription, a sign-up, or the willingness to upload sensitive data to a third-party server. MyDataTools provides these utilities free of charge and processes everything locally.

The tools

The current toolkit includes:

• Data Health Checker — comprehensive quality scoring, completeness analysis, and duplicate detection
• CSV Validator — delimiter, encoding, header, and schema validation
• PII Scanner — pattern-based detection of email addresses, phone numbers, postal codes, and SIN numbers
• Dataset Documentation Generator — auto-generated data dictionaries with type inference and statistics
• Postal Code Lookup — offline Canadian postal code and FSA resolution
• Address Geocoder — Canadian address geocoding via OpenStreetMap Nominatim
• Dataset Change Monitor — row-level comparison of two CSV versions with downloadable report
• Column Profiler — detailed per-column statistics with frequency counts and numeric ranges
• Data Anonymizer — column removal, redaction, replacement, and pseudonymisation
• Schema Profiler — inferred types, nullability, uniqueness, candidate keys, and mixed-type warnings
• Dataset Merger — inner, left, right, and full joins on a shared key column
• Data Standardizer — normalise whitespace, case, provinces, postal codes, dates, and phone numbers

About MyWaypoint Technologies Inc.

MyWaypoint Technologies Inc. is a Canadian company that builds data products, information resources, and tools that make it easier to discover and use public information.

MyDataTools is our contribution to the broader data community. Rather than being a commercial product, it was created to provide practical, free tools that help researchers, businesses, journalists, students, and curious Canadians work more effectively with data.

Looking for more datasets, resources, and projects? Visit MyDataHub.ca, our central directory of Canadian data resources.

Privacy commitment

MyDataTools does not set cookies, run analytics, load third-party scripts, or track visitors in any way. This is not a marketing claim — it is a structural property of the site. There is nothing to configure, no consent to manage, and no data to delete, because none is collected.

For file-based tools, all processing happens in your browser. For the Address Geocoder, your query is sent directly from your browser to OpenStreetMap's Nominatim service — not through our servers.

See our Privacy Policy and Cookie Policy for full details.