If you select a table in a PDF document and copy it in order to then paste it into an Excel table, the data is usually not distributed appropriately to rows and columns, but rather it all ends up in a single cell. There are two ways to remedy this.
You either open the PDF document in a good PDF reader instead of a browser, or you import the required data using an Excel function.
This is how it works with Excel:
In Excel, select the “Data” tab and then select “Retrieve data -› From file – ›From PDF”. Select your PDF file. A window appears with the page information on which the tables of the PDF document are located. Select the page that contains the table you want. It is displayed on the right in the current window for checking. A click on “Load” brings the table correctly formatted into the Excel document. A new worksheet is created for this.
Via “Data -› Retrieve data – ›From file -› From PDF ”you can import tables from PDF documents in such a way that they are correctly distributed across columns and rows.
Note: The imported data remain linked to their source, i.e. the PDF document, in Excel. In most cases this is not what you want with a PDF document. We therefore recommend marking the imported table and copying it with Ctrl-C, for example. You can remove the copied data from the source via “Paste -> Paste values”. You can use the copy to overwrite the previously imported data when you insert it, or you can delete the imported data after you have inserted it elsewhere.
Copy with PDF reader:
If you use a good PDF reader, such as Foxit Reader, you can use it to open the PDF document, select the table you want, copy and paste it into Excel. As a rule, it is correctly distributed across rows and columns.
20 tips for working faster with Excel