How to get pdf data into excel?

buzzing

Board Regular
Joined
Jul 30, 2004
Messages
92
Hi,
I want to use data that I recieve in pdf format, in an excel spread sheet.

Its 6 columns of figures, and i want to put each column in a seperate column in excel, one number in each cell.

I am entering the figures manually at the moment.

Is there a way to copy and paste the figures in, instead?

buzzing
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,062
Office Version
  1. 365
Platform
  1. Windows
Why don't you just try copying and pasting, and then going to Data>Text to Columns...?
 

JeffK627

Active Member
Joined
Jun 22, 2005
Messages
313
What version of Acrobat are you running? If all you have is Adobe Reader, then I don't think you can copy and paste from a PDF. If you have the full version, then you can - Adobe Acrobat 6.0 allows you to basically treat a PDF as if it were a Word document.

One thing - if the PDF is the result of scanning a printed document into Acrobat, then it is no longer text but an image - you will not be able to cut and paste no matter what version of Acrobat you have.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,062
Office Version
  1. 365
Platform
  1. Windows
JeffK627

I've only got Reader and I'm able to copy and paste no problem.

Mind you the results are pretty poor.
 

JeffK627

Active Member
Joined
Jun 22, 2005
Messages
313
Norie said:
JeffK627

I've only got Reader and I'm able to copy and paste no problem.

Mind you the results are pretty poor.

Really? I didn't think that worked. I'll have to give it a try...
 

Watch MrExcel Video

Forum statistics

Threads
1,118,913
Messages
5,575,005
Members
412,634
Latest member
Sumanmathew
Top