Skip to content
ToolQivo

Missing Text Finder

Find the lines in one list that are absent from another.

Text Tools Reviews Free · no sign-up

Missing from the second

—

Present in both

—

Only in the second

—

Quick Tool Overview

The Missing Text Finder compares two lists in both directions at once: what is in the first but not the second, what is in the second but not the first, and what they share. A list can be missing entries and have extra ones simultaneously, so one direction is never enough.

What it does
Finds the entries missing from each of two lists
You give it
Two lists to compare
You get back
Both difference sets plus the shared entries
Best for
Reconciling exports, translation keys and checklists
Text Tools Free, unlimited use No sign-up Runs in your browser

About the Missing Text Finder

Two lists that should match rarely do, and the useful question is which entries are missing from which side. An export that should have every customer but has 4,180 rows instead of 4,200. A translation file missing twenty keys. A checklist where you need to know what has not been done yet.

This does a set difference in both directions at once: entries in the first list that are not in the second, and entries in the second that are not in the first. Both results are shown separately with counts, along with the entries the two lists share. Comparison can ignore case and whitespace, and can be restricted to one column of a delimited file so two exports with different columns can still be matched on their IDs.

Key features of the Missing Text Finder

Both directions at once

Missing and extra entries are separate findings, and seeing only one of them hides half the problem.

Match on a single column

Compare two exports on their ID field even when their other columns are formatted differently.

Duplicates handled explicitly

Repeats are collapsed for the comparison but counted separately, so nothing is silently swallowed.

Case and whitespace folding

A trailing space no longer makes two identical entries look like a mismatch.

Fast on large lists

Hash-set comparison rather than nested loops, so tens of thousands of rows compare instantly.

How to use the Missing Text Finder

  1. 1

    Paste the first list

    The list you expect to be complete.

  2. 2

    Paste the second list

    The list you are checking against it.

  3. 3

    Set the matching rules

    Ignore case and whitespace, or compare only one column of a delimited row.

  4. 4

    Read both directions

    Missing from the second, missing from the first, and present in both are each listed with counts.

Frequently asked questions

Yes, and that matters. A list can be missing entries and have extra ones at the same time, and seeing only one direction would hide half the problem.

Reviews of the Missing Text Finder

What people who use the Missing Text Finder think of it. Reviews come from visitors and are posted as written.

No ratings yet

Yours would be the first.

  • 5 0 reviews rated 5 stars
  • 4 0 reviews rated 4 stars
  • 3 0 reviews rated 3 stars
  • 2 0 reviews rated 2 stars
  • 1 0 reviews rated 1 star

Write a review

Used this tool? Your rating helps the next person decide.

Your rating

Plain text only — links, email addresses and HTML are not accepted. Your name and review are shown publicly; nothing else is collected. See the privacy policy.

0 reviews

Newest first

No reviews yet

Be the first to rate the Missing Text Finder. It takes half a minute and no account.

Write the first review

More text tools