Import to Excel?

coccio · Apr 23rd, 2002, 12:31 PM

I have question in regards to extracting data from one document and importing it into excel. Does anyone know how to do that? Were one can take certain data within a PDF file or MS word document and import it into excel?

lenze · Apr 23rd, 2002, 12:44 PM

To import from Word or any text file, Choose Data>Get External Data.Import Text File. The Wizard will walk you through the steps. As far a PDF files go, that's not very easy

itsmewhoelse · Apr 23rd, 2002, 12:53 PM

Or...

You can copy it from your .doc or .txt or? and paste in in a single cell, I usually use
a1, and then go to Data>Text to Data and follow the Wizard.
As far as .pdf goes, I think you need at least Acrobat 5.0 ( full version not just the reader ).

Good Luck,
Wesley

ammdumas · Apr 23rd, 2002, 12:56 PM

You can also copy and paste in as a link if you have pictures, wierd fonts, etc.

Edit Menu>>Paste Special>> Follow instructions.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 12:31 PM	#1
coccio Board Regular Join Date: Mar 2002 Posts: 137	I have question in regards to extracting data from one document and importing it into excel. Does anyone know how to do that? Were one can take certain data within a PDF file or MS word document and import it into excel?

Apr 23rd, 2002, 12:44 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	To import from Word or any text file, Choose Data>Get External Data.Import Text File. The Wizard will walk you through the steps. As far a PDF files go, that's not very easy

Apr 23rd, 2002, 12:53 PM	#3
itsmewhoelse New Member Join Date: Apr 2002 Location: Atlanta,Ga Posts: 7	Or... You can copy it from your .doc or .txt or? and paste in in a single cell, I usually use a1, and then go to Data>Text to Data and follow the Wizard. As far as .pdf goes, I think you need at least Acrobat 5.0 ( full version not just the reader ). Good Luck, Wesley

Apr 23rd, 2002, 12:56 PM	#4
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	You can also copy and paste in as a link if you have pictures, wierd fonts, etc. Edit Menu>>Paste Special>> Follow instructions.