+ Reply to Thread
Results 1 to 6 of 6

Importing a PDF table into Excel

  1. #1
    Registered User
    Join Date
    05-29-2008
    Location
    Ontario, Canada
    Posts
    19

    Importing a PDF table into Excel

    I have a PDF table that I need to import into Excel. Copy and pasting creates one big column with all of the values in the table. Example:

    PDF table is:


    3 5 6 9
    1 2 3 4
    5 6 7 9

    Copying results in:

    3
    1
    5
    5
    2
    6
    6
    3
    7
    9
    4
    9

    Anyway to fix this? I have to do a bunch of files and need something quick.

  2. #2
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Importing a PDF table into Excel

    Zapp,

    when I import a table into excel make sure you select delimited. I just tried it and it imported properly.

  3. #3
    Registered User
    Join Date
    05-29-2008
    Location
    Ontario, Canada
    Posts
    19

    Re: Importing a PDF table into Excel

    Where do you find this option? I tried "Paste Special" but the only options are text and unicode text.

  4. #4
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Importing a PDF table into Excel

    Ah thats the issue, you are trying to cut and paste. You need to use the import function in excel.

    1. select the table data you want in the PDF format. Right click it and click save table as. (if you have a newer version and adobe then you can click open in excel)

    2. open excel and get data. find the PDF file you saved and then click open.
    3. there you will see the delimited option.

    I hope this helps.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Importing a PDF table into Excel

    If you're using Adobe, you can select the table, right-click, and select Open Table in Spreadsheet
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Registered User
    Join Date
    05-29-2008
    Location
    Ontario, Canada
    Posts
    19

    Re: Importing a PDF table into Excel

    I get stuck at step one since there is no table option when I right-click in Adobe. I think the issue is that the file is constructed so that the text doesn't have any returns but is made to show these values as being next to each other. So it isn't a "Table" by definition. You can tell in this picture just by the way the text gets highlighted.

    Still no clue how to fix this lol
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1