I need to create an excel worksheet for UK dietary reference values into one single table.
I found a PDF verson (see link below) but when I copy and paste the table contents form the PDF into excel it doesn't come out in a table format,
Can someone please advise how I can get this table of values into excel please?
Thanks
Main heading (publishing.service.gov.uk)
","comment":[{"@type":"Comment","@id":"https://www.hotukdeals.com/comments/permalink/52275038","author":{"@type":"Person","name":"spoo"},"datePublished":"2024-02-26T09:03:27.000Z","text":"smallpdf.com/pdf…ord
This site converts a PDF into a Word document, you can then copy and paste the table you want from Word into Excel.
It' s not perfect though, always check the formatting. In this example it's split the bottom row of the table into two rows and has done the classic excel thing of wrongly assuming a number is a date in the column headers."},{"@type":"Comment","@id":"https://www.hotukdeals.com/comments/permalink/52274913","author":{"@type":"Person","name":"Tuta"},"datePublished":"2024-02-26T08:41:35.000Z","text":""},{"@type":"Comment","@id":"https://www.hotukdeals.com/comments/permalink/52275712","author":{"@type":"Person","name":"EndlessWaves"},"datePublished":"2024-02-26T10:51:46.000Z","text":"I'm not familiar with the latest version of excel but there should be a paste option that lets you define separators/delimiters. In Libre Office Calc it's under Paste Special > Paste Unformatted Text (Ctrl+Alt+Shift+V, which may be the same in excel).
That'll let you tell the spreadsheet app to put blocks of characters separated by spaces into different cells.
For the row titles that have spaces you'd either have to copy and paste them separately or you may be able to dump it into a text file first and put quotation marks around them to stop the spreadsheet program from separating them."},{"@type":"Comment","@id":"https://www.hotukdeals.com/comments/permalink/52277284","author":{"@type":"Person","name":"mug"},"datePublished":"2024-02-26T14:38:02.000Z","text":"If you have more tables you'd like to retrieve from the same document, the 'Get data' tool/Power Query is good for that.
Data >> Get Data >> From File >> From PDF
or
Data >> Get Data >> From Other Sources >> From Web
Alternative to the used solution; convert and copy, you can open the PDF as a Word file and it will convert the document, then you can copy and paste."},{"@type":"Comment","@id":"https://www.hotukdeals.com/comments/permalink/52277456","author":{"@type":"Person","name":"zworlds"},"datePublished":"2024-02-26T15:02:51.000Z","text":"You need Adobe Acrobat Pro DC.
I have converted the document for you. Here you go :
transfernow.net/dl/…8Al
You can use this to convert for free if you do not Adobe Acrobat pro DC
adobe.com/uk/…tml"}],"commentCount":11,"interactionStatistic":1,"articleSection":"Ask"}