Extract Timesheet Data to Excel

Customer: AI | Published: 01.02.2026

I have a collection of employee timesheets stored only as PDFs. Each file is essentially free-form text—no neat tables—so a simple copy-and-paste won’t cut it. From that text I need to pull two things with total accuracy: the exact dates worked and the related project details. Your job is to read through every page, identify those two data points, and enter them into a clean, consistently structured Excel workbook. Columns should at minimum include Date and Project (add any supporting columns you feel improve clarity). When you finish, I want to be able to sort, filter, and run pivot summaries without further cleanup on my end. Feel free to use whatever toolchain suits you—Excel, VBA, Power Query, Python with pandas, OCR utilities—so long as the final spreadsheet is correct and formatted professionally. I’ll provide a sample PDF on award so you can show a quick proof of concept before processing the full batch.