Home and office programs are varied, in consecuense, the formats that are handled are also. It is because of that it is usual that we receive a file that we cannot open or edit. Similarly when we send a document, the recipient may not have the program or version indicated.
Fortunately, the compatibility between these has been strengthened over time. For that reason, it is possible to pass information between documents from one software to another different.
Among the most used extensions outside the Office suite is the Adobe PDF. To know how to use the data included in the latter within Excel, we bring you this post.
Steps to open a PDF file in Microsoft Excel without losing information
As we anticipate, in this post content you will learn to use the information stored in a table inside a document PDF in you Office spreadsheet. In this way you will avoid redoing the work or asking your partner again. Within this Step by Step you will find two ways to do it. The first will use the same PDF program. The second does not require any additional payment program, in addition to those that you already have installed on your computer.
Let's start:
Converting PDF to XLSX
It may be obvious, but the best way to do this is with Adobe Acrobat DC software.
To do this, follow these steps:
- Once the document is opened in PDFgo to right panel and click on the tool "Export PDF".
- Then select "spreadsheet" as the output format.
- Choose "Microsoft Excel Workbook".
- To finish click on "To export".
Natively
The only drawback with the above form a paid license is required of this program. Unlike the free version that only allows us to read the document.
However, there is an alternative method without the need to invest money:
- Open the document .pdf (it doesn't matter if you don't have Acrobat paid version)
- Inside the table Choose the headers and copy them with "Ctrl + C".
- Open a new notepad and tap "Ctrl + V". Make sure that between each column there is a space. Press "Enter" to download a line.
- Then, copy the data included in the table.
- Job said content on the pad.
- Guard the new document .txt in the location you want.
- Start Microsoft Excel and create a new spreadsheet.
- Inside the menu "Archive" Press the button "open" and choose and open the document .txt recently created.
- Doing so will bring up a window with a result preview. In tab options select "Separate by" and "Space". Press "To accept" to end.
List of the best online tools to convert PDF to XLSX
A simpler and at the same time free way is to use a conversion software. It is best to use one On-line, in this way we will not take up space on our disk. Unfortunately most have limitations in their standard versions.
But if it is a small document these are the best pages to do it:
PDFToExcelOnline.com
It is considered by several experts as the best choice to convert files PDF to XLSX since it does not need any type of registration or payment. You just have to upload the original file to the site, choose the output format and press "Convert". The site ensures that the 100% of the data.
PDFConverter.com
The next in the list is this page that works completely online and no payment required to be used. However, you need to register on the site. Since the result of the conversion is sent by email.
PDFToExcelConverter.net
The last one on the list uses the same mechanics as Drag and drop than the previous ones. But add the possibility of use files saved in the cloud to convert them. It also offers a paid desktop version with more profits.