CSV / Excel Diff Tool

Compare two CSV or XLSX datasets and export a PDF report with row, column, and cell-level differences

Upload or paste two CSV/XLSX sources, compare values, types, or formats, and export a colored PDF summary for QA or review workflows.

Example Results

1 examples

Compare two pricing snapshots and export a PDF diff

Highlight added rows, deleted rows, and modified cells between two spreadsheet versions for QA sign-off

csv-excel-diff-tool-example1.pdf View File
View input parameters
{ "leftInput": "id,sku,price,status\n1,A-100,29.99,active\n2,A-200,45.00,active", "rightInput": "id,sku,price,status\n1,A-100,29.99,active\n2,A-200,49.00,active\n3,A-300,15.00,draft", "keyColumns": "id", "compareMode": "all", "reportTitle": "Pricing Snapshot Diff" }

Click to upload file or drag and drop file here

Maximum file size: 20MB Supported formats: text/csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel, text/plain

Click to upload file or drag and drop file here

Maximum file size: 20MB Supported formats: text/csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel, text/plain

Key Facts

Category
Data & Tables
Input Types
textarea, file, text, select
Output Type
file
Sample Coverage
4
API Ready
Yes

Overview

The CSV / Excel Diff Tool allows you to compare two spreadsheet datasets and generate a detailed PDF report highlighting row, column, and cell-level differences. By uploading CSV or XLSX files and specifying key columns, you can easily identify modified values, added records, or deleted rows, making it ideal for QA testing, financial reconciliation, and data review workflows.

When to Use

  • •When you need to verify data migrations or system updates by comparing pre- and post-deployment spreadsheet exports.
  • •When reconciling financial reports or pricing lists to quickly spot modified values, missing rows, or formatting changes.
  • •When conducting QA testing on localized content or product catalogs to ensure no unintended data alterations occurred.

How It Works

  • •Upload your original CSV or XLSX file as the left input and the updated version as the right input, or paste the raw data directly.
  • •Specify the key columns (e.g., 'id' or 'email') to align the rows accurately between the two datasets.
  • •Select a compare mode to evaluate cell content, data types, formatting, or all three simultaneously.
  • •Generate and download a color-coded PDF report summarizing all additions, deletions, and modifications.

Use Cases

QA engineers verifying database exports before and after a major system migration.
E-commerce managers tracking daily price and inventory changes across large product catalog spreadsheets.
Finance teams reconciling monthly ledger exports to identify discrepancies or missing transactions.

Examples

1. Compare Pricing Snapshots

E-commerce Manager
Background
The pricing team updates a master product catalog weekly. Reviewing thousands of rows manually to find price changes is error-prone.
Problem
Need to quickly identify which product prices were updated, added, or removed between last week's and this week's catalog.
How to Use
Paste the old CSV data into the Left Input and the new CSV data into the Right Input. Set 'Key Columns' to 'id' and 'Compare Mode' to 'all'.
Example Config
Key Columns: id
Compare Mode: all
Report Title: Pricing Snapshot Diff
Outcome
A PDF report is generated highlighting the modified price for existing SKUs and flagging any newly added or deleted rows.

2. Monthly Ledger Reconciliation

Financial Analyst
Background
At the end of the month, the analyst receives two ledger exports from different accounting systems that should match.
Problem
Finding missing transactions or mismatched amounts between two large Excel files.
How to Use
Upload the first system's export as the Left File and the second system's export as the Right File. Enter 'transaction_id' as the Key Column and select 'Cell Content Only'.
Example Config
Key Columns: transaction_id
Compare Mode: content
Outcome
A clean PDF diff showing exactly which transaction IDs are missing from the second system and which amounts differ, ignoring any cell formatting differences.

Try with Samples

csv, xml, xlsx
XLSX Samples
Sample XLSX spreadsheets for worksheet parsing and data extraction testing
preferred input family xlsx,xls
xlsx, xls
Duplicate Line Samples
Sample files with various types of duplicate lines for testing duplicate removal tools
preferred input family csv,text
csv, text
CSV Samples
Sample CSV files with various data types, sizes, and complexity levels
title token csv
csv
Regex Replace Samples
Collection of common and useful regex replacement patterns for text transformation and data cleaning
preferred input family csv,text
csv, text

Related Hubs

Text Convert Tools
Explore 80 text tools for convert workflows and compare closely related utilities quickly.
Csv Convert Tools
Explore 38 csv tools for convert workflows and compare closely related utilities quickly.
Xml Convert Tools
Explore 33 xml tools for convert workflows and compare closely related utilities quickly.
Text Tools
Explore 33 text tools for utility workflows and compare closely related utilities quickly.

FAQ

Can I compare specific sheets within an Excel workbook?

Yes, you can specify the exact sheet name for both the left and right inputs to compare specific tabs within your XLSX files.

What are key columns used for?

Key columns act as unique identifiers (like an ID or SKU) to align rows between the two datasets, ensuring accurate comparison even if the row order has changed.

What formats are supported for comparison?

The tool supports raw CSV text input, as well as uploaded CSV and Excel (XLSX/XLS) files up to 20MB in size.

Can I ignore formatting changes and only compare data values?

Yes, you can set the Compare Mode to 'Cell Content Only' to ignore differences in fonts, colors, or data types.

What does the exported PDF report contain?

The PDF report provides a color-coded summary of the differences, highlighting added rows, deleted rows, and specifically modified cells.

API Documentation

Request Endpoint

POST /en/api/tools/csv-excel-diff-tool

Request Parameters

Parameter Name Type Required Description
leftInput textarea No -
leftFile file (Upload required) No -
leftSheetName text No -
rightInput textarea No -
rightFile file (Upload required) No -
rightSheetName text No -
keyColumns text No -
compareMode select No -
reportTitle text No -

File type parameters need to be uploaded first via POST /upload/csv-excel-diff-tool to get filePath, then pass filePath to the corresponding file field.

Response Format

{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}
File: File

AI MCP Documentation

Add this tool to your MCP server configuration: 

{
  "mcpServers": {
    "elysiatools-csv-excel-diff-tool": {
      "name": "csv-excel-diff-tool",
      "description": "Compare two CSV or XLSX datasets and export a PDF report with row, column, and cell-level differences",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=csv-excel-diff-tool",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

Supports URL file links or Base64 encoding for file parameters.

If you encounter any issues, please contact us at [email protected]