Question:
convert PDF or WORD onto EXCEL ?
david 74
2009-04-04 00:00:27 UTC
I receive updated documents in mostly PDF, sometimes WORD format. Then need to add them to an EXCEL spreadsheet so I can use formulas to fill in blanks on the documents (name, address, etc.) from another sheet. I've been having to remake the new form, on EXCEL. Sometimes by copy & paste, sometimes I type the whole thing out. Is there an easier way to do it so the blanks on the form (PDF) will be blank cells in EXCEL and will look the same when printed out as it would if I printed the blank PDF form?
Three answers:
Tina
2009-04-07 03:48:01 UTC
Hi,guy.

If I were you, I may convert pdf to word with a good conversion tool such as tweak pdf to word converter(which is available at tweak official site http://www.tweakpdf.com/product/index.htm). Then choose all the word text and insert table. Finally. copy all the text and table onto excel.
Andrew L
2009-04-04 00:10:53 UTC
If the docs are delimited - i.e. the blanks are caused by markers such as tabs or paragraphs, you can split the cells using the delimiters. (in Excel go to Data -> Text to columns). This is usually possible when converting Word to Excel.



Trouble is, pdfs don't use delimiters in the same way. I've found that the blanks just transfer to Word as single spaces. This is useless because the doc contains loads of spaces anyway.



It may be worth investing in some pdf conversion software, to solve this problem.
2009-04-04 00:10:51 UTC
try scan soft for PDF to office and its vice versa



or you can Adobe Acrobat Professional once you will install Adobe its you can find few plug ins in word/excel files

you'll able to convert word / excel into PDF.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...