Transfer a table from PDF to Excel. Like on one PDF page Place a whole leaf Excel

PDF today is one of the most popular reading formats. But, with data in this format is not very convenient to work. Transfer it to more convenient formats intended for data editing is not so easy. Often, when using various tools for conversion, when transferring from one format to another, there is a loss of information, or it is displayed in a new document incorrectly. Let's analyze how you can convert PDF files to the formats supported by the program Microsoft Excel..

It should be immediately noted that the Microsoft Excel program has no built-in tools with which the PDF could be converted to other formats. Moreover, this program It will not even be able to open the PDF file.

Of the main ways, with the help of which the PDF is converted to Excel, such options should be allocated:

  • transformation using special applications for conversion;
  • conversion using PDF reading applications;
  • use online services.

We will talk about these versions below.

Conversion using PDF reading applications

One of the most popular programs for reading files in PDF format is an application. Using it tools, you can make part of the PDF translation procedure in Excel. Second half this process will need to perform already in the most microsoft program Excel.

Open the PDF file in the Acrobat Reader program. If this program is installed by default to view PDF files, it can be done by simply clicking on the file. If the program is not installed by default, you can use the function in the menu windows Explorer "To open with".

Also, you can run the Acrobat Reader program, and in the menu of this application, go through the "File" and "Open" menu.

A window will start, where you want to select a file that you are going to open, and click on the "Open" button.

After the document is open, you need to click on the "File" button, but this time go through the menu items "Save as another" and "Text ...".

In the window that opens, you should select a directory where the file in the TXT format will be stored, and then click on the "Save" button.

On this program, Acrobat Reader can be closed. Next, open the saved document in any text editor, for example, in the standard Windows notepad. Copy the entire text, or that part of the text you want to insert into the Excel file.

After that, run the Microsoft Excel program. With the right mouse button on the top left cell of the leaf (A1), and in the menu that appears, select the "Paste ..." item.

Next, clicking on the first column of the inserted text, go to the "Data" tab. There, in the "Working with Data" toolbar, click on the button "Text to columns". It should be noted that, at the same time, one of the columns containing the transferred text must be highlighted.

Then, the text Wizard window opens. In it, in the section called "source data format" you need to make sure that the switch stood in the "with separators" position. If it is not so, then it should be rearranged in the desired position. After that, we click on the "Next" button.

In the list of divider symbols, we install a tick opposite the "Space" item, and it takes off opposite all other items.

In the window that opens, in the "Column Data Format" parameters, you need to set the switch to the "text" position. Opposite the inscription "Place in", specify any sheet column. If you do not know how to register his address, then just click on the button next to the data entry form.

At the same time, the master of the texts will come, and you will need to click on the column that you are going to specify. After that, its address will appear in the field. You can only click on the button to the right of the field.

Again opens master texts. In this window, all settings are entered, so I click on the "Finish" button.

Such an operation should be done with each column that was copied from pDF document on an Excel sheet. After that, the data will be ordered. They are only left to maintain in the standard way.

Conversion using third-party programs

Conversion of the PDF document in Excel with third-party applicationsOf course, much easier. One of the most convenient programs To perform this procedure is Total PDF Converter.

To start the conversion process, launch the application. Then, in his left part, we open the directory where our file is located. In the central part of the program window, select the desired document, putting a check mark near it. On the toolbar, press the "XLS" button.

A window opens in which you can change the display folder of the finished document (by default it is the same as the source), as well as spend some other settings. But, in most cases, those settings that are exhibited by default is quite enough. Therefore, we click on the "Start" button.

The conversion procedure is launched.

Upon completion, a window opens with the corresponding message.

Approximately the same principle also employs most of the other applications for the PDF conversion to Excel formats.

Conversion through online services

For conversion through online services, you do not need to download any additional software. One of the most popular similar resources is SmallPDF. This service is designed to convert PDF files to various formats.

After you switched to the section of the site, which makes conversion to Excel, simply reflect the required PDF file from the Windows Explorer to the browser window.

You can also click on "Select File".

After that, the window will start, in which you want to mark the required PDF file, and click on the "Open" button.

Then, the online service converts the document, and in a new window offers to the standard browser tool file in Excel format.

After downloading, it will be available for processing in the Microsoft Excel program.

So, we reviewed the three main ways to convert PDF files to Microsoft Excel. It should be noted that none of the described options ensures that the data will be fully correctly displayed. In most cases, it is still being edited by the new file in the Microsoft Excel program, so that the data is correctly displayed, and have a presentable view. However, it is still much easier than to completely interrupt data from one document to another manually.

How to translate PDF to Excel, step-by-step instructionMethods.

Probably you want to know how to make money stably on the Internet from 500 rubles a day?
Download my free book
=>>

Sometimes, documents in PDF format have to be translated into Exel. Of course, the PDF format is one of universal ways on the transmission of information in electronic form. At the same time, since this option The document is essentially a picture of the content, such files cannot be edited.

Therefore, if you need to edit the file in the PDF format, it is better to translate it to Excel. However, in this case, the question arises how to do it.

To transfer from one format to another, you can apply one of the following options:

  • Use Internet resources.
  • Install on PC third-party programs For conversion or reading documents in PDF format.

In this article, you can read more detail with the possibilities for transferring files from PDF to Excel.

Conversion to Excel using PDF file readers

Programs used to read PDF files can also be used to convert to Excel. The most popular among them is the utility " Adobe Acrobat. Reader DC. " The entire process of converting a file from PDF to Excel can be divided into two parts.

The first is to work with the utility itself, and the second is performed in Microsoft Office Excel.

So, proceed to the first step on converting a file from PDF to Excel:

  • First you need to open the PDF file via Adobe Acrobat Reader DC. If a this utility Not installed, then it will be necessary to download it from the official site.
  • After the file is open in Adobe Acrobat Reader DC, it will need to save in the form of text. To implement this, click on the "File"
  • From the opened menu, select "Save as another".
  • Next click on "Text".
  • To complete the manipulations, click on "Save". At this stage, it is recommended to independently determine where it will be saved in a new format before pressing "Save".

Closed adobe program Acrobat Reader DC and get to the next step - working with Microsoft Office Excel. Only before this will need to open the resulting text file Using notepad and select all the necessary data to translate into the format.

To do this, it is best to use the "Ctrl + English British Letter A" key. To copy text to clipboard, clamp at the same time "Ctrl + English letter C" simultaneously. After that, open Excel and use the "Ctrl + V" keys to insert the text to the first cell.

Formatting

Now you can proceed to the main job:

  • After transferring the text to Excel, click on the first cell and open the "Data" section. It is located on the top line of the tool panel. In it, you need to click on "text on columns". Do not forget that one of the columns with the text must be fully allocated.
  • Further, you will open a new system window. In it choose "with separators" and click on "Next".
  • As a separator, choose the "Space" item or any other option that is required in accordance with your document and again click on "Next".
  • As for the column format, it is better to leave it shared.
  • Next, click "Finish".

All this will have to do with each column separately and fix the table manually. If in the "Column Data Format" section you need to select the "Text" item, then in the "Place B" line specify any column from the sheet.

To do this, it is enough to click on any cell from the sheet and its address will immediately affect this field. If you still doubt, then you can see the address of the cell in the white string, which is located on the right side of the sheet under the tools from the clipboard section.

Third-party utilities

If you are interested in how to translate PDF to Excel, then for these purposes one can consider another option that will be much easier than the previous one. In this case, you can download and install on your PC special utilitywhich automatically convert from one format to another.

However, it is worth noting that most of these utilities are provided only on a paid basis. But there are free pretty good options.

Considering programs for converting PDF files to Excel, you can select the following:

  • ABBYY PDF TRANSFORMER +.
  • PDFexcelConverter.
  • Totalpdfconverter.
  • SmallPDF, etc.

In essence, at least, the programs and different, however, in any case, to work with them, first need to download them on the official website, install them on the PC. Next, you first open the file to the Utility to be converted from PDF in the utility and run the process of transferring it to Excel. Keep in mind that some programs only carry out the translation of the format from one to another, which does not at all mean the creation of the tables. Therefore, after everything is performed, it is likely that some manipulations in Microsoft Office Excel will be needed to make this type and design. Also, part of the utility provides only a few free conversion, after which the program will have to either delete or buy a paid version.

Internet resources

Using Internet resources to translate files from PDF format to Excel is another fairly simple and convenient option. In this case, it is not necessary to download and install anything on your PC. It is enough just to enter the Internet through the browser and find a special resource specifically designed for this. And there are quite a lot of them.

The most popular resources for the conversion of files from PDF to Excel are:

  • PDF.io.
  • Smallpdf.com.
  • Cleverpdf.com and others.

To transfer a file format from one to another, first go to the resource providing these services. Then add the desired file. On the site and expect to convene it. As soon as everything is over, you can download the EXEL document.

RESULTS

Asking how to translate PDF to Excel, as you can see, there are several ways to allow them to be resolved. The only problem is that in most cases, after transferring a document from PDF to Excel, it is necessary to edit it in order to put everything in order and give this appropriate appearance.

Articles on the topic:

P.S. I apply the screenshot of my earnings in partner programs. Moreover, I remind you that everyone can earn, even newcomer! The main thing is to do it right, and therefore learn from those who already earn, that is, in the Internet business professionals.


Take a list of proven, especially current, 2018 affiliate programs that pay money!


Download Checklist and valuable bonuses for free
=>> "The best partners of 2018"

PDF is the most popular format for electronic document management. Initially, it was created for the American state. structures, but gradually won popularity worldwide.

PDF files are created by converting files of other applications (Word, Excel, pictures), and fonts are fully saved and appearance source document. But, unfortunately, its properties are lost. For example, Excel table converted to PDF can no longer use formulas and read data in cells.

In order to be able to work with the data, you will have to convert back PDF to Excel.

Make it possible with special programs or services.

PDF Converter in Excel

One of these services that allows you to convert PDF to Excel is PDFBurger.com.

Despite the fact that the service in English is easy to use it, since all the menus are simple and intuitively understandable. In addition to transformation into the format spreadsheetsThe service can convert PDF to Word or image files as well as, inverse transformations.

Let's now see step by step on the conversion process.

First you need to go to the https://pdfburger.com/pdf-to-excel page, watch a video lesson - how to do everything (if the video instruction is uncomfortable for you, below I made a text description):

Instructions in text format

On the site, click the "PDF to Excel" button.

This page has a "+ Select Files ..." button, it serves to select the source file that we will translate. I gave me one transformation for free, and then asked to buy a paid account.

So, we choose the file you need to convert on our computer. After that, a window appears inviting to start the conversion process.

In this window, we click the "Start" button and, after some time, we have a sign with the results of the service. The first column reflects the name and extension received file. In the second, its size. In the third, date and time of conversion.

In the fourth we see the button for downloading the received excel file. on computer. Click it and get what we needed. The last column makes it possible to remove the results if you do not need them.

As I said above, the service is paid, but you can smear. Once it gives the PDF transformation in Excel online for free. Binding is carried out to the browser. And if you need to use it a couple of times, then simply open in another browser or clean the cache and cookies.

Unfortunately, payment is taken not for the number of transformations, but for a certain time, therefore, it can only cause special interest in those who need regular actions of this kind.

Useful articles:


  • How to create a site for free - step-by-step ...

  • How to make money online newcomer from scratch - ...

  • How to make a hyperlink in VK, Word, presentations ...

PDF format is mainly used to protect documents from change. Also, PDF format files are open almost on all devices and operating systems.

So, sometimes it is necessary in the reverse process - copy data from the PDF file and paste them to Excel for further correction. With apparent simplicity, you will not work out, that is, the table is transferred, but all the data will be in one column:

Immediately make a reservation, we are not talking about printed documents, which were then scanned in PDF format. Within the framework of this article, PDF files that were created directly from Excel () are considered.

How to copy a table from PDF to Excel

We will not consider here a variant of converting copied data into a normal table with the help of formulas, it is too long and vigorously.

The easiest and fastest way to copy the table from PDF to Excel is to use Word as an intermediate link. Word, unlike Excel, correctly explicit the insertion of data copied from the PDF file. After you inserted a table in Word, copy it again and insert already in Excel. The table will be inserted correctly.

You can, as an option, use an online converter, for example, smallpdf.com. We have already written about it in the article. This method is perfect for one-time conversion - only two files can be converted per hour. And, of course, you should not use online services to convert confidential documents.

If you have any questions -, or write in the comments on this page, we are always glad to help you!

Similar articles