How to Convert PDF Documents to Excel

PDF or Portable Document Format files are document files using the .pdf extension developed by Adobe. With Adobe Acrobat you can create standard PDF documents, PDF documents with editable fields, secure PDF documents and more. You can also export data in formats that allow you to convert a PDF to a document in Microsoft Excel, a spreadsheet application used by many business and accounting professionals to track information and tabulate certain comparisons and mathematical formulas.

Difficulty: Moderate

Instructions

Things You'll Need:

• Microsoft Excel 2007
• Adobe Acrobat 9 Pro

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

2. 
   XML Export Location Reference

   Click "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.

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

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

5. Select "Open" from the menu.

6. Click "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.

7. Select "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).

8. Delete 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."

References

• PDF Files on Wikipedia

Resources

• Adobe Acrobat 9 Pro Full Version Free Trial Download