Extract addresses from pdf to excel

This project involves extracting contact information from two Portable Document Format (PDF) files containing approximately three thousand addresses and names, and compiling that extracted data into a new Microsoft Excel workbook. The goal is to efficiently transcribe the address blocks - containing basic contact details like street name, city, state and zip code - from the source PDF documents into an organized spreadsheet format.

THE ONLY ADDRESSES REQUIRED ARE THE ADDRESSES BELOW THE FOLLOWING TEXT ON THE PDF'S
"Name & Address of Licence Holder"

Data will need to be meticulously extracted from the unstructured PDFs and inputted into predefined columns in an Excel sheet to separate out each address field for easy reference and searchability. Columns may include Contact Name, Address Line 1, City, State, and Zip Code. Proper transcription and formatting of addresses is essential to maintain usability. Numbers, special characters and punctuation should be checked for accuracy.

The freelancer should have strong attention to detail as well as proven proficiency in tasks like optical character recognition, copy/paste and spreadsheet manipulation. PDF editing and data extraction experience from assorted file types will be valued. Once compiled, the final output Excel file should contain a clean, well-structured list of all addresses extracted from the two PDF files provided, complete with individual columns for each data field.

This project aims to professionally digitize contact information that currently exists only as unsearchable text within multiple PDF documents. Skillful extraction and transcription of data into an organized spreadsheet will satisfy the client's need for now having their address