Converting Data from pdf into an Excel spreasdsheet
 

I have MS Project data in a pdf (Adobe Acrobat Pro v7). As there is 6 pages
of data, is it possible to quickly extract the data (by copy/paste or
converting the file type) from the pdf form into an Excel spreadsheet?

Converting Data from pdf into an Excel spreasdsheet
 

You would firstly need to know the format of the .pdf

Format 1, if you press CTRL and A (select all) and the data you want
highlights then you can Highlight (Select) the text you require and
Copy, then Paste into Excel.
This format .pdf is produced from numbers/words in a program such as
Excel, Word etc.

Format 2, if Ctrl/A on the .pdf produces nothing than then the .pdf
might have been created from a scanned .tif or a file sent by Fax etc.

You will need to Capture (or OCR) the data shown, then copy and paste.

Hope this helps


torajudo Wrote:
I have MS Project data in a pdf (Adobe Acrobat Pro v7). As there is 6
pages
of data, is it possible to quickly extract the data (by copy/paste or
converting the file type) from the pdf form into an Excel spreadsheet?


--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528818

Converting Data from pdf into an Excel spreasdsheet
 

Thanks. Your info helped me to a point. I was able to select the data with
a Cntrl +A one page at a time and copy/paste into Excel. However all of the
separate columns of data went into one column. I tried selecting one column
(using Tools touch up text tool) at a time in Adobe but was not having much
luck at selecting individual columns (more than one column was getting
highlighted at a time). I am working with Adobe Acrobat Pro v7 and Excel
2003.

"Door" wrote:


You would firstly need to know the format of the .pdf

Format 1, if you press CTRL and A (select all) and the data you want
highlights then you can Highlight (Select) the text you require and
Copy, then Paste into Excel.
This format .pdf is produced from numbers/words in a program such as
Excel, Word etc.

Format 2, if Ctrl/A on the .pdf produces nothing than then the .pdf
might have been created from a scanned .tif or a file sent by Fax etc.

You will need to Capture (or OCR) the data shown, then copy and paste.

Hope this helps


torajudo Wrote:
I have MS Project data in a pdf (Adobe Acrobat Pro v7). As there is 6
pages
of data, is it possible to quickly extract the data (by copy/paste or
converting the file type) from the pdf form into an Excel spreadsheet?


--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528818

Converting Data from pdf into an Excel spreasdsheet
 

Try selecting the inputted column and click on Data, Text to Columns

Use Delimited, and adjust the delimiter (or multiple delimiters) to
form columns from your data (check the display)

Set the date format for a column if you are using DMY format.

If that doesn't work I would try going back before the .pdf (to MS
Project) to have the file output as a.csv or other acceptable format.



torajudo Wrote:
Thanks. Your info helped me to a point. I was able to select the data
with
a Cntrl +A one page at a time and copy/paste into Excel. However all
of the
separate columns of data went into one column. I tried selecting one
column
(using Tools touch up text tool) at a time in Adobe but was not
having much
luck at selecting individual columns (more than one column was getting
highlighted at a time). I am working with Adobe Acrobat Pro v7 and
Excel
2003.


--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528818

Converting Data from pdf into an Excel spreasdsheet
 

If you have Adobe Acrobat Pro, can't you produce editable text from a
..pdf file in there?

Pete

Converting Data from pdf into an Excel spreasdsheet
 

Hi Pete,

I believe torajudo has editable text, the problem is to transfer that
into Excel in a useable format. The first attempt saw all the data into
column A, and torajudo apparently wasn't aware of the Text to Columns
function.

Adobe 6 can SaveAs a number of filetypes, but not .csv nor tab
delimited, thus it is probably quicker to do 6 copy-paste (1 per page
if required) to transfer all the data, then start to manipulate it.

Had the .pdf been created from a .tif file then the Paper Capture
option could be used, but where CTRL/A produces any result then
attempting to Capture will produce the 'Document contains rendered
text' error.

Bryan


Pete_UK Wrote:
If you have Adobe Acrobat Pro, can't you produce editable text from a
..pdf file in there?

Pete


--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528818

Converting Data from pdf into an Excel spreasdsheet
 

Thanks for suggestions from all. I am working on this document for a
colleague. She did not have the original MS Project file so asked for my
help. Not being fully versed in Adobe Acrobat Pro v7, I really appreciate
your assistance. I now have the data transferred into Excel though the
person who wns this file will need to do some cut and paste with the cells.
She could have gotten this retyped faster but I am glad for the knowledge I
got. Thanks Pete_UK and Door!

"Door" wrote:


Hi Pete,

I believe torajudo has editable text, the problem is to transfer that
into Excel in a useable format. The first attempt saw all the data into
column A, and torajudo apparently wasn't aware of the Text to Columns
function.

Adobe 6 can SaveAs a number of filetypes, but not .csv nor tab
delimited, thus it is probably quicker to do 6 copy-paste (1 per page
if required) to transfer all the data, then start to manipulate it.

Had the .pdf been created from a .tif file then the Paper Capture
option could be used, but where CTRL/A produces any result then
attempting to Capture will produce the 'Document contains rendered
text' error.

Bryan


Pete_UK Wrote:
If you have Adobe Acrobat Pro, can't you produce editable text from a
..pdf file in there?

Pete


--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528818