How To Import Data in Excel from PDF or Image
This simple trick allows you to import data from pdf files which are in tabular format. When you are in Excel, just go to the Data tab and click on the first option, Get Data, From File, From PDF. Then choose the PDF file from which you wish to import the data and it is imported into Excel instantly! Just remember that you may have to do a bit of cleaning up if the original PDF file is not properly formatted; but it saves a lot of time by not having to input the data manually.
 
If you are using Microsoft Office on your Android phone (now re-christened Microsoft 365), go to the Apps tab in your App, tap on Scan and then on Image to table. This will allow you to take a photo of your table from a book or magazine and directly create an Excel sheet for it. Pretty cool, huh?
 
Comments
FRANCISXAVIER
1 year ago
mine is excel 2019. "From PDF" option not available!!
adityag
1 year ago
Just learn Python. Extra helpful to learn UNIX and Bash as well.
Array
Free Helpline
Legal Credit
Feedback