Document Text Extraction & Cleaning

I have a batch of Word and PDF documents that contain text-based information I need pulled into a structured file. The task is twofold: first, extract a set list of fields from each document; second, clean the results by removing obvious errors, stray characters, and duplicates so the final dataset is consistent and ready for analysis.

You may work in Excel, Google Sheets, or another tool you are comfortable with—just be sure the output is easy to filter and sort. I will supply the documents, a template that shows the exact fields to capture, and a short set of validation rules so you know what counts as a duplicate or malformed entry.

Deliverable: a single spreadsheet (CSV or XLSX) containing all extracted records, fully cleaned and validated, plus a short log that notes any files that could not be processed and why.

If you are accurate, detail-oriented, and can start right away, this should be a straightforward assignment.