Requirement: Transferring PDF Data into Excel Sheet
Instead of copying the pdf file directly into excel, Follow the below steps.
Step 1:Create a PDF which contain a table in it.
![](http://rishandigital.com/wp-content/uploads/2023/05/image-68-1024x547.png)
Step 2:Now Go to the Excel sheet Click on Data at top navigation bar then click on Get Data, From get data select a From File option and from that select an From PDF option.
![](http://rishandigital.com/wp-content/uploads/2023/05/image-64.png)
Step 3:Select a PDF file and click on Import button. Now select Table to display on Page and click on Load button.
![](http://rishandigital.com/wp-content/uploads/2023/05/image-65.png)
![](http://rishandigital.com/wp-content/uploads/2023/05/image-66-1024x609.png)
Step 4:The PDF file is transferred into Excel sheet.
![](http://rishandigital.com/wp-content/uploads/2023/05/image-67-1024x420.png)