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.
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.
Step 3:Select a PDF file and click on Import button. Now select Table to display on Page and click on Load button.
Step 4:The PDF file is transferred into Excel sheet.