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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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
123
NdNoviceHlp
NdNoviceHlp
L
  • Question
VBA read PDF
Replies
0
Views
260
Luke777
L
P
  • Question
PDF to Excel and Format - Rent Roll Related
Replies
4
Views
149
PeakSquare
P
C
  • Question
Extracting Specific Fields from multiple PDFs with VBA (Excel 2019)
Replies
1
Views
185
chickyguy
C
F
  • Question
Extracting specific data to populate specific blocks in excel sheet.
Replies
0
Views
470
flintwc64
F

Forum statistics

Threads
1,214,622
Messages
6,120,572
Members
448,972
Latest member
Shantanu2024

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