The VBA code below which will cycle through the selected data and recreate a table layout.ĭim NoOfColumns As Integer Dim TargetRow As Integer Dim TargetCol As Integer Dim i As Integer 'Set the initial values for the variables of where to place the table If the paste into Excel is just a list of values in one column we can turn to VBA for a bit of help.

It may not be perfect, but it’s still closer than what you had before. Or maybe, which is more likely, you have a table which requires a bit of tweaking. You may now have a perfect data table in Excel. However, Word is actually better at dealing with PDF tables. Here is our example PDF file: Copy table from PDF to Excel via WordĮxcel is a software program which is designed to work with tables, whilst Word is designed to work with text. One of these should work, providing reasonable results and saving you time. I would love to offer you the perfect solution to get the PDF data table into Excel, however I don’t believe there is one. If the paste displays as a picture, then as far as I know, you will need to resort to third-party software which contains OCR. If the paste is either a list of values or a continuous text string, then there are some possible workarounds. In my experience the pasted data will show as one of the following: The pasted information will be displayed in Excel differently based on how the PDF was created. Pasted Strings: Use VBA to split the string.Pasted strings: Use Excel functionality to split the string.Pasted list: Use VBA to format the list.

Extract table from pdf to excel