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. You change according to your Data structure.Many sources of data are PDF files. NB: The Data I've used to TEST the code has 3 Column(RED Colour Value), so that with For Loop Step & Resize value is 3. XOutRg.Offset(xNRow, 0).PasteSpecial Paste:=xlPasteAll, Transpose:=True Set xOutRg = Application.InputBox('Select output range(specify one cell):', 'Transpose to Excel', xTxt,, ,, , 8) MsgBox 'Used range only contain one column',, 'Transpose to Excel' Set xRg = Application.InputBox('Select Data Range(only one column):', 'Transpose to Excel', xTxt,, ,, , 8) I would like to suggest you VBA Code, this will Transpose the Copied Data Table from PDF to Excel.

Import pdf into excel 2016