I am looking to convert a PDF file into an Excel File.

My file is basically a company business report with line items that have
corresponding numerical values. I would like the line items in one column and
the numerical values in another. I have been struggling to save the file in a
way that I can open it like this, as I used to be able to do when I could get
the file as a PDF Forms file.

When I save as text, it can open nicely in Word, but it will not open with
the columns I need in excel. When I do Select Table/Copy Table/Save Table
through Acrobat I can get the values I want, but it's a struggle and I need
to do it section by section.

Please let me know if you have any suggestions.

I emailed the PDF file to the adobe2html email address last week and got No
response.

Thank you so much.

If it exports to Word nicely, you can then export it to Excel from there.
You can just save it as a text file and then import the text file using
Excel's wizard. If it isn't separating into the columns properly using the
wizard, then Excel has a feature called Text to Columns under the Data menu
that will help you.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"MC" wrote:

I am looking to convert a PDF file into an Excel File.

My file is basically a company business report with line items that have
corresponding numerical values. I would like the line items in one column and
the numerical values in another. I have been struggling to save the file in a
way that I can open it like this, as I used to be able to do when I could get
the file as a PDF Forms file.

When I save as text, it can open nicely in Word, but it will not open with
the columns I need in excel. When I do Select Table/Copy Table/Save Table
through Acrobat I can get the values I want, but it's a struggle and I need
to do it section by section.

Please let me know if you have any suggestions.

I emailed the PDF file to the adobe2html email address last week and got No
response.

Thank you so much.

Well when it opens in word, it often converts the tables I want to pictures.
I can select it as text when it is a PDF or select the table in segments and
copy as table, but I want to be able to easily import it into excel. If I
save as html from Acrobat it saves as distorted pictures.

If i save it as plain text, when it opens in word, it is disorganized.
Instead of being like this:

1. Item 111111
2. Item 111111

It comes up like this

1.
2.

11111
11111

Item
Item

But this is for about 30 pages of data and too tedious to go through and see
if the line items match up.

Ultimately I used to be able to import it into excel when it was a forms
document after saving it as text with line bands. each line item had a unique
code that I could use in vlookups to get the values so I could do what i
wanted with the data.

Now that it is a PDF file I am not having the same ability with the data.
Hopefully my question makes sense.

If you want the example of the data click he

http://www.ffiec.gov/nicpubweb/nicwe...E ND=99991231

and go to the financial data at the bottom of the page, choosing the second
one (Y-9C) and getting any date's report. You'll see how the document opens
as a pdf with line items and then the values on the right side with each item
having a unique code.

How can I get it to open in excel with these three columns?

Thanks so much for your help.

If you have some OCR software (I have OmniPage Pro), then you will be
able to open the PDF file into that and convert it into editable text -
probably easier then to export it to Word and from there into Excel.

Hope this helps.

Pete

MC wrote:

Well when it opens in word, it often converts the tables I want to pictures.
I can select it as text when it is a PDF or select the table in segments and
copy as table, but I want to be able to easily import it into excel. If I
save as html from Acrobat it saves as distorted pictures.

If i save it as plain text, when it opens in word, it is disorganized.
Instead of being like this:

1. Item 111111
2. Item 111111

It comes up like this

1.
2.

11111
11111

Item
Item

But this is for about 30 pages of data and too tedious to go through and see
if the line items match up.

Ultimately I used to be able to import it into excel when it was a forms
document after saving it as text with line bands. each line item had a unique
code that I could use in vlookups to get the values so I could do what i
wanted with the data.

Now that it is a PDF file I am not having the same ability with the data.
Hopefully my question makes sense.

If you want the example of the data click he

http://www.ffiec.gov/nicpubweb/nicwe...E ND=99991231

and go to the financial data at the bottom of the page, choosing the second
one (Y-9C) and getting any date's report. You'll see how the document opens
as a pdf with line items and then the values on the right side with each item
having a unique code.

How can I get it to open in excel with these three columns?

Thanks so much for your help.