Compare Two JSON Files Compare two JSON files by a key field and see which records were added, removed or changed, down to the nested field. Free, in your browser.
Quick answer: Compare two datasets and see what was added, removed or changed.
Related: Data Comparison (CSV and Excel Diff) · Compare Two CSV Files · Compare Two Excel Files · Compare Two Parquet Files · JSON Guides and Free JSON Tools
How to use the Compare Two JSON Files Compare two datasets and see what was added, removed or changed.
Data Comparison shows exactly what changed between two versions of a file. Pick a key column, or use the first column or the first two columns, and it lists rows that were added, removed or changed, down to the cell. Use it to check an export against last month, to review a data migration, or to find which values a script changed. CSV, Excel, JSON, Parquet and Avro are supported, and the two files can be different formats.
Load dataset A and B Pick or type the key column Review and download the differences Tips A key column (like id) matches the same record in both files. Click Use first column as key, pick columns, or type their names. If you choose no key, the first two columns of the files are used as the key. Numbers match by value, so 36 and 36.0 are treated as equal. Dates match across formats too: a text date, an Excel date and a Parquet timestamp at midnight are the same value. Comparing different formats? Columns whose names differ only by case or punctuation (address.city in a CSV and address_city in an Avro file, which cannot hold dots) are matched, and the page tells you which. Use “Ignore case” or “Ignore spaces” to skip trivial differences. Records, not lines This compares the data in two JSON files record by record, not line by line. A list of objects becomes a table with one row per object, you choose a key field such as id, and the tool tells you which records were added, removed or changed. Reordering the records, or changing the indentation, does not count as a change.
Nested objects are flattened into columns, so a change inside a record is reported as that field, for example address.city. Arrays are compared as a whole value.
When to use something else If you want to see the exact lines that changed in a configuration file, a text diff is the right tool. If your JSON is a list of records, such as an API response or an export, comparing by key is clearer. JSON can also be compared with a CSV, Excel, Parquet or Avro file.
Example Input: old.json + new.json, key = id
Output: Added 3 · Removed 2 · Changed 5 (address.city)
Browse by topic Who uses Data Utility Frequently asked questions · Data format benchmark
Frequently asked questions How do I compare two JSON files? Load both files, choose a key field such as id and read the added, removed and changed records. Nested objects are flattened into columns like address.city, so a change deep inside a record is shown as that field.
Does it work for a JSON array of objects? Yes. A JSON file that is a list of objects, or a single object, is read as a table with one row per object. To diff two JSON documents line by line, a text diff tool is a better fit.
Can I compare JSON with CSV or Parquet? Yes. Any two supported formats can be compared, for example an API response saved as JSON against a CSV export.
Which file formats can I compare? CSV, TSV, Excel (.xlsx), JSON, Parquet and Avro, in any combination. For example, compare a Parquet file with the CSV it was made from. Nested JSON and Avro fields are flattened into columns such as address.city.
Will 10 in a CSV match 10 in a Parquet file? Yes. Values are compared by meaning, not by how they are written: 10 equals 10.0, true equals "true", and a date equals the same date in any format. A value only counts as changed if it really differs.
Can Data Comparison do change data capture (CDC)? It does the snapshot version of CDC for files. Compare the earlier and the latest export by key: added rows are inserts, changed rows are updates and removed rows are deletes. It does not read database logs or run in real time.
How does Data Comparison find differences? It matches rows by a key column, or by the first two columns, and shows which rows were added, removed or changed, down to the cell. It works with CSV and Excel files.
Related pages Data Comparison (CSV and Excel Diff) : Compare two CSV, Excel, JSON, Parquet or Avro files by a key column. See inserts, updates and deletes (CDC), cell by cell. Free, in your browser.Compare Two CSV Files : Compare two CSV or Excel files by a key column and see added, removed and changed rows. Free, runs in your browser.Compare Two Excel Files : Compare two Excel (.xlsx) files by a key column and see every added, removed and changed row and cell. Free, and your files stay in your browser.Compare Two Parquet Files : Compare two Parquet files by a key column and see every added, removed and changed row and cell. Free, runs in your browser, nothing is uploaded.Compare Two Avro Files : Compare two Avro files by a key field and list the added, removed and changed records. Reads the embedded schema, runs in your browser. Free.Compare CSV with Parquet : Check that a Parquet file matches the CSV it was made from: find rows and values that differ after a conversion or migration. Free, in your browser.CSV Diff Tool : Find the differences between two CSV files online: which rows were added, removed or changed, cell by cell. Free, in your browser.CDC for CSV and Excel Files (Change Data Capture) : Change data capture for files: compare two CSV or Excel snapshots and list inserts, updates and deletes by key. Free, private, runs in your browser.Topic guides Guides More free tools Avro Viewer Online: Open .avro Files Avro to CSV Converter CSV to Avro Converter Avro to JSON Converter JSON to Avro Converter Parquet to Avro Converter Excel to Avro Converter Avro to Parquet Converter Avro to Excel Converter CSV to Snowflake CREATE TABLE Generator CSV to BigQuery Schema and CREATE TABLE Generator CSV to Databricks Delta DDL Generator CSV to Redshift CREATE TABLE Generator Chart and Pivot Table Builder for CSV and Excel Share a Data Transformation With a Link Export Data Cleaning Steps as SQL, pandas or PySpark Code Offline CSV, JSON, Parquet and Excel Converter Data Contract Generator and Validator ODCS Data Contract Generator Validate a CSV Against a Schema dbt schema.yml Generator from CSV, JSON or Parquet Combine Many Screenshots into One Excel File (with Source Row Tracking) JSON, CSV, Parquet and Excel Converter JSON to CSV Converter CSV to JSON Converter CSV to Parquet Converter JSON to Parquet Converter Parquet to CSV Converter Parquet to JSON Converter CSV to Excel Converter JSON to Excel Converter Excel to CSV Converter Excel to JSON Converter Data Formatter: JSON, CSV, XML and YAML JSON Formatter and Validator CSV Formatter and Cleaner XML Formatter and Validator YAML Formatter and Validator JSON Validator Online JSON Minifier XML Validator Online JSON to YAML Converter YAML to JSON Converter Remove Duplicates from CSV CSV to SQL Converter Excel to SQL Converter Mask Emails in a CSV File Compare Two CSV Files CSV Data Quality Checker JSON Beautifier XML Beautifier YAML Validator Online CSV Delimiter Converter Compare Two Excel Files Compare Two Parquet Files Compare Two JSON Files Compare Two Avro Files Compare CSV with Parquet CSV Diff Tool CDC for CSV and Excel Files (Change Data Capture) Detect Changes Between Two CSV Files Find New, Updated and Deleted Rows Between Two Files Data Reconciliation Tool for CSV and Excel JSON to SQL Converter SQL INSERT Statement Generator Anonymize CSV Data Mask PII in Excel Files Fake Data Generator Test Data Generator TSV to CSV Converter Semicolon CSV to Comma CSV Check a CSV for Duplicates and Blanks CSV Data Profiler Gzip Compress Files Online Compress a CSV File Online Compress a JSON File Online Reduce File Size Online Open a .gz File Online Open .gz Files Online (Gunzip) Image to Excel Converter (OCR) Image to CSV Converter (OCR) Chat with Your CSV File Chat with Your Excel File Generate Data from CREATE TABLE JSON Schema Data Generator File Compressor: Gzip JSON, CSV, XML, YAML, Parquet Screenshot to Table Converter (OCR) SQL INSERT Generator from CSV, JSON, Excel or Parquet Schema-Based Data Generator (JSON Schema) Mock Data Generator Student Data Generator: Fake Student Records Student Marks Dataset Generator Sample Data for SQL Practice Dummy Data for Excel Practice Sample CSV File Generator SQL Lineage Analyzer for a Folder of SQL Files dbt Lineage Viewer for Your SQL Models SQL Column Lineage Tool SQL File Dependency Analyzer SQL Impact Analysis: What Breaks If a Table Changes SQL File Lineage Tool SQL Query Visualizer Visualize a SQL Query as a Diagram SQL Dependency Graph Generator How to See Which Tables a SQL Query Uses Free SQL Lineage Tool Online SQL Data Flow Diagram Generator dbt Project Visualizer dbt Project Visualizer for GitHub Repositories dbt DAG Viewer Online How to Visualize a dbt Project Without dbt Docs dbt Model Dependency Graph Generator Free dbt Docs Alternative for Lineage Graphs Free dbt Column Lineage Tool Cloud Storage Cost Calculator: AWS S3 vs Azure Blob AWS S3 Cost Calculator Azure Blob Storage Cost Calculator Amazon S3 vs Azure Blob Storage Cost S3 Glacier Cost Calculator Data Profiler Data Comparison (CSV and Excel Diff) Chat with Your Data Data Dictionary Generator Dataset README Generator Free Data Lineage Tool: Transform Data and Download the Lineage API Response to Table: JSON API to CSV JSON API Response to CSV Document Database Columns with AI Generate SQL Column Comments README for a CSV Dataset Dataset Documentation Generator Delete Columns from a CSV File Reorder Columns in a CSV File Remove Empty Rows and Columns from CSV Find and Replace in a CSV File Change Date Format in a CSV File Convert Excel Date Numbers to Dates File Size Calculator: CSV, JSON, Excel, Parquet Merge or Split Files: CSV, JSON, Excel, Parquet Combine Multiple CSV Files into One Merge Parquet Files into One Split a CSV File into Parts Split a Large CSV into Smaller Files Split a Parquet File into Parts Text to Table: Paste Text, Get a Table Paste Text into a Table for Excel Convert Text to CSV Markdown Table to CSV Copy a PDF Table into Excel HTML Table to CSV JSON Lines (JSONL) to CSV Log Lines to CSV SQL Query Result to CSV Fixed-Width Text to CSV Screenshot to CSV Screenshot to Excel Picture to Excel Photo of a Table to Data PNG to Excel Converter JPG to Excel PNG to CSV OCR Table to Excel Convert Many Images to Excel Batch Screenshot to CSV Offline CSV Converter (Desktop App) CSV Converter Desktop App Extract a Table from an Image Table Image to CSV Screenshot to Google Sheets PDF Table Screenshot to Excel Screenshot to JSON Screenshot to Parquet JPG to CSV Bank Statement Screenshot to Excel Generate Test Data from Production Data Anonymize CSV Data for Testing GDPR Test Data Generator Open a Large CSV File Online Convert a Large CSV to Parquet Query a Large CSV with SQL Split a Large JSON or NDJSON File JSON Table Editor: Edit Nested JSON as a Table JSON Visual Editor Online Edit JSON as a Table JSON Array to Editable Table SQL on Your Files: Query CSV, Excel and Parquet Query a CSV File with SQL Run SQL on an Excel File Query Parquet Files Online Join CSV Files with SQL DuckDB in Your Browser Synthetic Data Generator: Realistic Data From Your File Generate Synthetic Data from a CSV Privacy-Safe Test Data from Real Data Synthetic Dataset from an Excel File Data Transformation: Join, Trim, Concatenate Join Two CSV Files on a Key Merge CSV Files by a Common Column VLOOKUP Alternative for CSV and Excel Files Join Two Excel Files on a Key Column Concatenate Columns in a CSV File Trim Spaces in a CSV File Split a CSV Column into Two or More Filter CSV Rows Online Combine First and Last Name Columns Data Lineage Version History Free Data Lineage Tool Data Lineage Report as HTML Share Your Data Together with Its Lineage Data Audit Trail for CSV and Excel Files Data Provenance Tool for Files Parquet to Excel Converter Excel to Parquet Converter Parquet Viewer Online CSV Viewer Online Flatten Nested JSON to CSV Open a Parquet File Without Python Ask Questions to a CSV File with AI Talk to Your Data: Free AI Data Chat Chat with a JSON File Chat with a Parquet File Free AI Data Analysis Tool Analyze a CSV with AI AI Data Dictionary Generator Data Dictionary from a CSV File Write Column Descriptions with AI README Generator for a Dataset README for a GitHub Dataset Mask Phone Numbers in a CSV Mask Credit Card Numbers in a File Mask Names in a CSV File Hash Columns in a CSV File Pseudonymize Data Online Mask Sensitive Data in JSON Test Data Masking Anonymize an Excel File Free Data Anonymization Tool PII Detection Tool for CSV and Excel Mask Data Before Sharing GDPR Data Anonymization for Files AI Data Generator That Learns From Your File Synthetic Test Data Generator Synthetic Data for Machine Learning Generate Fake Customer Data Synthetic Data vs Masked Data What Is Data Lineage? Track It Free Data Lineage for Excel Files Data Lineage for JSON Files Data Lineage Example Data Lineage for GDPR and Audits Data Dictionary Maker How to Chat with a CSV File Data Profiler Online Fake Database for Testing XLS to CSV Converter XLSX to CSV Converter Online Excel to CSV Converter Convert JSON to a Spreadsheet Export CSV to JSON CSV to JSON Converter: Typed Values, Large Files JSON Parser Online XML Pretty Print Format XML Online Format YAML Online YAML Lint: Check YAML for Errors Format CSV Online JSON Pretty Print Format JSON Online JSON Lint: Check JSON for Errors Fix Invalid JSON Online JSON Syntax Checker Sort JSON Keys Alphabetically CSV Validator Online Clean a CSV Online JSON Viewer Online Edit JSON Online View JSON as a Table JSON to Table Online Edit Nested JSON Data Lineage for Parquet Files Data Lineage for CSV Files Data Lineage Tool: Track Every Change to a File Track Changes Made to a Data File Free Column-Level Data Lineage Tool Free Column Lineage Tool What Is Column-Level Lineage? Column-Level Lineage for CSV Files How to Trace a CSV Column to Its Source Column Lineage Example How to Check Personal Data Was Masked SQL Column Lineage for Your Files Data Masking and Anonymization About Data Utility: Free Online Data Tools Privacy Policy Terms of Use Contact Data Utility Blog & Guides How to Convert JSON, CSV, Parquet and Excel Files Online How to Convert JSON to CSV in 4 Steps (Free, Private) How to Convert CSV to JSON in 4 Steps (Free, Private) How to Convert CSV to Parquet in 4 Steps (Free, Private) How to Convert JSON to Parquet in 4 Steps (Free, Private) How to Convert Parquet to CSV in 4 Steps (Free, Private) How to Convert Parquet to JSON in 4 Steps (Free, Private) How to Convert CSV to Excel in 4 Steps (Free, Private) How to Convert JSON to Excel in 4 Steps (Free, Private) How to Convert Excel to CSV in 4 Steps (Free, Private) How to Convert Excel to JSON in 4 Steps (Free, Private) Data Formatter: Fix and Format JSON, CSV, XML and YAML JSON Formatter and Validator: Fix Broken JSON Online How to Clean a CSV File Online: Remove Duplicates and Empty Rows XML Formatter and Validator: Beautify and Check XML YAML Formatter and Validator: Check and Fix YAML Screenshot to Table: Image to Excel, CSV or Parquet (OCR) SQL INSERT Generator: Turn CSV, Excel or Parquet into SQL Free Mock Data Generator: Realistic Test Data in 1 Minute Data Profiler: Check Data Quality Before You Use It Compare Two CSV or Excel Files: Find Added, Removed and Changed Rows Data Masking: Hide Emails, Phones and Names Before Sharing Chat with Your Data: CSV, Excel, JSON and Parquet (Free AI) Data Dictionary Generator: CREATE TABLE with AI Descriptions Dataset README Generator: Explain Your Data with AI Password-Protected Data Reports: Share a Locked HTML File How to Compress JSON, CSV, XML, YAML and Parquet Files Generate Test Data from a CREATE TABLE (500k Rows) CSV vs JSON vs Parquet vs Excel: Differences and Which to Use How to Open a Parquet File: 3 Free Ways (No Python Needed) Free Data Lineage Tool: Share Your Result with Its Lineage Column-Level Data Lineage: Follow Every Column, Free Tool Data Lineage: See Which Tool Changed Your File Data Transformation: Join, Trim and Concatenate Files Online VLOOKUP Alternative: Join Two CSV or Excel Files Online How to Concatenate Columns in a CSV (First and Last Name) How to Turn an API Response into a CSV (With a Bearer Token) How to Flatten Nested JSON From an API Into Columns CSV vs Parquet: File Size Test With 100,000 Rows Convert CSV to Parquet: pandas, DuckDB or Your Browser What Is Parquet? The Columnar File Format Explained CSV to JSON, Excel or Parquet: Size and Speed Test How Much Does Gzip Shrink CSV, JSON, Parquet and Excel? How to Fix Mixed Date Formats in a CSV (With Examples) Turn a Public API into a Table: A Worked Example CSV vs JSON: Which One Should You Use? JSON vs Parquet: Which Format Should You Choose? Excel vs CSV: Which Should You Use for Data? VLOOKUP vs Join: Which Is Better for Combining Files? How to Merge Many CSV Files into One File How to Split a Large CSV File into Smaller Files How to Copy a Table from a PDF or Web Page into Excel Synthetic Data vs Random Fake Data: What Is the Difference? How to Generate Synthetic Data From a CSV, Step by Step How to Convert Many Screenshots to Excel or CSV at Once How to Run SQL on CSV, Excel and Parquet Files in Your Browser Reuse an Edited File in Another Tool: Recent Files Synthetic Data Without Python: Online Alternative to SDV How to Check the Quality of Synthetic Data (Checklist) Test Data Without Production Data: 3 Safe Ways Financial API JSON to Excel: Flatten It Without Python CSV vs Parquet for Market Data (OHLCV): What to Use JSON to Parquet for Tick Data, Without Writing Python Meta Ads and Google Ads Data to Excel: A Practical Guide How to Clean Marketing Campaign Data in a CSV Compare Two Financial Files: A Simple Reconciliation Test Data for a Trading or Analytics System (OHLCV) Mask Customer Data Before You Share a Report Data Quality Checks Before You Run a Backtest Data Lineage for Finance Reports: Show How a Number Was Made Data Lineage vs Data Provenance vs Audit Trail vs Data Catalog How Data Utility Data Lineage Differs From Other Lineage Tools Data Lineage for CSV and Excel Files: A Practical Guide Data Lineage for Personal Data: Show a Column Was Masked API Response to Table: Tokens, API Keys and CORS Errors API JSON to CSV Without Python: Browser vs curl and jq What Is Data Utility and Why It Matters: Free Data Tools in Your Browser Data Lineage for JSON Files: Track Every Change Data Lineage for Parquet Files: What Changed, Step by Step Data Lineage for Avro Files: Convert and Keep a Record REST API Market Data to CSV: Prices to a Table Large CSV and Parquet Files: Work With Them in a Browser Prepare Historical Price Data for Backtesting Mock API Data for Frontend and Backend Testing How to Compare Two JSON API Responses Test Data for QA and Automation Without Real Customers Synthetic Data for Machine Learning: What It Can Do Clean Your Dataset Before Training a Machine Learning Model Convert a JSON Dataset to Parquet for ML Work Free Online Data Tools for Students and Learners How to Generate a Dataset for a College Project Learn and Practise SQL on CSV Files, Free Compare Inventory and Stock Files Between Two Dates Generate Test Data for ETL and Pipeline Testing How to Profile a Large Dataset Online Clean an E-commerce Product Feed CSV Before Upload How to Open a CSV File Without Excel (Free, No Install) Free Practice Datasets for SQL, Excel and Data Science Projects Practice SQL on a CSV File Without Installing a Database REST API Market Data to Excel: Prices to a Sheet REST API Market Data to Parquet, Without Python Financial API JSON to CSV: Flatten It Without Code Financial API JSON to Parquet: Typed Columns, No Code JSON Tick Data to CSV: Convert Trades and Quotes JSON Tick Data to Excel: Trades and Quotes to a Sheet Meta Ads and Google Ads Data to CSV for Reporting Product Feed from Excel to CSV for Marketplaces CSV Market Data to Parquet: Faster, Smaller Files Excel Price History to CSV for Backtesting Excel Financial Statements to CSV for Analysis Excel Dataset to Parquet for Machine Learning Open Parquet Market Data in Excel or CSV Meta Ads and Google Ads Data to Parquet REST API Market Data to Clean, Flat JSON Financial API Response to Flat JSON, Without Code CSV Tick Data to JSON for Charts and Apps Meta Ads and Google Ads Data to JSON Product Feed CSV to Excel for Easy Editing Product Feed CSV to JSON for Shop APIs Product Feed CSV to Parquet for Analysis CSV Price History to Excel Without Errors CSV Market Data to JSON for Web Apps and Charts Parquet Market Data to JSON for Apps and APIs Excel Price History to Parquet for Research Excel Financial Statements to JSON for Apps Excel Financial Statements to Parquet for Analysis CSV Financial Data to Excel for Reports CSV Dataset to Parquet for Machine Learning JSON Dataset to CSV for Machine Learning Parquet Dataset to CSV for Tools That Need It Generate Test Data as CSV Online Generate Test Data as Excel Online Generate Test Data as JSON Online Generate Test Data as Parquet Online Mask Personal Data in a Parquet File, No Code Flatten a Financial API Response to CSV Flatten a Financial API Response to Excel Flatten a Financial API Response to Parquet Change Data Capture (CDC) for CSV and Excel Files CDC vs Snapshot Comparison: Which Should You Use? SQL Practice Questions for Students, With Sample Data Excel Practice Exercises With Free Sample Data Practise Pandas With a Sample CSV, No Kaggle Needed Five Data Science Mini Projects You Can Start Today Data Cleaning for Beginners: A Step-by-Step Checklist What Is a CSV File? A Plain-English Guide for Beginners Sample Data and INSERT Statements for a DBMS Lab Convert Excel to CSV for a Python or R Assignment Screenshot to JSON: Turn a Table Image into JSON Screenshot to Parquet: Save a Table Image as a Parquet File Free Online Data Conversion Tools: What to Use for Each Job How to Estimate Cloud Storage Cost: Amazon S3 vs Azure Blob Combine Many Screenshots into One Excel File and Trace Rows How to Open an Avro File and Convert It to CSV or JSON CREATE TABLE for Snowflake, BigQuery, Databricks and Redshift One-Click Code Export: SQL, pandas, PySpark and dbt From Your Data Transformations How to Clean, Transform and Chart a CSV Online, Step by Step How to Share Your Data Transformation Steps With a Link Use Free Data Tools Offline: Install Data Utility as an App Add Calculated Columns, Group By and Extract Text in a CSV Online Fake Patient Data: Free Healthcare Test Data for Patients, Visits and Lab Results Pharmaceutical Sample Data: Prescriptions, Drug Inventory and Clinical Trial Subjects Fake Bank, Loan and Insurance Claims Test Data (IBAN, Credit Score, Claim Status) Flight Booking and Shipment Sample Data: Free Travel and Logistics Datasets Sample Web Server Log and Telecom Subscriber Data for Testing and Practice Real Estate Listings Sample Dataset: Free Property Data for Dashboards and SQL Mask a Trade Blotter Before Sharing a Backtest: Accounts, Counterparties and Sizes Mask Bank Transactions for Testing and Audits: IBANs, Card Numbers and Account Holders Share a General Ledger or AP Export Without Vendor and Employee Data Sample Marketing Campaign Dataset: Ads, Clicks, Spend and Conversions Fake CRM Contacts CSV for Testing Imports, Email Flows and Lead Reports SQL for Financial Analysts: Returns, Moving Averages and Drawdown from a Price CSV Generate Test Data With Foreign Keys: Linked Tables That Actually Join Data Lineage Version History: See What Changed Between Versions Free SQL Query Visualizer: See Tables, Joins and Columns Online How to Understand an Inherited SQL Project in Minutes (Free) Free dbt Lineage Visualizer: Explore Your Entire dbt Project in the Browser Best Free dbt Lineage Tools for Data Engineers (and When to Use Each) How to Visualize dbt Project Dependencies: A Step-by-Step Guide How to Understand dbt Model Dependencies (ref, source and the DAG) How to Analyze a dbt Project Without a Database Connection What Is SQL Data Lineage? A Complete Practical Guide How to Visualize SQL Data Lineage Automatically (From a Folder of SQL Files) Table-Level vs Column-Level Data Lineage: Which Do You Need? How to Trace Data Across Multiple SQL Files Without Reading Them All Why Data Lineage Matters for Data Engineers (Beyond Compliance) What Is Column-Level Data Lineage? Explained With SQL Examples How to Track Column Dependencies Across SQL Transformations Column-Level Data Lineage for Analytics Engineers (Straight From Your dbt Models) How to Perform SQL Column Impact Analysis Before You Change Anything How to Find SQL Dependencies Across Multiple Files How to Determine the Execution Order of SQL Scripts (Which File Runs First?) How to Identify Downstream Dependencies Before Changing SQL SQL Dependency Mapping for Large Data Projects: A Practical Playbook Best Free SQL Data Lineage Tools in 2026 (and What Each Is Good For) Free dbt Lineage Visualizer vs Enterprise Data Lineage Platforms: What You Actually Need Browser-Based vs Server-Based SQL Lineage Tools: How to Choose How to Analyze SQL Lineage Without Uploading Files to a Server Visualize Any Public dbt Project From GitHub, Without Cloning It See Your dbt YAML Descriptions and Tests Next to the Lineage Graph Check What a dbt Change Breaks Before You Merge Find Unused dbt Macros and See Which Models Use Them Edit Your SQL and See What Breaks: What-If Impact Analysis How to Trace Personal Data (PII) Through Your SQL Models SQL Lineage vs dbt Lineage: What's the Difference? How to Visualize a SQL Query With Joins, CTEs and Subqueries Data Contract Example in YAML: Write One and Validate a CSV Against It Free Data Tools for Startups: Convert, Query, Mask and Trace Data in Your Browser A Startup Data Stack on a Zero Budget: What You Actually Need Startup Analytics Without a Data Engineer: A Free, Practical Guide How to Prepare Startup Data for Investor Due Diligence Customer Data Privacy for Startups: Practical Steps That Do Not Slow You Down Free Alternatives to Paid Data Tools for Startups: What You Can Skip For Now Moving a Startup From Spreadsheets to a Database: A Step-by-Step Guide Free Data Profiling Tool for Data Analysts: Check a File Before You Analyze It Free Data Tools for Business Analysts: Clean, Join and Report Without IT Free Data Tools for Product Analysts: Event Exports, Funnels and Cohorts Free Data Tools for Data Engineers: Quick Checks Without Spinning Up a Pipeline Free Data Tools for Finance Analysts: Reconcile, Convert and Audit in Your Browser Free Data Tools for Marketing Analysts: Clean, Merge and Report Campaign Data Free Data Tools for Advertising and PPC Analysts: Audit Spend and Search Terms Free Data Tools for Quant Analysts: Prepare Price Data, Parquet and Test Fixtures How to Compare Two Files in Different Formats: CSV, JSON, Excel, Parquet and Avro Compare a CSV and a JSON File by Key: Nested Fields, Types and Missing Values Validate a Data Migration by Comparing Source and Target Files Data Contract Template (ODCS YAML): Copy It and Learn What Every Line Means Data Contract Rules Explained: Required, Unique, Allowed Values, Range and More Validate a Vendor CSV Before Loading It Into Your Warehouse Data Contracts for Small Teams and Startups: Start With One File From Data Contract to dbt Tests: Generate schema.yml From a File Data Contract Versioning: What Counts as a Breaking Change Avro vs Parquet: Real File Size Test and When to Use Each 33 Free Fake Datasets by Industry: From Orders and Healthcare to Climate Data Format Benchmark: CSV, JSON, Excel and Parquet dbt Project Visualizer and dbt Lineage Guides Avro Guides and Free Avro Tools Snowflake, BigQuery, Databricks and dbt Tools Export and Share Data Transformations as SQL, pandas and PySpark Offline and Private Data Tools Parquet Guides and Free Parquet Tools CSV Guides and Free CSV Tools JSON Guides and Free JSON Tools Excel Guides and Free Excel Tools Data Privacy Guides and Free Tools Test Data Guides and Free Generators Data Cleaning Guides and Free Tools AI Data Tools and Guides Extract Data from Screenshots and APIs Data Lineage and Audit Trail Guides File Format Guides and Free Tools Free Data Tools for Marketing Lists Free Data Tools for Finance and Accounting Exports Free Data Tools for Developers Free Data Tools for Data Analysts Free Data Tools for Small Business Data Tools for Quant Developers and Finance Teams Test Data Tools for QA Engineers Free Data Tools for Data Engineers Free Data Tools for Students and Educators Frequently Asked Questions Data Utility Features Data Utility Use Cases