Adobe PDF to Microsoft Excel sheet conversion

In Progress Posted Mar 1, 2015 Paid on delivery
In Progress Paid on delivery

Need a simple 1-click application to extract data from multiple pages of a PDF file and convert into 1 single Microsoft Excel workbook/sheet.

A PDF file consisting of single or multiple Invoices and some irrelevant forms.

Each page of separate invoices, all have the same fixed template of information.

Need to extract the data from each of those invoices and place as individual rows of 1 single Excel sheet. Following are the heads required in Excel, with their corresponding PDF data to be put under each of them:

EXCEL HEAD - Data required and location in PDF

INVOICE NO - Alphanumeric string after "Invoice Number :"

BUYER - The first line of bold alphabetical string under the head of "BUYER" in invoice

PIN - The 6 digit numeric string after "PIN" under the head of "BUYER" in invoice

PRODUCT - The complete string under the head of "Item Description" before "Order No."

SUBORDER NO - The numeric string after "Suborder No.: " under the head of "Item Description"

RATE - The numeric string under the head "Rate" in invoice

TAX - The numeric string under the head "Tax" before the beginning of left parenthesis i.e. before "(x %)"

TOTAL - The numeric staring under the head "Amount" in invoice

SNAPDEAL REF NO - The alphanumeic string right under the lower bar-code in the invoice

SHIPPING - The alphabetical string right above the higher bar-code in the invoice

SHIPPING TRACK ID - The numeric string right under the higher bar-code in the invoice

Please refer to the attached sample files.

"Input PDF" has 7 pages - 5 invoices to be processed as described above and 2 irrelevant form pages that are to be ignored.

"Output EXCEL" has 1 single Excel worksheet with the 5 invoices of the PDF converted into 5 rows as described above.

Need a simple application file which when executed does the whole process and outputs an Excel worksheet.

4 More Fields are to be fetched from the PDF and exported to Excel
1. City Name - Name of the City of Buyer
2. Buyer Mobile No.
3. SKU ID Mentioned on left side of the page below item name
4. Date - mentioned Next to Invoice No. / Invoice date

If the Quantity is More than 1 , in that case there will be 2 sub order ids , in such case there shall be multiple rows corresponding to such page, if quantity =2 then 2 rows, if quantity = 3 then 3 rows and so on..

Data Processing Excel

Project ID: #7225507

About the project

27 proposals Remote project Active Mar 10, 2015

Awarded to:

DMediaDesign

Hi, For your project I could build a windows desktop application, totally portable and non framework or acrobat dependent. I've uploaded a initial demo to [login to view URL] pass:demo27. The app proce More

$120 USD in 2 days
(18 Reviews)
4.9

27 freelancers are bidding on average $122 for this job

wissamSabry

As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft Excel problem, formula(s), or task. I am an advanced user with ov More

$170 USD in 5 days
(15 Reviews)
4.0
rizwanraja211

we provide you in 25$,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, I am interesting in your project,will provide you on very low rates, 100% job satisfaction,work on time I am ready to start.......

$30 USD in 3 days
(2 Reviews)
0.0
amirahabashy75

Hello, please hire me , I can do it for you, I will open pdf file and Excel program if you hire me, thank you very much.

$54 USD in 3 days
(1 Review)
0.0
hmanamul

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
qasimiqbal461

i am expert and experience in data entry.i can do best with quality of work..u can hire me... i will give u the best result.. thankyou

$155 USD in 3 days
(0 Reviews)
0.0
hemi7627

I am Kalum from Sri Lanka. Excellent in MS office. Hard working and time oriented person. Able to submit on time.

$111 USD in 3 days
(0 Reviews)
0.0
sebialecu

I want to do this project and believe that seriousness , lust and especially youth work are my strengths . especially youth because we all know that young people have the most free time, time spent at the computer and More

$55 USD in 1 day
(0 Reviews)
0.0
ansysolidwork

I fully understand your needs base on attachment that gave. This project I will settle it ASAP and will organize it detail and nicely base on your standard.

$100 USD in 5 days
(0 Reviews)
0.0
amkarafi1

Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like this Work Like thi More

$111 USD in 3 days
(0 Reviews)
0.0
LDima

Предложение еще не подано

$233 USD in 3 days
(0 Reviews)
0.0
eimirKA

A proposal has not yet been provided

$35 USD in 1 day
(0 Reviews)
0.0
samiir11

I have 3 years experience in writing and translation As well as the writing on the Word and Excel, and PowerPoint presentations achievement.

$155 USD in 3 days
(0 Reviews)
0.0
wdadubo

I am a Human Resource Practitioner for seven years now. As practitioner I handled documents almost everyday. I think I am suited for this job offer because I am keen into details and make sure there's no room for error More

$88 USD in 3 days
(0 Reviews)
0.0
sk0033610

I can prepare the excel sheet from all the pdf invoices. And can deliver the work ASAP. Let me know if you need my help.

$155 USD in 3 days
(0 Reviews)
0.0
davidkamo

I have a lot of Experience and also work on a project of this kind. I have a team of five people to work on this project very fast.

$155 USD in 3 days
(0 Reviews)
0.0
behl2012bhawna

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
Rebenachan

With the more than 7 years in event planning, public relation and marketing background, task have to be done on time without any mistake. Proficient in Microsoft Office Tools, Words, Excel… etc

$200 USD in 3 days
(0 Reviews)
0.0
compuserve2015

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
ndungud23

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
linasalah

I've been working as an admin for 4 years and as an accountant, I'm excellent with Microsoft excel, have great typing skills and always deliver on time.

$30 USD in 2 days
(0 Reviews)
0.0