Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to copy the following table into excel but when I do it doesn't format it as a table as the source isn't a proper table.

Is there any way to copy it without having to do it manually?

share|improve this question
up vote 4 down vote accepted

You can use your PDF reader's column selection feature to copy each column of the table individually. Each column can then be pasted one-by-one into a Microsoft Excel spreadsheet.

For example, useAlt+Drag with Adobe Reader's Select Tool.


share|improve this answer
Excellent! Didn't know about this feature! Will come in handy for lots of other things :) – Aasim Azam Dec 26 '12 at 2:02

How about converting the PDF file to a text file and then you should be able to import the data. There are many utility programs around to do this, some not so free.

share|improve this answer
Can you expand on what you mean by "converting the PDF file to a text file"? In the example given, you are able to convert the PDF to text by simply selecting and copying the text, as the text data is already present. The issue here is that the text uses a space character as the table's column delimiter when space characters are used in the cells. – iglvzx Dec 26 '12 at 2:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .