Fill an Excel sheet with data obtained from pdf files

Completed Posted 6 months ago Paid on delivery
Completed Paid on delivery

We are looking to hire a professional freelancer to develop a program that automates the process of extracting data from PDF files and populating an Excel spreadsheet. The project involves the following steps:

Step #1:

The end user will save a group of PDF files in a designated folder. Each PDF file should be named with a sorting number, as shown in the provided picture.

Step #2:

The end user will open the "QF-ENG-17 - SAT Selection Summary" Excel file and run the program. The program should extract data from the PDF files and populate the corresponding fields in the "QF-ENG-17 - SAT Selection Summary" Excel file. An example of this mapping is shown in the provided picture.

Step #3:

After filling the data in the Excel sheet cells from 1 to 14, the program should automatically close the opened PDF file.

Step #4:

The program should add a black bold line in the Excel sheet, as shown in the provided picture, to separate the data from each PDF file.

Step #5:

The program should then proceed to open the next PDF file from the designated folder and repeat the process of extracting data and populating the Excel sheet.

Step #6:

This process should continue until all the PDF files in the designated folder have been processed and the data has been populated in the Excel sheet.

Excel Data Entry Visual Basic Excel VBA PDF

Project ID: #37413329

About the project

69 proposals Remote project Active 5 mos ago

Awarded to:

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More

$30 USD in 3 days
(596 Reviews)
8.5

69 freelancers are bidding on average $125 for this job

nimiwebjuggler

Hi, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 y More

$140 USD in 1 day
(171 Reviews)
6.8
Giovanni704

Hi there! I possess extensive expertise in developing automated solutions for data extraction and manipulation. Understanding the outlined process, I'll employ scripting languages like Python to craft a program that s More

$30 USD in 1 day
(66 Reviews)
7.1
rabbiawebjuggler

Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!

$30 USD in 1 day
(119 Reviews)
6.7
vsprybhanu

Hi, I can develop Excel VBA Macro to extract data from PDF and Fill excel file as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job More

$120 USD in 3 days
(152 Reviews)
6.2
AnjaliMehta

Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tabl More

$100 USD in 2 days
(16 Reviews)
5.8
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc More

$140 USD in 1 day
(48 Reviews)
5.7
marfan080

Hello there! My name is JUNAID and I am a professional Excel VBA, Google Sheets, PDF and Data Entry expert. I understand that you are looking for someone to develop a program that automates the process of extracting da More

$40 USD in 1 day
(167 Reviews)
5.7
amokhtar70

Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how More

$120 USD in 4 days
(45 Reviews)
5.4
AmazingEngr76386

I understand that you are looking for a professional freelancer to develop a program that automates the process of extracting data from PDF files and populating an Excel spreadsheet. I am confident that my skillset, ex More

$140 USD in 7 days
(7 Reviews)
4.8
mwikalicarolyne2

Hi! I can do your Fill an Excel sheet with data obtained from pdf files job accurately. My experience with PDF, Excel, Excel VBA, Data Entry and Visual Basic makes me the right person to help you complete this projec More

$30 USD in 2 days
(4 Reviews)
4.3
abdulrehmanabid2

Hi sir, I have a lot experience I can be the best for your project. My typing speed 90+ WPM with 100% accuracy. I have a experience of more than 06+ years of Data Entry in Government Departments. I will do this projec More

$30 USD in 7 days
(36 Reviews)
4.0
Crayon1365

Hi, I'm an expert developer with 10+ years of experience and already done many projects about extract data from PDF files, Also I'm expert in writing VBA macro in excel. I can develop a high quality tool to extract dat More

$250 USD in 7 days
(9 Reviews)
4.0
ExpertSoul

Hello, I have read all your requirements that you want a Fill an Excel sheet with data obtained from pdf files I have expertise in developing automation solutions. I can create a program to efficiently extract data fr More

$175 USD in 1 day
(6 Reviews)
3.6
eslamafify

Hello Hope everything is well with you.I read your job description and I'm able to do it.I did such projects before. Let's discuss more details.

$75 USD in 7 days
(3 Reviews)
2.9
derrickmulwa

Hello. I am an experienced python developer and can create for you a python script that will automate this process and write the PDF data to your excel file. I have expert experience in PyPDF and openpyxl, which are m More

$70 USD in 2 days
(2 Reviews)
2.3
mikaelarhelger

Hello there! My name is Mikael, and I'm an experienced full-stack engineer with over 5 years of experience. From what I've seen from your project description, it sounds like you are looking for someone to develop a pro More

$140 USD in 7 days
(1 Review)
1.6
kumawatshekhar71

Hi, I have read the requirement and understood, we can discuss more for detailed requirements. My Profile: 1. I have 13+ years of experience with with different SP versions -SP Online/2019/2016/2013/2010 2. I have More

$250 USD in 5 days
(3 Reviews)
1.6
AsimMunir77

Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 More

$140 USD in 7 days
(2 Reviews)
1.2
djohnwesley09

Hello, Bilal J. It's a pleasure to connect with you. Having thoroughly reviewed requirements of "Fill an Excel sheet with data obtained from pdf files", I have a clear understanding of your expectations. ✅ I am commit More

$70 USD in 7 days
(0 Reviews)
0.0
mosadab0786

Hi . good evening I will do it as per your requirement time and also cost of minimum,if your are interested for the same can contact with me.

$140 USD in 7 days
(0 Reviews)
0.0