PDF Data Auto-Extraction to Excel
Budget: $250 – $750 USD
Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically.
These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file.
The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect the extraction. The only difference you'll see between the invoices is that most of them (maybe 90% or more) have only 1 product, but a few invoices can have 3, 4, 5 or even more different products on the same invoice.
Attention: I'm not looking for someone to do the extraction for me daily. I'm looking for someone who can help me build a tool where I'll be able to automatically process these files on my computer by myself, since these are sensitive invoices with personal information from customers.
Ideal skills for the job:
- Proficiency in automation software tools
- Experience working with PDFs and Excel
- Excellent attention to detail
- Understanding of invoice structures and data extraction techniques.
These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file.
The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect the extraction. The only difference you'll see between the invoices is that most of them (maybe 90% or more) have only 1 product, but a few invoices can have 3, 4, 5 or even more different products on the same invoice.
Attention: I'm not looking for someone to do the extraction for me daily. I'm looking for someone who can help me build a tool where I'll be able to automatically process these files on my computer by myself, since these are sensitive invoices with personal information from customers.
Ideal skills for the job:
- Proficiency in automation software tools
- Experience working with PDFs and Excel
- Excellent attention to detail
- Understanding of invoice structures and data extraction techniques.