Universal Data Cleaning Planner
Profile a dataset, detect problems, get prioritized fixes, preview changes, and export cleaned data with a data dictionary.
Data Analytics & Transformation Tools
A complete data workflow toolkit that runs entirely in your browser. Profile and clean datasets, check data quality, translate logic between Excel, SQL, Power Query, pandas, and DAX, and handle every date and time problem — without uploading your data anywhere.
19 tools · Local processing · No account required · No uploads
Tools in this category
Cross-Platform Transformation Engine
Describe one transformation and get the equivalent for Excel, SQL, Power Query, pandas, and DAX — with caveats.
Data Quality & Readiness Analyzer
Readiness scores for SQL, Power BI, and machine learning — with prioritized blockers and suggested fixes.
Data Dictionary / Schema Documenter
Auto-generate a shareable data dictionary from any CSV — inferred types, fill rates, ranges, and samples.
Column Semantics / PII Detector
Label every column — email, phone, SSN, card, date, ID — and flag personal data before you share a dataset.
SQL ↔ Pandas Query Translator
Translate SQL SELECT queries into pandas code and back — selection, filters, GROUP BY, ORDER BY, LIMIT.
Excel ↔ SQL Type & Formula Translator
Convert SUMIF, COUNTIF, IF, and VLOOKUP formulas to SQL and back, plus a data-type mapping reference.
CSV Pivot / Unpivot Transformer
Reshape wide ↔ long CSV locally with aggregation — like pandas melt / pivot_table or Power Query unpivot.
CSV to SQL INSERT Generator
Convert CSV rows into SQL INSERT statements with dialect quoting, batching, and NULL handling.
SQL Relationship & Join Analyzer
Paste two sample tables, pick the keys, and see the relationship type, expected row counts, and explosion warnings.
SQL Window Function Explainer
Run ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, and running aggregates on live sample data.
JSON Structural / API Response Comparator
Compare two JSON documents semantically — order-insensitive arrays, type-aware changes, schema drift.
Date & Time Toolkit for Data
Unix epoch, Excel serial dates, ISO formats, date arithmetic, and relative time — all DST-aware and local.
Data Type Cross-Reference Mapper
Map column data types across Excel, SQL Server, MySQL, PostgreSQL, Power BI, and pandas with gotchas.
Number & Unit Format Converter
Convert number bases, data sizes (KB vs KiB), length, mass, and temperature, plus number-to-words.
Excel Formula Generator
Build VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS, IF, IFS, and TEXTJOIN formulas visually with explanations.
DAX Formatter & Measure Builder
Format DAX expressions locally and generate YTD, YoY, MoY, and moving-average measures for Power BI.
Cron Expression Explainer
Translate cron expressions into plain English with a field-by-field breakdown and next-run previews.
Timezone Meeting Overlap Finder
Find a common meeting time across timezones with a DST-aware 24-hour grid and local-time summary.
How this toolkit fits together
Data work rarely happens in one tool. A dataset arrives as a CSV, gets cleaned, loads into a database, feeds a BI model, and ends up in a report. This category follows that journey:
- Understand the data — profile columns, detect PII, and document the schema.
- Fix the data — clean, deduplicate, reshape, and validate quality.
- Move the logic — translate transformations between Excel, SQL, Power Query, pandas, and DAX.
- Handle the details — dates, times, numbers, and schedules that trip up every pipeline.
Every tool processes your data locally in the browser. Nothing is uploaded, which matters when you are working with real business data or personal information.