Press OK.Ī table will appear (poorly formatted) which will be all highlighted. A dialogue box will pop up and under Separate Text at, you should select Other and click in the little box next to it delete what is there and type in a space. Now convert this into a table by highlighting it all (you can easily do this by pressing Ctrl A) and selecting Table > Convert > Text to Table. Open a new Word document and paste the copied text by pressing Ctrl V. Step 2: Copy this into Word and convert to a table To copy the table, click on Select and click and drag the cursor to highlight the whole table. The first page of Table 10 from the Spring 2007 version of the European Economy Statistical Annex is shown below. This shows economic growth rates for all 27 EU countries plus the USA and Japan (see site 8 in our links to free economic data) Step 1: Open the relevant PDF file and select and copy table We will use Table 10 from the European Economy Statistical Annex. If such services are not working for you, there is also a conversion process that involves moving the data first into Word and then into Excel. There are online services to convert data tables from PDF to spreadsheet for example, , PDF2Excel, SmallPDF, or DocsZone.

Insert pdf table into excel