How To Copy From Pdf To Excel

Active6 months ago
  • 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?

Chenmunka
2,7848 gold badges20 silver badges31 bronze badges
Luke AllenLuke Allen

How To Copy Table From Pdf To Excel

How

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 Fitzpatrick
14.8k4 gold badges37 silver badges41 bronze badges

You can use the Microsoft word 'Convert to table' function outlined here.

It's not exactly what you need but at least it is quicker.

dkanejsdkanejs

How To Copy Data From Pdf To Excel

Try to upload it to Google Docs and then save as XLS file, it should work

MichaelTMichaelT

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.

kenorbkenorb
13.1k18 gold badges88 silver badges134 bronze badges

protected by CommunityMay 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?

Not the answer you're looking for? Browse other questions tagged pdfcopy-paste or ask your own question.

Comments are closed.