- When I copy data in a table like this from a PDF, it gets translated into plain text without any delimiting characters to distinguish which column the data is in. It would be helpful if I could highlight only a single column in the pdf at a time, but it currently tries to select left to right both columns as I.
- Aug 22, 2019 Excel gives you many more options for editing, but what if someone sends you a file in PDF format? It's easy enough to convert a PDF to just about anything and Excel.
When I copy data in a table like this from a PDF, it gets translated into plain text without any delimiting characters to distinguish which column the data is in.
A PDF's content can be displayed in programs other than Adobe Reader, including Excel. Adobe Reader allows you to copy PDF content, with custom options for the copying method, which you can paste into an Excel document to illustrate a report.
It would be helpful if I could highlight only a single column in the pdf at a time, but it currently tries to select left to right both columns as I highlight. Is there any trick for this?
ChenmunkaHow To Copy Table From Pdf To Excel
4 Answers
Holding down the Alt key should allow you to select a column of text.
(Note: I've only tested this with Acrobat Pro, not Acrobat Reader.)
Mike FitzpatrickMike FitzpatrickYou can use the Microsoft word 'Convert to table' function outlined here.
It's not exactly what you need but at least it is quicker.
How To Copy Data From Pdf To Excel
Try to upload it to Google Docs and then save as XLS file, it should work
It's not straight forward, however there are a large number of free or cheap services in the cloud for extracting such tables from PDFs.
Please find below the comparison table automated table extraction solutions according to Zanran:
So based on above, you may consider Zanran's Table Xtractor which has ability to finds the tables in your PDFs and converts them to Excel.
kenorbkenorbprotected by Community♦May 11 at 15:46
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?