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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,230
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,230
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,123,239
Messages
5,600,486
Members
414,383
Latest member
konmtu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top