TL;DR Key Takeaways : Open a blank workbook in Microsoft Excel. Navigate to the ‘Data’ tab in the Excel ribbon. Select ‘Get Data’ and then choose ‘From File’ followed by ‘From PDF’.

To solve the situation, one can convert the PDF file into an Excel format file after which you can easily edit the elements you want to.

1. Copy the source table from a PDF file. Open the PDF file in Adobe Reader, or any other PDF viewer, select the table you want to convert to Excel and press Ctrl+C to copy it to the clipboard. 2.

Open the PDF file in Adobe Acrobat. Locate the “Export PDF” tool in the toolbar or menu options. Select “Spreadsheet” as the format and choose Excel (.xlsx) as the output type.