Convert from pdf to excel. The maximum number of pages has been exceeded! Converting with PDF Reader Applications

Designed to store electronic documentation. Files saved in this format can be opened on any computer, regardless of the installed operating system. But to edit the data, you need to export the entire pdf document or part of it to Excel. After working with data, the inverse problem arises - Excel conversion in PDF.

There are many converters that allow you to convert pdf files to (), while maintaining the structure of the original document. Working with converters usually does not cause difficulties even for an unprepared user. The export is done in three steps. Required:

1. Specify the path to the selected document for the converter.
2. Set up text processing functions, images, tables.
3. Select the final format.

The converter will do the rest automatically.

Converting with Adobe Acrobat XI

Launch the application and open the selected document in it. On the "Tools" tab, select the "Edit Content" menu and select "Export File". From the proposed options, select the line "Export file to workbook Microsoft Excel».

In the dialog box that opens, specify the file name and folder to save it. Below is the "Settings" button, by clicking on which you can set Extra options export. By default, all data will be placed on one sheet. If necessary, check the box "Create separate sheet for each page.

If you only need to export certain parts source, copy the data of interest and paste it directly into an Excel workbook, this will save a lot of time.

Solid Converter PDF

The Excel converter offers three export options:

1. "Authentic" - saves pages, restores text formatting and graphic elements.
2. "Consecutive" - ​​determines the location of the text, and .
3. "Realistic" - applies Word function"Inscriptions" for accurate reproduction of the source.

If you select either the True or Consistent mode, activate the "Define Tables" option to display them correctly after export.

To export to .xls, open the converter and select "Open PDF" from the "File" menu. Click on the "Extract Tables to Excel File" feature. Set the converter options.

The document will be converted and opened automatically. The converter can also be used for reverse operation — Excel conversions in PDF.

Online services for PDF conversion

The main disadvantage of the considered programs is their high price. To convert PDF to .xls format for free, you can use one of the online services, such as Nitro Cloud or FreePDFConvert.

Upload the file to the converter site and enter the address of your Email. The export will start, which, depending on the amount of data and the selected service, can take up to 30 minutes. The result will be sent to the specified address.

Download the resulting document and open it in Excel. In some cases, tables will have to be edited manually, as their format may be violated during export. Using the services of an online converter, after processing the data, you can convert Excel to PDF again.

Almost all online converters have limits on the number of free exports. If you plan to use the service often, it is better to register on the selected site and subscribe to its paid services.

PDF is the most popular format for electronic document management. Initially, it was created for the US government. structures, but gradually gained popularity around the world.

PDF files are created by converting files from other applications (word, excel, pictures), while fonts and appearance original document. But, unfortunately, its properties are lost. For instance, 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.

You can do this with special programs or services.

PDF to Excel Converter

One such service that allows you to convert PDF to Excel is pdfburger.com.

Although the service is English language, it is easy to use as all menus are simple and intuitive. In addition to converting to spreadsheet format, the service can convert pdf to word files or images, as well as perform inverse transformations.

Let's now take a look at the conversion process step by step.

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

Instructions in text format

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

On this page there is a button "+ Select files ...", it serves to select source file which we will be translating. The service gave me one conversion for free, and then it will ask me to purchase a paid account.

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

In this window, press the "Start" button and, after a while, we have a table with the results of the service. The first column displays the name and extension of the received file. Secondly, its size. Third, the date and time of the conversion.

In the fourth, we see a button for downloading the resulting excel file to a computer. We press it and we get what we needed. The last column gives you the option to delete the results if you don't need them.

As I said above, the service is paid, but you can cheat. One time he gives commit pdf conversion v excel online is free. The binding is carried out to the browser. And, if you need to use it a couple of times, then just open it in another browser or clear your cache and cookies.

Unfortunately, they charge not for the number of conversions, but for certain time therefore, it can be of particular interest only to those who need regular actions of this kind.

Useful articles:

• How to create a website yourself for free - step by step ...
• 
  
  
• 
  
  How to make money on the Internet for a beginner - 23 ...
• 
  
  How to make a hyperlink in VK, Word, presentations ...

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

It should be noted right away that Microsoft Excel does not have built-in tools with which one could convert PDF to other formats. Moreover, this program won't even be able to open the PDF file.

Of the main methods by which PDF conversion in Excel, you should highlight the following options:

• conversion with special applications to convert;
• conversion with apps PDF reader;
• use of online services.

We will discuss these options below.

Converting with PDF Reader Applications

One of the most popular programs to read files in PDF format is an application. Using its tools, you can complete part of the procedure for translating PDF to Excel. Second half this process will need to be done in Microsoft program Excel.

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

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

A window will open where you need to select the file you are going to open and click on the "Open" button.

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

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

At this point, Acrobat Reader can be closed. Next, open the saved document in any text editor, for example in the standard Windows Notepad. We copy the entire text, or that part of the text that we want to paste into the Excel file.

After that, launch the Microsoft Excel program. click right click mouse on the top left cell of the sheet (A1), and in the menu that appears, select the item "Insert ...".

Next, by clicking on the first column of the inserted text, go to the "Data" tab. There, in the group of tools "Working with data" click on the button "Text in columns". It should be noted that in this case, one of the columns containing the wrapped text must be selected.

Then, the Text Wizard window opens. In it, in the section called "Source Data Format", you need to make sure that the switch is in the "delimited" position. If this is not the case, then you should change it to desired position. After that, click on the "Next" button.

In the list of separator characters, check the box next to the "space" item, and uncheck the boxes next to all other items.

In the window that opens, in the "Column data format" parameter block, you need to set the switch to the "Text" position. Opposite the inscription "Place in" specify any column of the sheet. If you do not know how to enter its address, then simply click on the button next to the data entry form.

At the same time, the Text Wizard will collapse, and you will manually need to click on the column that you are going to specify. After that, his address will appear in the box. You just have to click on the button to the right of the field.

The Text Wizard opens again. In this window, all the settings are entered, so click on the "Finish" button.

A similar operation should be done with each column that has been copied from the PDF document to excel sheet. After that, the data will be sorted. It remains only to save them in the standard way.

Converting using third-party programs

Convert PDF document to Excel with third party applications is, of 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, on the left side of it, open the directory where our file is located. In the central part of the program window, select desired document by checking the box next to it. On the toolbar, click on the "XLS" button.

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

The conversion procedure starts.

Upon its completion, a window with the corresponding message opens.

Most of the other apps work in much the same way. PDF conversion to Excel formats.

Conversion via online services

To convert via online services, you do not need to download any additional software. One of the most popular such resources is Smallpdf. This service is designed to convert PDF files to various formats.

After you have navigated to the section of the site where the conversion to Excel is performed, simply drag and drop the required PDF file from Windows Explorer into the browser window.

You can also click on the "Select File" button.

After that, a window will open in which you need 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 download standard tools browser file in Excel format.

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

So, we have covered three main ways to convert PDF files to Microsoft document Excel. It should be noted that none of the described options guarantees that the data will be displayed completely correctly. In most cases, you still have to edit the new file in Microsoft Excel so that the data is displayed correctly and has a presentable appearance. However, this is still much easier than completely transferring data from one document to another manually.

The conversion is easiest to do in a modern " Adobe Acrobat ProDC.

1. open desired file. Click on the "Tools" tab.

1. In the menu that opens, click on the "Export PDF" button.

1. Then select Spreadsheet.

1. Before converting, it is advisable to click on the “Settings” icon (looks like a gear).

1. Here you can specify where exactly to place the information:
   • create one sheet for the entire document;
   • create a sheet for each table;
   • create a sheet for each page.
2. After you choose desired item, you will need to click on the "OK" button.

1. To start the conversion, click on the "Export" button.

1. After that, you will be asked to specify the location where you want to save the future file. You can select something from the latest directories or click on the "Select another folder" button.

1. Wherever you click, the explorer will still open. After you decide, you must specify the file name. Then click on "Save".

1. Immediately after that, the initialization of the export mechanism will start. You must wait until all operations are complete.

The conversion result is pretty good, which is to be expected. After all, this is Adobe.

The only drawback is that after merging, the header occupies one cell, and not all four. But this is not critical.

Online services

On the Internet, you can use the services of online converters. It is enough to look into any search engine. Almost all of them are free. In addition, they are very easy to use. You don't need any tutorial for this. Any "teapot" will cope with this task.

Let's consider some of them. For example, this one or this one.

Please note that all sites have their own features. In addition, the result of the output file can vary greatly.

pdf.io

The home page looks simple. But in order to translate the table into desired format, this is quite enough. To convert, follow these steps:

1. First of all, click on the "Choose File" button.

1. In the window that appears, specify the desired document and click on the "Open" button.

1. Immediately after that, the download will start - wait for it to finish. The waiting time depends on the file size and the speed of your internet connection.

1. As a result, you will see the message "Done". Click on the "Download" button.

1. You will be asked to provide a folder and a desired name. You can leave it as is. After that, click on "Save".

1. Open the downloaded file. Please note that the document uses the old table format.

1. The table looks quite acceptable. But due to the old format, near the document title, we see a message that the editor is running in compatibility mode. Moreover, green triangle icons appeared near the formulas, and this is the first signal of possible errors.

If desired given file can be downloaded at Google Drive or Dropbox.

In addition, it should be noted that there is Alternative option adding a file (almost on all sites). To do this, click the left mouse button and, without releasing your finger, drag the file into the browser window.

The result will be exactly the same as using the "Browse" button.

smallpdf.com

This portal is more functional. We are offered to register in order to take advantage of additional options. Moreover, it is possible to download a program for offline conversion.

In addition, we are being pushed to buy the pro version.

Of course, we are trying to show various functions, which are not in the regular version.

We will not buy. You can redo the document for free using the site. Here the principle of operation is exactly the same.

1. Click on the "Select File" link. Next, in the window that appears, select the desired object and click on the "Open" button.

1. After that, you will see a message that the document conversion has started. It is necessary to wait.

1. After a short time, a link to download the result will appear. In addition, it is possible to upload the document to the Cloud.

1. Click on the down arrow icon. Next, you will be asked to provide a path and a name. Note that it is used here new format xlsx tables. This was not possible on the previous site. After that, click on "Save".

1. Run the downloaded spreadsheet.

1. First of all, we see that only the title is indicated on the sheet. The fact is that two sheets were created during the conversion. On the one hand, this is convenient when you have several tables. But when one is a big minus.

1. Turning to the second sheet, you will see the basic information. In this case, everything looks nice and without errors in the formulas.

Now the editing capabilities are fully available.

Third Party Applications

On the Internet you can find a large number of conversion programs. Let's consider some of them. Let's start with what we were offered on the above site.

smallpdf

1. Click on the link to download this software.

1. The browser will automatically determine from which device you accessed the site and offer to download the appropriate version of the utility. Click on the "Download for Windows" button.

1. After that, a window will appear in which you need to specify the download folder and the name of the future file. To continue, click on the "Save" button.

1. Run the downloaded distribution.

1. Right after that, you will see the following.

1. After a short wait, a welcome message will appear. To get started, click on the "Start" button.

1. You will be asked to specify a file or drag it with the mouse to working space, which is marked with a dotted line.

In a programme Microsoft office Excel users can work with spreadsheets. They are a grid of cells that contain information. In addition to being able to fill excel books, you can perform various mathematical operations, create visual diagrams, and insert other elements. The program also works with data from other sources and databases, and the user can save the result in one of several popular formats.

We are considering various options file conversion

Saving an Excel file to PDF is most often used in two cases - when a document needs to be transferred:

• To the printing house for printing;
• To another user - the information must be provided in a more simple form, and the file must not be editable.

In addition, PDF documents can be opened on any computer, even if Excel of one version or another is not installed on it. Converting a document to another format can be done in several ways. These include the use of Excel features - this feature first appeared in the 2010 version.

There are also reverse situations - when a PDF needs to be converted to an Excel file. For example, when a colleague sends you data from a recent report or project, or you download a file whose author wanted to make it easier to read or hide Excel formulas. In any case, if you need to work with the document and make changes, it will have to be converted from PDF to XLS.

The table structure in Excel is quite complex. Editable cells contain not only the usual information, but also formulas, external links and graphic elements. This factor complicates the circulation of documents in the program.

To increase the chance that another user can open and read the document, you can convert it to PDF. It is also convenient when you need to hide from third-party people the formulas by which certain indicators were calculated in the cells of the book. Before you send a file by mail or upload it to general access, convert to PDF in one of the following ways:

1. Using built-in functions in Excel;
2. Through the official add-on from Microsoft;
3. Using online services;
4. in the downloaded program.

The PDF document that you receive by any of the methods will have a coherent structure. It can be opened on any device, including mobile, and cannot be edited by the reader. Such a file does not contain links to third-party resources and calculation formulas.

How to convert Excel to PDF in the editor itself

To use this method, you do not have to search third party services- online or downloadable. Everything is done in Excel:

1. Select the table cells you want to convert to PDF, or navigate to next steps, if you want to transform the entire sheet (note that the document can be returned back - it's not so easy, but the whole structure will be preserved);
2. Click "File";
3. Select "Export";
4. In Excel 2010, click "Save As", in newer versions, first specify the location and name;
5. Select PDF from the list of formats;
6. In order to set up a future document, click "Options" - you can set the range of pages that will be converted, select only specific cells, the active sheet or the entire book;
7. Choose an optimization method - for small files, "Standard" is suitable, while for large ones you will have to change the parameters;
8. Name the file and save it - it will immediately open by default;
9. If the document does not open, your computer may not be able to read PDF - install suitable program and check if everything loaded correctly;
10. If you need to make changes, make them to the original Excel document, and then convert it again.

When saving, you can set additional options

How to convert Excel to PDF using the official editor add-on

This method is suitable for those cases when Excel does not allow you to convert, since in installed version there is no such possibility. You can get around the limitation by installing a special add-on (plug-in) called "Save as PDF and XPS". You can download the functionality from the official Microsoft website - it's free.

For the translation itself, you need:

1. After installing the plugin, the "Create PDF / XPS" field will appear in the Excel main menu in the "Save" section - select the PDF format and name the document;
2. Save this file to the correct directory on your computer.

In order to make it more convenient to work with the function, use the options for selecting cells or saving an entire page or sheet, which are described in the previous method.

Depending on the version of Office, the menu items may differ slightly.

How to Convert Excel to PDF Using Online Services

There are a large number of converters on the Internet that allow you to convert XLS to PDF in a few clicks. Most of them do it for free or offer the user a demo mode. To convert, you usually need:

1. Upload a document to the service system;
2. Select the format in which the document will be translated, if more than one is available;
3. Start conversion;
4. Download the PDF file to your computer.

All services have similar functionality, but it is recommended to choose proven ones so that viruses do not get on your computer. However, the method is not recommended if it is possible to convert directly to Excel. It's harder and longer, and some services give limited opportunities or asked to pay for the transformation.

One of many examples of online tools

How to Convert Excel to PDF Using Third-Party Downloadable Programs

Like online services, such programs allow you to make a conversion without using the functionality of Excel. This is necessary in cases where the version of the editor does not allow the process to be done in it. Programs work on the principle virtual printer- they accept your file "for printing", but instead of issuing paper document save it to another directory. However, during the process, you can change the format, including from XLS to PDF.

One of the best programs for transformation outside Excel - Universal Converter Documents. It adds several functions in the form of hotkeys to the editor's main menu to make it easier to save a file in a different format. By installing the Universal Converter, you can convert an Excel document to PDF in a couple of clicks:

1. Go to the Converter toolbar:
2. Select "Convert to PDF";
3. Specify the name and location of the file, save.

This method, as in the case of online services, is recommended for those versions of Excel in which it is impossible to convert using built-in functions.

Universal Document Converter is built into the program

How to place an entire Excel sheet on one PDF page

If you need to make one sheet of an Excel workbook occupy one page in PDF and at the same time display correctly:

1. Open "Page Layout" in Excel, click on the arrow that opens additional options(icon in the lower right corner of the "Page Setup" area);
2. Activate the item "Place no more than on" and specify the number of pages equal to one;
3. Click "OK", print the file to PDF using Excel's functions, an additional plugin, or the Universal Document Converter.

It is very easy to fit a document to a sheet format

How to Bulk Convert Excel Files to PDF

If you regularly create a large number of XLS documents that need to be converted to PDF, this can be done using the automatic function . It will do the job faster, and you will not have to do all the steps manually.

This feature is available in the Universal Document Converter. To activate it, you need to make settings:

1. When saving a document, select a program among printers;
2. Click "Change settings";
3. In the parameters of the final document, specify the PDF format;
4. To start batch conversion press "Start";
5. The current and subsequent documents will be retained in desired form- it can be canceled in the same settings.

You can also use the download Folder program Mill, which is able to work with large quantity files various formats coming from external sources. It was created in order to simplify the work of employees of companies who had to convert everything manually. Use Folder Mill - in the settings, specify that files are converted to PDF, after which automatic conversion will begin.

The application is relevant for a large number of convertible documents

How to Password Protect a Received PDF File

Protection against access without the appropriate code is needed in order to prevent third parties from reading the file. The easiest way to do this is also to use the Universal Document Converter. To activate protection you need:

1. Open the required document in XLS format in Excel;
2. Click "Print", select Universal Converter as a printer and select "Properties";
3. Set the function so that the output document is in PDF - this is done in "File Format";
4. In the "PDF Standard" area, select "Password Protect" and enter secret code;
5. If later you need to add pages to the password-protected document, do not change the secret code itself (if the file was not originally protected, do not install it on new pages);
6. Click "OK", print the Excel document as a PDF using the Converter.

How to translate PDF to Excel

The reverse situation, when you need to convert PDF to Excel, happens if you were sent a file whose author did not take into account that you would like to edit. In addition, PDF documents are often the only accessible format when downloading various tables with prices of companies. They are designed to ensure that the file will be available on any system, even if the device does not have Excel.

Unlike the primary conversion of an Excel table to PDF document, the reverse procedure is more complicated. However, it can also be done in the editor - for this you will have to use one of two options:

1. Text by Columns feature in Microsoft Office Excel (you will also need Acrobat Reader)
2. Online converter;
3. Downloadable conversion software.

How to translate PDF to Excel with "Text by Columns" option

The popular viewer from Adobe provides such an opportunity.

This method does not require downloading special programs or using online services - Acrobat Reader is enough, which is available on almost every computer. To convert you need:

1. Open PDF in Acrobat Reader;
2. Save as plain text using "File" - "Save to others" - "Text" (or "File" - "Save as" - "File type" - "Text file");
3. Specify a name and directory for saving, click "Save";
4. Next, open Text Document and transfer files from it to new file Excel - paste into cell A1;
5. Use the function for automatic distribution - "Data" - "Working with data" - "Text by columns";
6. The "Text Wizard" window will open, where in the "Source Data Format" section you need to select "Delimited", then "Next";
7. Set a space as a separator character, remove the rest of the marks;
8. Specify any column in "Data Parsing Sample", select "Text" in "Column Data Format";
9. Repeat the previous steps for each column in the samples;
10. Click "Finish" to complete the procedure - the data from the PDF will be sorted in Excel by columns.

The sequence of operations consists of several stages

How to Convert PDF to Excel Using Online Services

There are many programs on the Internet for converting XLS to PDF. Unlike the reverse action, with such a conversion, it is usually easier to use the service. The procedure usually goes like this:

1. Upload the PDF to the conversion system (in order to get best result, use files that preserve the table structure);
2. Select the required format and start converting;
3. When the process is complete, upload the resulting document.

Many programs have a limit on the amount of data or the number of files that they offer to remove after receiving paywall. Some services require you to enter mailing address to send the file to it. Most likely, you will have to bring the table to the desired look, since services rarely cope with formatting - especially complex documents. However, they do the bulk of the work and require just a few clicks to start the conversion.

An example of an online conversion service

How to convert PDF to Excel with a downloadable program

There are a large number of converters that can be downloaded for use. Usually the most effective - paid. They are worth buying if you have to work with a large number of documents. The process usually goes something like this:

1. You open the required PDF file or call for it context menu by location;
2. Choose the conversion function, final format, name and directory;
3. Perform the conversion.

Outcome

PDF documents are very popular because they can be opened on any computer. XLS to PDF conversion is needed in order to make it easier to run on different devices, make it easier to read, and prohibit editing and viewing table cell properties. Reverse transformation needed to work with table data in the Excel interface.