Extract data table from PDF to Excel

M

mmurillo

New Member
Joined
Nov 12, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have a multi-page PDF document with tabular data in it. Is there a way to extract the data into Excel if copy/paste doesn't work?
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
Use Power Query.
Data-->Get and Transform Data-->Get Data-->From File-->From PDF
Select Table and click on Load
 
Upvote 0
Can Power Query be used with MS Excel 2007? If No, any alternative way to accomplish the above task (i.e extracting the data from a a multi-page PDF document with tabular data into Excel if copy/paste doesn't work) in MS Excel? Or any ways oif integrating Power Query with MS Excel 2007?
 
Upvote 0
Power Query is not available in XL2007. You need to be running XL2010 or later. Your only other option is to write VBA.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Extracting out Title in PDF -> Word conversion
Replies
8
Views
144
NdNoviceHlp
NdNoviceHlp
L
  • Question
VBA read PDF
Replies
0
Views
279
Luke777
L
P
  • Question
PDF to Excel and Format - Rent Roll Related
Replies
4
Views
157
PeakSquare
P
C
  • Question
Extracting Specific Fields from multiple PDFs with VBA (Excel 2019)
Replies
1
Views
232
chickyguy
C
F
  • Question
Extracting specific data to populate specific blocks in excel sheet.
Replies
0
Views
483
flintwc64
F

Forum statistics

Threads
1,214,929
Messages
6,122,314
Members
449,081
Latest member
tanurai

Share this page

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
Back
Top