Anxingji ToolsEVERYDAY TOOLS

How to check files against an Excel list and find missing submissions

Anxingji Tools · Published 2026-11-18

Use the file checklist to compare the files you received with an Excel list. Match a name or ID in each file name, then review missing submissions, extra files and files with no match.

Check files against a list →

Review matches for free. Copying or exporting the report requires sign-in and an active online pass.

Load the expected list and the received files

  1. Choose an Excel or CSV list. Select the worksheet and the column containing names or IDs. If each person owes a different number of files, select the expected quantity column.
  2. Choose the folder of received files. Keep the list workbook in a separate folder so it is excluded from the comparison.
  3. For file names like Alex-contract.txt, select File name contains the list entry. Use exact matching when each filename, without its extension, is the name or ID itself.
  4. Select Check files. Review ambiguous matches before acting on the missing counts.

Check three submissions against the Excel workbook

Download the exercise ZIP and unzip it. Move expected.xlsx outside the exercise folder, then import it and select the Name and Expected files columns. Choose the folder with the three text files and use contains matching.

Download the example report to compare the results.

Expected and matched files in the exercise
NameExpectedMatchedResult
Alex11Count matches
Blair10Missing 1
Casey21Missing 1

Unknown-note.txt appears under Unmatched and excluded files. To practice finding extra submissions, add a second Alex file called Alex-revised.txt and run the check again. Alex now has two matches against one expected file.

Review matches before following up

Filter the list for Missing files or Extra files. A second file can be a revision or a different document. The tool compares names and counts, so open the files before deciding how to handle extra copies.

Names that overlap, such as Alex and Alexa, can trigger ambiguous results. Confirm the correct match or use consistent IDs. For a list of everything already in the folder, use the folder inventory guide.