PDF to Excel

[Marc_P._Keane@adobeforums.com]

I have a financial report in PDF format that has many lists in columns with text and figures. I would like to export this to Excel or another spreadsheet program such as the one in AppleWorks.

If I just copy and paste the information, since the various columns of data are not tab-separated (there is only a "space" marker between column info), the data of each row pastes all clustered together in one column.

Is it possible to export information from a PDF in such a way that columns of data will be tab-separated or in some other way formatted to make it easy for a program like Excel to acquire the information?

Marc
PowerBook, OS 10.3.9
Adobe Reader 7.0.8

[Claudio_González@adobeforums.com]

My first reaction would be to export to Word, and use the find/replace function to replace the spaces by tab marks. Although I seem to recall having read about programs that promise to do the conversion -don't know how well or badly.

[Sabian_Zildjian@adobeforums.com]

If you had Acrobat Professional then you could select the Excel spreadsheet that is in the PDF and Control+Click. From the Context menu select "Open Table in Spreadsheet" and it will open in MS Excel.

Sabian

[Ravi]

[email]Marc_P._Keane@adobeforums.com[/email] wrote:

> I have a financial report in PDF format that has many lists in columns with text and figures. I would like to export this to Excel or another spreadsheet program such as the one in AppleWorks.
>
> If I just copy and paste the information, since the various columns of data are not tab-separated (there is only a "space" marker between column info), the data of each row pastes all clustered together in one column.
>
> Is it possible to export information from a PDF in such a way that columns of data will be tab-separated or in some other way formatted to make it easy for a program like Excel to acquire the information?
>
> Marc
> PowerBook, OS 10.3.9
> Adobe Reader 7.0.8

I have a collection of software tools to do this work and manpower to
ensure 100% accuracy. If you would like me to give it a try contact me
off the forum at rmanianATgmailDOTcom.

Thanks and rgds
Ravi