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.

The width of the columns in the new table may need to be adjusted to fit the data correctly. The copied data is automatically displayed in a table in your Word document.

How to change the font color, size, style, or type in Word.

In the pop-up menu, under Paste options, select your preferred method for pasting, or press Ctrl+ V on the keyboard.Īfter copying the Excel data into a Word document, you may need to change its formatting as the font size and type may change to the defaults set in Microsoft Word.

In Microsoft Word, right-click the location where you'd like to paste the Excel data.

Right-click the highlighted cells and select Copy in the pop-up menu, or press the Ctrl+ C keyboard shortcut.

How to select one or more cells in a spreadsheet program.

In Microsoft Excel, select the cells containing the data you want to copy to the Word document.

Copying and pasting the data in Word can save you time as you don't have to create a blank table in Word, and then re-enter everything. After entering data into a Microsoft Excel spreadsheet, you can copy that data and paste it in a Microsoft Word document.

Copy word table to excel