PDF documents are very popular due to the fact that they can be opened on a computer with any operating system. Converting a pdf file to a file for Excel is most often necessary for working with table data. So how do you convert a pdf file to xls?
To open a document to work with table data in Excel, the file must be in xls format. Most often, tables in pdf files can be seen in the price lists of various companies. In order to make changes in the table of the document, which is in pdf format, it will have to be converted to a file for Excel. There are two ways to convert pdf to xls.
Convert a pdf document with Acrobat Reader and Excel
These programs, as a rule, are present for many users, especially if you often have to open pdf files and work with tables. Converting pdf to xls is divided into two steps:
- converting a pdf file to a text document in Acrobat Reader;
- converting a text document to a file for Excel.
To make a text file from pdf in Acrobat Reader, you need to follow these steps:
- Open the required pdf file in Acrobat Reader.
- Next, you need to select the "File" menu, in the list that appears, click on "Save to others", and then - "Text". There is another way to save the pdf file as plain text. To do this, in the "File" menu, select "Save As", then "File Type" and then - "Text File"
- The next step - in the window that opens, you must specify the file name, as well as the directory for saving. After that, you should click the "Save" button.
This completes the first stage. To convert the resulting text file to Excel, you need to do the following:
- Open Excel and text document.
- Transfer data from a text file to Excel to cell A1. You must use automatic distribution. To do this, you need to click "Data", then select "Work with data" and click on the item "Text by columns".
- In the window that opens, go to the section "Format of source data", then click on "With delimiters" and click the "Next" button.
- Then you need to specify a space as a separator, and uncheck the rest.
- In the item "Sample data parsing" you need to specify any column.
- In the "Column data format" item, select "Text".
- Then you should repeat the previous points for each column.
- To organize data in Excel from a text document that was previously a pdf file, you must click the "Finish" button
How to convert pdf to file for Excel online
If you don't have Acrobat Reader on your computer, or if the two-step pdf to xls conversion using Acrobat and Excle seems impossible, you can use online converters. To do this, you need to find a suitable converter site on the Internet, and then do the following:
- Upload the required pdf-file to the service to convert it to xls for Excel.
- Wait until the end of the process and download the finished Excel file to your computer.
