You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by "Thomas, John" <Jo...@daytonohio.gov> on 2014/07/02 19:39:12 UTC

open pdf documents and save them as spreadsheets or word documents

Can open office translate .pdf files to spreadsheets or word documents?

 

Sincerely,

 

John Thomas

 

John A. Thomas

Application Analyst

City of Dayton

Central Services / Information Technology

130 W. Second Street, Suite 320

Dayton, OH  45402

Phone: 937.333.6321

FAX: 937.333.7835

Email: John.Thomas@daytonohio.gov

 


Re: open pdf documents and save them as spreadsheets or word documents

Posted by Tom Backer Johnsen <ba...@psych.uib.no>.
Tim

I have to admit that my experience is evidently limited, I only have experience with the text type of pdf file.  I was not aware of the “image” type of pdf file.  Thank you for that information!

Tom
On 6. Jul 2014, at 07:04 , Tim Deaton <ti...@timdeaton.org> wrote:

> Much depends on the type of pdf file.
> 
> If the pdf file is an image (what you normally get when you scan a document into the computer), then a program with OCR capabilities is needed to try to recognize the text in the image and either add that text to the pdf document or save that text into a document that text editors, word processors, or spreadsheets can use.  (I use Nuance Power PDF on Windows - a commercial product - for that, and know of other commercial alternatives.  Other people here may know of open source alternatives.)
> 
> If the pdf file is NOT just a scanned document, then it probably actually contains the text (not just a photo) in the file.  In that case, you can highlight the text you want to copy and do a copy-and-paste into Writer.  As Rory wrote, spreadsheet use may need much more care.  Special-purpose programs like Acrobat, Nuance, Foxit, etc. can make such tasks easier -- but they still need careful proof-reading.
> 
> -- Tim
> ===========================
> 
> 
> On 7/3/2014 3:05 AM, Tom Backer Johnsen wrote:
>> John
>> 
>> The solution is much simpler, at least on a Mac.  Simply mark, copy, and paste to wherever you want the text to be.  However, you loose formatting.  As to spreadsheets, copy the table to a temporary file, replace whatever separates the cell contents with a comma or semicolon, and read the temporary file as a .CSV file.
>> On 2. Jul 2014, at 22:21 , Baccara <bb...@tstonramp.com> wrote:
>> 
>>> Rory O'Farrell wrote:
>>>> On Wed, 2 Jul 2014 13:39:12 -0400
>>>> "Thomas, John" <Jo...@daytonohio.gov> wrote:
>>>> 
>>>> 
>>>>> Can open office translate .pdf files to spreadsheets or word documents?
>>>>> 
>>>>> 
>>>>> Sincerely,
>>>>> 
>>>>> 
>>>>> John Thomas
>>>>> 
>>>>> 
>>>> No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
>>>> 
>>>> 
>>> OCR - does that equate to Adobe creates an image (jpg or ?) from any document "printed to / saved as" a pdf document?
>>> PDF document can be opened with a pdf reader (free from Adobe and other sources), content highlighted, copied then pasted to another program such as OO Writer; MS Word then saved in the new format?
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>> 
>> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
> 

Tom Backer Johnsen
Søndre Steinkjellersmauet 7
5003 Bergen
Mobil: +47 9169 3346
Email: backer(at)psych.uib.no


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: open pdf documents and save them as spreadsheets or word documents

Posted by Tim Deaton <ti...@timdeaton.org>.
Much depends on the type of pdf file.

If the pdf file is an image (what you normally get when you scan a 
document into the computer), then a program with OCR capabilities is 
needed to try to recognize the text in the image and either add that 
text to the pdf document or save that text into a document that text 
editors, word processors, or spreadsheets can use.  (I use Nuance Power 
PDF on Windows - a commercial product - for that, and know of other 
commercial alternatives.  Other people here may know of open source 
alternatives.)

If the pdf file is NOT just a scanned document, then it probably 
actually contains the text (not just a photo) in the file.  In that 
case, you can highlight the text you want to copy and do a 
copy-and-paste into Writer.  As Rory wrote, spreadsheet use may need 
much more care.  Special-purpose programs like Acrobat, Nuance, Foxit, 
etc. can make such tasks easier -- but they still need careful 
proof-reading.

-- Tim
===========================


On 7/3/2014 3:05 AM, Tom Backer Johnsen wrote:
> John
>
> The solution is much simpler, at least on a Mac.  Simply mark, copy, and paste to wherever you want the text to be.  However, you loose formatting.  As to spreadsheets, copy the table to a temporary file, replace whatever separates the cell contents with a comma or semicolon, and read the temporary file as a .CSV file.
>   
> On 2. Jul 2014, at 22:21 , Baccara <bb...@tstonramp.com> wrote:
>
>> Rory O'Farrell wrote:
>>> On Wed, 2 Jul 2014 13:39:12 -0400
>>> "Thomas, John" <Jo...@daytonohio.gov> wrote:
>>>
>>>   
>>>> Can open office translate .pdf files to spreadsheets or word documents?
>>>>
>>>>
>>>> Sincerely,
>>>>
>>>>
>>>> John Thomas
>>>>
>>>>     
>>> No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
>>>
>>>   
>> OCR - does that equate to Adobe creates an image (jpg or ?) from any document "printed to / saved as" a pdf document?
>> PDF document can be opened with a pdf reader (free from Adobe and other sources), content highlighted, copied then pasted to another program such as OO Writer; MS Word then saved in the new format?
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: open pdf documents and save them as spreadsheets or word documents

Posted by Tom Backer Johnsen <ba...@psych.uib.no>.
John

The solution is much simpler, at least on a Mac.  Simply mark, copy, and paste to wherever you want the text to be.  However, you loose formatting.  As to spreadsheets, copy the table to a temporary file, replace whatever separates the cell contents with a comma or semicolon, and read the temporary file as a .CSV file.
 
On 2. Jul 2014, at 22:21 , Baccara <bb...@tstonramp.com> wrote:

> Rory O'Farrell wrote:
>> On Wed, 2 Jul 2014 13:39:12 -0400
>> "Thomas, John" <Jo...@daytonohio.gov> wrote:
>> 
>>  
>>> Can open office translate .pdf files to spreadsheets or word documents?
>>> 
>>> 
>>> Sincerely,
>>> 
>>> 
>>> John Thomas
>>> 
>>>    
>> 
>> No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
>> 
>>  
> OCR - does that equate to Adobe creates an image (jpg or ?) from any document "printed to / saved as" a pdf document? 
> PDF document can be opened with a pdf reader (free from Adobe and other sources), content highlighted, copied then pasted to another program such as OO Writer; MS Word then saved in the new format?


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Re: open pdf documents and save them as spreadsheets or word documents

Posted by Baccara <bb...@tstonramp.com>.
Rory O'Farrell wrote:
> On Wed, 2 Jul 2014 13:39:12 -0400
> "Thomas, John" <Jo...@daytonohio.gov> wrote:
>
>   
>> Can open office translate .pdf files to spreadsheets or word documents?
>>
>>  
>>
>> Sincerely,
>>
>>  
>>
>> John Thomas
>>
>>     
>
> No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.
>
>   
OCR - does that equate to Adobe creates an image (jpg or ?) from any 
document "printed to / saved as" a pdf document? 

PDF document can be opened with a pdf reader (free from Adobe and other 
sources), content highlighted, copied then pasted to another program 
such as OO Writer; MS Word then saved in the new format?



Re: open pdf documents and save them as spreadsheets or word documents

Posted by Rory O'Farrell <of...@iol.ie>.
On Wed, 2 Jul 2014 13:39:12 -0400
"Thomas, John" <Jo...@daytonohio.gov> wrote:

> Can open office translate .pdf files to spreadsheets or word documents?
> 
>  
> 
> Sincerely,
> 
>  
> 
> John Thomas
> 

No. You need to use an OCR (Optical Character recognition) application to do that. For spreadsheets and other work involving figures most careful proof-reading of the OCR output is required.

-- 
Rory O'Farrell <of...@iol.ie>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org