Home My Accounts DNSai Account DNS Explorer Account
Lookup Tools ▸
DNS Lookup Advanced DNS Lookup Record Finder WHOIS Lookup DKIM Lookup DMARC Lookup Blacklist Check All DNS Tools
Analysis ▸
SPF Analyzer Analyze Email Headers Domain Profile Report Verify Email SMTP Send Client Solution Provider Directory
Bulk & Enterprise ▸
Bulk Lookup Domain Manager DNS Explorer DNS Assistant API & MCP for AI CSV Comparison Utility
Resources ▸
Instructions Domain Name System Email Security SPF, DKIM, DMARC About
Close
CSV Comparison Utility Instructions

CSV Merge / Match / Compare Utility

The CSV Comparison Utility is a convenient tool that streamlines data set comparison by merging, matching, and comparing data between two .csv files. This tool identifies common record values, highlights discrepancies, and consolidates information based on your defined matching criteria.

How It Works

The utility compares two CSV files based on a common column that you specify. It matches and aligns data based on common field entries, highlighting unique rows from each file. This makes it easy to identify what data exists in one file but not the other, or to merge related data from two different sources.

Before You Begin

To use the CSV Comparison Utility, ensure the following:

  • A shared column: Both .csv files need a column with the same header name, such as Domain or Email Address. Capitalization and extra spaces in the header are ignored.
  • Any column position: The matching column can be anywhere in each file. It does not need to be the first column.

Steps to Compare CSV Files

  1. Go to the CSV Comparison Utility:

    Visit dnsai.com/data-utility to access the tool.

  2. Upload Your First CSV File:

    Select and upload the first .csv file you want to compare.

  3. Upload Your Second CSV File:

    Select and upload the second .csv file for comparison.

  4. Choose the Matching Column and Run the Comparison:

    Once both files are selected, the Matching Column list shows the columns the two files have in common. Pick the one that identifies each row, then run the comparison.

  5. Review Your Results:

    The summary shows how many rows were found in both files and how many appear in only one. The merged file starts with the matching column and a Match Status column ("Match: in both files", "Only in" File 1 or File 2), followed by the columns from File 1 and then File 2. If both files use the same column name, such as Notes, each copy is labeled with its file name so no data is overwritten. When a value appears more than once in File 2, every matching row is kept. The download link is private and expires after one hour.

Common Use Cases

This utility is ideal for:

  • Merging company data with DNS lookup reports
  • Comparing email lists to identify additions or removals
  • Matching Message ID reports across different systems
  • Consolidating data from multiple sources based on a common identifier
  • Identifying discrepancies between two versions of a data set

Tips for Best Results

  • Make sure the matching column has the same name in both files (for example, rename "E-mail" to "Email Address")
  • Capitalization and leading or trailing spaces in values are ignored, so "Example.com" matches "example.com "
  • Comma-, semicolon- and tab-separated files are all supported
  • Verify that the data format in the matching column is consistent across both files
  • For large files, ensure your data is clean and properly formatted before uploading