Mass extract data from pdf to excel
€250-750 EUR
Paid on delivery
Hello,
So this is the job summary I want done:
I have an excel file that contains in a list, among other things, hyperlinks to downloadable pdf files.
I want a program that :
1) Downloads automatically all those files (for start they may be something like 100.000 files, after that about 1000 a week)
2) Opens each pdf, looks inside to find a specific Table format that contains some specific symbols and words (Some times the table could be in a form of an image which makes things more difficult)
3) If there is a matching table, export it to a separate excel sheet as a table with a standar format, keeping some other information of the pdf too (or from the list that contained the hyperlink to download the pdf)
The result should be an excel file with some thousand sheets (each sheet would have the same format).
At second time I would like an evaluation of the data with a predictive analytics tool so if someone knows how to do both it would be a plus.
So for example in the attached files the program must open excel fil "Ex1", open each hyperlink -in yellow- (Which in this case everything is the pdf "Ex2").
In "Ex2" it should look for a table that contains a percentage % value (as in page 6 of "Ex2"), if there are more than once ignore the others and transfer this table to an excel sheet (Seperate for each file). Then that sheet must contain some other information from the hyperlink line in "Ex1" , like the TITLE (in red), the id (in green) and the date (in purple). If the pdf does not contain a table like this, ignore it.
Also I don't want an one use data extrapolation. I want a program or a code that can repeatedly do this with new input.
That's all.
Thanks in advance
Jiovannos
Project ID: #30193980
About the project
26 freelancers are bidding on average €401 for this job
Hi, I am an Advanced Excel Expert. I have seen the attached files. Message me for further discussion.
Hello, I read your project description. I'm a native English speaker who can carry out this task excellently well. Looking forward to your response and working for you.
Hello, I would like to convert your documents to excel files. I can do this work easily. My data converter experience is about 2 years.
hi, I know how to go for it . I think you first want to extract all pdf links and from each page of pdf ,look for table and from table cell data to excel data. open2talk
Dear Sir/Madam, Thank you for posting this. I am interested in taking this opportunity. Coming to myself I Am new to this portfolio but I have been working till date as a Accountant in Construction Company for abou More
Ready to work on the project in the given time and with the desired output along with any other requirements. If any other details are there in the project, please let me know.
1) “I can complete your project on time and within your budget.” 2) “I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations.” 3) “I can achieve the results that More
I am fresher please give me a opportunity for your work. i can do work in 3-4 days confirmly.
You may define your perfect job as one where you get to be of service to others, while someone else defines theirs as one with a short commute and good pay.
Hello, I am ready to work with you, and I read to your company proposal. I have 8 years work experience in this field. If you'll give the project than I assuard to you, your work will be seafly done. an More
I am a mechanical engineer passed out.. lockdown freeze my job opportunity... I have more than enough time to complete your project... I have time and I need money you have money and need time... that time can filled More
I can done this for you as I have high efficient working manner and skills. I am facing financial issues in the pendamic situation, it will be an honour to me to working for you.
hlo sir , I am rajendra Kumar. i am interested in your project and fully effort this project and submit project before time limit.
Hello sir/madam I'm new in freelancer job but i had lot of experience in this type of job. I'm graduate student. Happy to work with you. thank you
iam data entry specalist ican complete your work fast and intime i expert ms office and typing i have experience of 3years in typing i can complete your work in time with out any mistakes or errors you can trust me th More
I have 5 years experience I Prepare, compiles, and sorts documents for data entry. Verifies and logs receipt of data. I source data into the required electronic format. I transfer information from paper formats into c More