Share via

Export PDF table into Excel

Anonymous
2023-03-06T12:34:00+00:00

Hi,

I've a pdf file that has a table (attached), how can I extract this table into excel sheet

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2023-03-06T13:37:45+00:00

    Hi Botros W!

    I am Shakiru, an independent advisor and a user like you, and I am glad to be helping you out today.

    There are different tools and methods that can be used to extract a table from a PDF file into an Excel sheet, depending on the complexity of the table and the formatting of the PDF file.

    Here are two possible approaches:

    1. IMPORT THE PDF FROM THE GET DATA METHOD: * click on the Data tab> Click on the Get Data drop-down list> Select From File> Select PDF file> search for the PDF file> select and click on import> Select the page with the Table from the list of pages> Click the Load button
    2. Export to Excel method: Open the PDF file in Adobe Acrobat Reader or Adobe Acrobat Pro DC. Click on "File" > "Export To" > "Microsoft Excel". Choose a location to save the exported Excel file and click "Save". In the "Export Options" dialog box, select "Table" as the export format and choose whether to export the entire document or only a selected range of pages. Click "OK" to start the export process. The resulting Excel file should contain the table extracted from the PDF file, with each cell in its own Excel cell. This method works well for tables with simple formatting, but may not work well for tables with merged cells or complex formatting.

    Kindly let me know, if you require additional assistance, I will be glad to help further.

    Kind Regards, Shakiru

    7 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nikolino 2,120 Reputation points
    2023-03-06T13:07:56+00:00

    Linked objects and embedded objects

    Instead of inserting an object, you can also insert a hyperlink to another file. This has the advantage of keeping the size of your workbook small and reflecting any changes in the second document in your workbook. The downside is that the second document has to be copied with the workbook - or at least on a computer that can be accessed over the network. If Excel cannot find or access the second file that the link is in, Excel cannot display it. You can still open your workbook, but the contents of the linked file will not appear.

    If file size is not an issue and you want to ensure that the second document is always available, you can embed the file as an object in your Excel workbook. Embedding an object in an Excel workbook saves the entire other file as part of your workbook. Wherever your workbook goes, the embedded file goes with it. Of course, the embedded version of the file is no longer linked to the original file, so changes made in one file are not reflected in the other.

    Insert object into Excel workbook:

    Click inside the worksheet cell where you want to paste the object.

    On the Insert tab, in the Text group, click Object

    Then select the “Create from file” tab.

    Click “Browse” and select the file you want to insert.

    If you want to insert an icon in the table instead of displaying the contents of the file, check the Display as Icon check box.

    If you don't select any check boxes, Excel displays the first page of the file. In both cases, the entire file can be opened by double-clicking. Click OK.

    After you add the icon or file, you can drag and drop the icon or file anywhere on the worksheet. You can also resize the icon or file using the handles. Click once on the file or icon to reveal the handles.

    text source

    0 comments