Are you looking for a quick and easy way to import your data tables PDF to Microsoft Excel? In this case you have come to the right place!
This article aims to show you the best way to import data from PDF to Excel. We at Softstore.it recommend using the PDF Converter program to convert PDF to Excel and automatically import all tables and data. It’s true that you can also find converters on the internet “online” but the quality of PDF to Excel conversion with such tools is really bad.
However, let’s take a look at a couple of solutions and then you will decide what you consider most reliable also based on the type of data and the work you need to do.
How to import PDF to Excel with PDF Converter
The first solution involves the use of professional PDF conversion software. With this program you will be able to convert the entire PDF into an Excel file, and then all the data (data tables) will be automatically imported into Excel sheets, ready to be analyzed with the Excel functions themselves. Here are the steps to follow.
Step 1. Download and install PDF Converter
First click on the “download” on the page PDF Converter (for Windows). If you have an iMac, MacBook Pro then download PDF Converter for Mac with which you can import PDF to Excel with Mac. This article considers the version of PDF Converter for Windows and shows how to carry out this import and conversion from PDF to Excel on PC. After downloading, install the application on your computer.
Step 2. Import PDF files and select Excel as the output format
From the main window you will see a button “Add PDF files” top left. To import PDF files, click on this button to select the PDF files to convert to Excel from your hard disk. You can import up to 200 PDF files at a time. To save time you can perform batch conversion of multiple PDF files at the same time.
After importing PDF files, you need to select Microsoft Excel as the output format from the drop-down menu on the right. To customize the output and import of data into Excel, click on the “Advanced settings“. From here you can import PDF files into Excel with all pages in a single Excel sheet or all pages in a single Excel sheet.
Step 3. Import PDF files into Excel
Before importing the PDF data into the Excel worksheet, you can decide whether to import all the pages into an Excel file or select only certain pages of the PDF to convert and import into Excel. After making these settings, click on the “Convert” to start importing PDFs into Excel. After the conversion, click on the small “folder” icon to open the Excel file obtained from the conversion.
Import PDF tables into Excel manually
Step 1: Open the PDF and copy the table
To copy the table, click Select and click and drag the cursor to highlight the entire table. Then press Ctrl + C (to copy it).
Step 2: Copy the data into Word
Open a new Word document and paste the copied text by pressing Ctrl + V. It should look like this:
Now convert it to a table by highlighting it all (you can do this easily by pressing Ctrl + A) and selecting Table > Convert > Text to Table. A dialog box will appear and in Separate text intoyou should select Other and click in the small box next to it; delete what’s there and type a space. to press OK.
A table will appear (still not very well formatted) which will all be highlighted. While it’s still highlighted, copy it by pressing Ctrl+C.
Step 3: Paste data table into Excel
Open a new blank Excel document. The first cell should be highlighted. Click in this cell and paste the table you copied from Word. To do this, simply press Ctrl + V. This will give you a table similar to the following.
Step 4: Edit and analyze the data table
Now you will have to do a little manipulation. It will help you if you have an icon Insert row and an icon Delete row in the top toolbar.
First make sure the columns are aligned correctly. Then delete unwanted rows by selecting the row (click the row number in the left column) and then press the delete row icon.
Convert PDF to Excel (online)
Finally, we also want to offer an online solution that allows you to convert a PDF to Excel. We are talking about the iLovePDF service.
Once you have accessed the service page you will have to press the red “Select PDF file” button and upload the PDF from your computer. Once loaded, press “Convert to Excel” and after a few seconds a new page will open with the link to download the Excel file obtained from the conversion
It must be said, however, that online services like the one just proposed are often not very precise and reliable. For example, we tried to convert a data table from a PDF, and the result was an Excel file with several sheets, in each of which there was a part of the source table. In short, the result was not as hoped.
However, since it’s free, you don’t lose anything by giving it a try and trying convert PDF to Excel. Maybe you will be luckier than us! 🙂