PDF ---> Excel?

djl0525

Well-known Member
Joined
Dec 11, 2004
Messages
1,235
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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

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,235
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,055
Messages
5,569,948
Members
412,299
Latest member
agentless
Top