PDF ---> Excel?

djl0525

Well-known Member
Joined
Dec 11, 2004
Messages
1,237
Has anybody ever gotten data from a pdf file into Excel? I tried copy and paste. That got me everything in one column even though my pdf looks like 6 columns of data. The Save As box lets you save a pdf as a Word document, but not Excel. Should I give up or is there a way?

DJ
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Pekkavee

Well-known Member
Joined
May 25, 2004
Messages
1,218
1, You could try Data + Text to columns - etc. in Excel to separate them.

2. You could try copy and paste from Word

3. You can use a special program to make PDF to Excel, they are out there somewhere ( free of charge or commercial programs, like http://www.solidpdf.com/pdf/_convert_to_excel/91 )

Search Google with "PDF to Excel", there are plenty of them.

Pekka
:eek: :eek:
 

djl0525

Well-known Member
Joined
Dec 11, 2004
Messages
1,237
Thank you for your reply.

1. Doesn't work because the imported data contains no delimiters.

2. I tried that it didn't work either.

3. Good lead. I don't see any free ones though. Trial versions, but none free.

Thanks again,
DJ
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,993
Messages
5,834,772
Members
430,320
Latest member
Napzz

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