import data from PDF into excel sheet with the same structure

[Hasson]

hello

I put this link VBA Express : Excel - get the data from PDF file into Excel sheet(s) or text file(s) you can see the code . I don't attach code because is too big.

so the code import all of data from file pdf into one column A into sheet excel . I search for way if it's possible I have the data into table for about 4 or 5... columns from pdf file should import with the same structure into excel sheet in columns A,B,C,D.... and the same thing with separated cells instead of into one column A . like the same thing as in import specific sheet from file to another . I hope my question is logic as for VBA
thanks

 

[Candyman8019]

Do you need to do this programatically? If not, you can open the .pdf doc with Word then simply copy the table into Excel.

 

[Hasson]

Do you need to do this programatically?

yes this is what I look for.

 

[alansidman]

Easiest way is with Power Query. Look at this video. PQ is called Get and Transform in 2016 and found on the Data Tab

 

[Hasson]

thanks

choice PDF is not available in office version . it just seem in office365 .

I don't see PQ in the ribbon. how should show?
sorry I have no experience with PQ. may you guide me ?

 

[alansidman]

In your version, PQ is called Get & Transform Data and is found on the Data Tab of the Ribbon.

 

[Hasson]

ok I got it , but is not available PDF with office 2019 as in the video . is there difference with office 2016?

 

[alansidman]

Sadly, as you can see in this link, it is a 365 option which I did not realize.

Excel 2016 Get data from PDF missing | Microsoft Community Hub

Hi all, I'm using Excel 2016 on Windows 10, and I find that I don't have the option to get external data from PDF. Any idea what could be the issue...

techcommunity.microsoft.com

 

[Hasson]

@alansidman thanks may be some body has knowladge does it by vba .

 

[alansidman]

@Hasson
Maybe. But Power Query is quick and easy and no code required. Can all be done in the UI.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.