How to Convert PDF Documents to Excel

nishantbaxi 2:03 am on March 1, 2010 | Answers: 1    
Tags: convert (131), convert pdf documents, excel (44), pdf (47)

Rate Knowledge:

 Loading ...

• nishantbaxi 2:03 am on March 1, 2010
  

  Step 1Open your PDF document by double clicking on its title or icon. Adobe Acrobat will start automatically.

  Step 2

  XML Export Location ReferenceClick “File” in the top menu bar on the left side and select “Export”>>”XML 1.0″ from the list. See the image here for reference.

  Step 3Select “Desktop” from the save window on the left side and click “Save” at the bottom of the window.

  Step 4Open Microsoft Excel and click the Office icon in the upper left corner.

  Step 5Select “Open” from the menu.

  Step 6Click “Desktop” on the left side of the open window. Locate and select the PDF you exported as an XML document. Click “Open” at the bottom of the window.

  Step 7Select “Open as an XMLtable” when asked how to import the XML file. Click “Okay” at the bottom of the Open XML window. Click “Okay” when prompted about creating a schema (there are no settings in this window).

  Step 8Delete all columns except the one labeled “TD” as they contain extraneous XML information. Reformat the information from the PDF as you choose and save to a desired location by selecting Office icon>>”Save”>>”Okay.”