How To Translate Pdf Into Excel

2024 Author: Timothy Dodson | [email protected]. Last modified: 2023-12-16 06:44

PDF is the most common format used for reading documents. However, this format is not intended for data editing. Of course, some manipulations with the document can be done, but often there are not enough tools for serious work. Fortunately, you can transfer PDF to Excel and continue editing in Microsoft's spreadsheet editor. This article will just tell you how to complete the task.

Methods for converting pdf to Excel

In total, there are two ways to convert a file from PDF to Excel. The first involves the use of special reading applications. The second is specialized software. Let's consider each in detail.

Method 1: using reading apps

It should be said right away that this method of converting a file from PDF to Excel is the least popular. Although some of the data is not lost during conversion, the style of the text is lost. But it's still worth considering. So, to complete the task, you need to have an installed program for reading PDF files on your computer. In this case, we will be using Adobe Acrobat Reader. Here's what you need to do:

1. Run the specified program.
2. On the top bar, click the "File" button.
3. In the menu that appears, select the "Open" item.
4. In the new Explorer window, go to the folder with the PDF file and double-click on it.

The file will open in the program. Now it needs to be converted to text. That is, convert to TXT format. To do this, follow these steps:

1. Click on the "File" button again.
2. In the menu, hover over the "Save as Other" item.
3. In the submenu that appears, click on the "Text" line.
4. In the "Explorer" window that appears, navigate to the folder where you want to save the file.
5. Click the "Save" button.

Now you can proceed directly to placing data from PDF into Excel. To do this, do the following:

1. Use Notepad to open the file you saved earlier.
2. Select all or part of the text you want to place in Excel.
3. Right-click and select Copy.
4. Run the Excel program.
5. Place the cursor in cell "A1".
6. Press PUM and select the first item in the Paste Options group.
7. Select the entire column A.
8. Go to the Data tab.
9. Click on the "Text by Columns" button on the panel.
10. In the window that appears, check the "Separated" item and click "Next".
11. In the second step, mark the space separator character and click Next.
12. At the third step, in the "Data format" block, set the switch to the "text" position.
13. In the line "Place in" write $ A $ 1.
14. Click Finish.

Now you know how to convert PDF to Excel. This is a cumbersome method, so it may not work for everyone.

Method 2: using third-party programs

There is a special PDF to Excel converter. It is much easier to accomplish the assigned task. We will consider the Total PDF Converter program:

1. Run the program.
2. On the left pane, go to the folder with the PDF file.
3. All documents will appear in the central part of the window.
4. Check the box you want. On the top bar, click the XLS button.
5. In the window that appears, specify the folder where to save the modified file.
6. Click "Get Started".

A window will appear showing the conversion process. You need to wait for it to complete and then close the program. The converted file will be located in the folder that you specified in paragraph 5 of the instructions.