+ Reply to Thread
Results 1 to 7 of 7

PDF table to excel

  1. #1
    Registered User
    Join Date
    11-12-2021
    Location
    Cali
    MS-Off Ver
    2019
    Posts
    18

    PDF table to excel

    Hi guys, I have a pdf with the tables, but I don't have the excel file. Is it possible to copy the pdf table to excel? There are too many numbers, so I wouldn't be able to copy one by one

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: PDF table to excel

    Hi ShinWaka: Welcome to the forum.

    Depends on the pdf. If you can select text on the pdf, select it all, try C/P into Excel. If you can't select and it's a scanned image, run OCR on the file, and try again.
    If you can select, dump into Excel, and either do a text to columns to parse it out, or better yet, do a power query to break out the fields.

    Pete

  3. #3
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: PDF table to excel

    if you have Adobe Acrobat Pro, it can export to Spreadsheet.

    alternatively, if the text is selectable, then you could try to select everything on the table, copy (CTRL+C), then click once on the first cell of excel, and paste (CTRL+V).

  4. #4
    Registered User
    Join Date
    11-12-2021
    Location
    Cali
    MS-Off Ver
    2019
    Posts
    18

    Re: PDF table to excel

    ------------------------
    Last edited by ShinWaka; 11-12-2021 at 02:56 PM.

  5. #5
    Registered User
    Join Date
    11-12-2021
    Location
    Cali
    MS-Off Ver
    2019
    Posts
    18

    Re: PDF table to excel

    Quote Originally Posted by PeteABC123 View Post
    Hi ShinWaka: Welcome to the forum.

    Depends on the pdf. If you can select text on the pdf, select it all, try C/P into Excel. If you can't select and it's a scanned image, run OCR on the file, and try again.
    If you can select, dump into Excel, and either do a text to columns to parse it out, or better yet, do a power query to break out the fields.

    Pete
    Thank you for your answer. When I try C/P it, everything appears in one line and not in a table as it was in the pdf. How can I resolve it?

  6. #6
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: PDF table to excel

    are you clicking once on the cell, or double clicking?

    clicking once on the cell just selects the cell, double clicking goes into the cell.

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: PDF table to excel

    You can also get a PDF into excel using Power Query which is called Get & Transform Data and found on the Data Tab.

    Here is a tutorial on how to make that happen.

    https://www.youtube.com/watch?v=C6vqy30PDnE
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 06-12-2020, 01:55 PM
  2. Replies: 2
    Last Post: 02-23-2020, 12:21 PM
  3. Replies: 9
    Last Post: 02-01-2019, 07:10 AM
  4. Replies: 6
    Last Post: 12-01-2017, 03:45 PM
  5. Crosstab table to pivot table to plain table exceeds Excel row limit
    By jjsilva in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-30-2017, 11:43 PM
  6. Hardcopy list generated by Excel's Data Table, refresh table and repeat
    By Ronnet2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-27-2015, 06:24 AM
  7. INDEX(MATCH()) between Excel Table and Duplicate of Excel Table
    By ExcelBin in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-28-2015, 05:16 AM

Tags for this Thread

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