Monday, May 28, 2012

How to Import PDFs Into Excel 2007


1. Open Adobe Acrobat Reader. Click 'File' and select 'Open File.' Select the file that you want to import into Excel.
2. Press and hold the 'Shift' and 'V' keys on your computer. This opend the Table/Formatted Text tool.
3. Click and drag a box around the table in the PDF that you want to import. This highlights the table. Select 'Save As...' from the window that appears.
4. Type a name for your new file. Click the drop-down menu next to 'Save As Type.' Choose 'ANSI Text' from the list. Choose a destination folder for your new file and click the 'Save' button.
5. Open the Excel 2007 program. Click 'File' and select 'Open.' Navigate to find the ANSI file you've just saved. Click the 'OK' button. Click the 'Delimited' option in the new window and then click the 'Next' button. The table appears in an Excel spreadsheet as it appeared in your PDF document.

Blogger news