In Microsoft Office Excel, users can work with spreadsheets. They are a grid of cells that contain information. In addition to being able to fill an Excel workbook, you can perform various mathematical operations, create visual charts, 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 consider various options for converting files
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;
- For another user - information should be provided in a simpler form, and the file should not be editable.
In addition, documents in PDF format 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's capabilities - this feature first appeared in the 2010 version.
There are also situations where the 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 downloaded a file whose author wanted to make reading easier 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.
Excel table structure is quite complex. Editable cells contain not only common information, but also formulas, xrefs, and graphics. This factor complicates the circulation of documents in the program.
In order to increase the likelihood that another user will be able to open and read the document, you can translate it into PDF. It is also convenient when you need to hide from outsiders the formulas by which certain indicators were calculated in the cells of the book. Before sending a file by mail or making it public, convert to PDF in one of the following ways:
- Using built-in Excel functions;
- Via an official add-on from Microsoft;
- Using online services;
- In the downloaded program.
The PDF document that you receive in any of the ways will have a coherent structure. It can be opened on any device, including mobile, and also 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 for third-party services - online or downloadable. Everything is done in Excel:
- Select the table cells that you want to convert to PDF, or go to the next steps if you want to convert the entire sheet (note that the document can be returned back - this is not so easy, but the whole structure will be preserved);
- Click on "File";
- Select "Export";
- In Excel 2010, click "Save As", in newer versions, specify the location and title first;
- Select PDF from the list of formats;
- In order to customize the future document, click "Options" - you can set the range of pages to be converted, select only specific cells, the active sheet or the entire book;
- Choose an optimization method - "Standard" is suitable for small files, while for large files you will have to change the parameters;
- Name the file and save it - it will open immediately by default;
- If the document does not open, your computer may not support PDF reading - install a suitable program and check if everything loaded correctly;
- If you need to make changes, make them in the Excel source document, and then convert it again.
When saving, you can set additional parameters
How to convert Excel to PDF using the official editor add-in
This method is suitable for those cases when Excel does not allow converting, since the installed version does not have such an option. You can get around this limitation by installing a special add-on (plugin) 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:
- After installing the plug-in, the "Create PDF / XPS" field will appear in the "Save" section in the main menu of Excel - select the PDF format and name the document;
- Save this file to the desired directory on your computer.
In order to make it more convenient to work with the function, use the possibilities for selecting cells or saving a whole page or sheet, which are described in the previous method.
Depending on the version of the 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:
- Upload the document to the service system;
- Select the format into which the document will be translated, if several are available;
- Start conversion;
- Download the PDF file to your computer.
All services have similar functionality, but it is recommended to choose verified ones so that viruses do not get on the computer. However, the method is not recommended if it is possible to convert directly to Excel. It is more difficult and takes longer, and some services provide limited options or ask you to pay for the conversion.
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 Excel's functionality. This is necessary in cases where the version of the editor does not allow you to do the process in it. Programs work on the principle of a virtual printer - they take your file "for printing", but instead of issuing a paper document, they save it to another directory. However, during the process, you can change the format, including from XLS to PDF.
One of the best conversion programs outside of Excel is Universal Document Converter. It adds several hotkey functions to the editor's main menu to make it easier to save a file in a different format. After installing Universal Converter, you can convert Excel document to PDF in a couple of clicks:
- Go to the Converter toolbar:
- Select "Convert to PDF";
- 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 perform conversion using built-in functions.
Universal Document Converter is built into the program
How to fit an entire Excel sheet on one PDF page
If you need to make one sheet of the Excel book occupy one page in PDF and at the same time display correctly:
- Open the "Page Layout" in Excel, click on the arrow that opens additional options (the icon in the lower right corner of the "Page Settings" area);
- Activate the item "Place on no more than" and specify the number of pages equal to one;
- Click "OK", print the file to PDF using Excel functions, additional plug-in or Universal Document Converter.
It is very easy to fit a document to the paper size
How to convert Excel files to PDF in bulk
If you regularly create a large number of XLS documents that need to be translated to PDF, this can be done using the automatic function. It will do the job faster, and you don't have to do everything manually.
This feature is available in the Universal Document Converter. To activate it, you need to make the settings:
- When saving a document, select the program among the printers;
- Click "Change settings";
- Specify PDF format in the parameters of the final document;
- To start batch conversion, click "Start";
- The current and subsequent documents will be saved in the desired form - this can be canceled in the same settings.
You can also use the downloadable Folder Mill software, which is capable of handling a wide variety of file formats from external sources. It was created in order to simplify the work of company employees who had to convert everything manually. Use Folder Mill - in the settings, specify that the files are converted to PDF, after which the automatic conversion will begin.
The application is relevant for a large number of converted documents
How to protect the resulting PDF file with a password
Access protection without the appropriate code is needed in order to prevent the file from being read by third parties. The easiest way to do this is to also use Universal Document Converter. To activate protection you need:
- Open the required document in XLS format in Excel;
- Click "Print", select Universal Converter as a printer and select "Properties";
- Configure the function so that the output document is in PDF - this is done in "File Format";
- In the "PDF Standart" area, select the "Password protection" item and enter the secret code;
- If later you need to add pages to the password-protected document, do not change the secret code itself (if the file did not initially have protection, do not install it on new pages);
- Click "OK", print the Excel document as PDF using the Converter.
How to convert PDF to Excel
The opposite situations, when you need to convert PDF to Excel, happen if you were sent a file, the author of which did not take into account that you want to edit. In addition, PDFs are often the only available format when downloading various company pricing tables. They are designed to make the file available on any system, even if there is no Excel on the device.
In contrast to the initial conversion of an Excel table to a PDF, the reverse procedure is more complex. However, it can also be performed in the editor - for this you have to use one of two options:
- "Text by Column" function in Microsoft Office Excel (Acrobat Reader is also required);
- Online converter;
- Downloadable conversion program.
How to convert PDF to Excel with Text by Columns option
The popular Adobe viewer provides such an opportunity.
This method does not require downloading special programs or using online services - Acrobat Reader, which is available on almost every computer, is enough. To convert you need:
- Open PDF in Acrobat Reader;
- Save as Plain Text using "File" - "Save to Others" - "Text" (or "File" - "Save As" - "File Type" - "Text File");
- Specify a name and a directory for saving, click "Save";
- Next, open a text document and transfer the files from it to a new Excel file - paste in cell A1;
- Use the function for automatic distribution - "Data" - "Working with data" - "Text by columns";
- The "Text Wizard" window will open, where in the "Source data format" section you need to select "With delimiters", then "Next";
- Set a space as a separator character, remove the rest of the marks;
- Specify any column in "Parsing Sample", select "Text" in "Column Data Format";
- Repeat the previous steps for each column in the samples;
- Click "Finish" to complete the procedure - the data from the PDF will be sorted by columns in Excel.
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. In contrast to the reverse action, this conversion is usually easier to use the service. Typically, the procedure is as follows:
- Upload the PDF to the conversion system (for the best result, use the files that have the table structure preserved);
- Select the required format and start converting;
- When the process is complete, download the received document.
In many programs there is a limit on the amount of data or the number of files that are offered to be removed by getting paid access. Some services require you to enter a postal address in order to send a 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 only require a few clicks to start the conversion.
Sample online conversion service
How to convert PDF to Excel using downloadable program
There are a large number of converters that you can download for use. Usually the most effective ones are paid. They are worth buying if you have to work with a large number of documents. Usually the process goes something like this:
- You open the required PDF file or call the context menu for it at the location;
- Choose the conversion function, final format, name and directory;
- Converting.
Outcome
PDF documents are very popular as they can be opened on any computer. Converting XLS to PDF is needed to make it easier to run on different devices, to make it easier to read and to prevent editing and viewing the properties of table cells. The reverse transformation is needed to work with table data in the Excel interface.
Maximum file size! "
The file you selected exceeds the maximum allowed file size of 10 MB. It has not been added.
If you want to increase the limit to 20 MB, register for free. And, if you need more, you can subscribe to Hipdf Pro and get up to 50MB.
Login Registration
Maximum file size! "
The file you selected exceeds the maximum allowed file size of 20 MB. It has not been added.
If you want to increase the limit to 50 MB, please upgrade to Hipdf Pro.
((mutiExceddsTip))
The file you selected exceeds the maximum number of pages allowed. It has not been added.
If you would like to increase your limits to 100 pages, please register for free. And if you need more, you can subscribe to Hipdf Pro and get up to 2000 pages.
Login Registration
The maximum number of pages has been exceeded!
The file you selected exceeds the maximum number of allowed pages. It has not been added.
If you want to increase the limit to 2000 pages, go to the Hipdf Pro package.
((mutiExceddsTip))
Subscribe to Hipdf Pro No thanks
((file.file_name | subLengthStr (80)))
Conversion in progress% ...
This feature is only available to Hipdf Pro subscribers
Subscribe to Hipdf Pro Convert without OCR
This is a scanned PDF document, performing OCR will allow you to edit the text after conversion. The PDF file contains scanned pages, if you want to convert this PDF document to editable document for free using our powerful OCR engine, please login first.
Document language: ((ocrLanguage.join (",")))
Change the language
Portable Document Format is an electronic document format in which we get a snapshot of the content. These files are not subject to editing, but they are a universal way of transferring information. In fact, it is a graphical format. In situations where you have such a document, but you need to modify it, you should translate the PDF to Excel. There are three ways to do this.
How to Convert PDF to Excel Built-in Tools
We'll use Acrobat Reader and Office's Text by Columns feature. If you don't have Acrobat Reader, go to the official site and download.
Click on the "Free Download" button.
If you don't need MacAfee (antivirus), uncheck the middle box. Click on Install Now. 
Wait for the download and install the program. 
Open the document in the installed software and save as text. To do this, select the menu "File", "Save as Other", "Text". 
Click the "Save" button. The document will be saved as text. 
Open a text file in notepad, select everything (CTRL + A) and copy to the clipboard (CTRL + C). 
Open the program, create a new workbook and paste the text in the first cell (CTRL + V). 
Then move the pointer over cell A1 and click the Data tab. There click the "Text by Columns" button. 
Select Delimited and click Next. 
Select a space as a separator, or any other if otherwise in your document. Click "Next" again. 
It is better to leave the general format. Click Finish. 
The result is far from perfect, but the small table can be manually corrected. 
Let's try to convert the PDF file to Excel format using another Acrobat Reader command. While saving the document in a different format, choose Word or Excel Online. You will need a network connection. 
Unfortunately, while translation is possible only in Word and there is no Russian language. So you won't be able to convert PDF to Excel in this way. 
Online PDF to Excel converter
There are many services available to do this. Let's try several and compare the results.
Sodapdf
To download this service, you need to click the "Browse" button. 
After a short wait, you can download. 
As a result, we get an adequate table on two sheets.
Pdf.io
You can simply drag the file onto the service field. 
Then you can download it right away.
The result is presented on two sheets, but in the form of a table, almost identical to the table from the original. 
Convertio
Conveniently, the file can be simply dragged into the service window. 
Then we press the button "Convert". 
Converting PDF to Excel is fast. Click download to get the document. 
As you can see, all data is located in one column. It will take a lot of time to make the table look normal. 
Pdftoexcel
This service prevents you from dragging and dropping a file. You need to click the "Select file" button. 
We are looking for a file in the system and select it. Next, you need to click "Open". 
After conversion, it became possible to download. 
The result is identical. 
This way of translating from PDF to Excel is also not the most ideal one. The only relief is that you don't have to re-type everything, but you can do with copy and paste. But for large tables, this is time consuming.
We can say that most of the services quite satisfactorily coped with the task of making Excel out of PDF, but the first two are favorites.
How to translate and copy a table from PDF to Excel - programs
Most of the software for these purposes is paid. Here is a brief overview of some.
ABBYY PDF Transformer +
Download for 5990 r. can be here.
This is a licensed product fully aimed at working with documents. Among other things, the software also allows translation into various formats. It is convenient in that you can simply select the text and copy it into any program, for example, Word or Excel.
Pdfexcelconverter
This is a shareware product that must be installed on a computer. 
Click on the "+" to download the file. 
Let's start converting. 
And we receive an offer to register. In the free version, only the first page is converted. The result is also not impressive. 
Total pdf converter
Another shareware program. After installation, we can open a file in it and convert it to any format. 
How to save PDF export to Excel in it? Just specify the folder you want. 
After conversion, a file appears in the specified folder. The table is quite recognizable, but in the free version only the first page is recognized. 
Able2extract
Shareware program open for free download. The license costs $ 150. 
Conveniently, each step is accompanied by a hint. 
In the shareware version, you won't be able to do anything other than open the file.
It is impossible to write a macro for importing from PDF to Excel, since this format is more of a graphical type. Here you need to use text recognition programs. But it is quite possible to convert from .xls to it programmatically, since Office has a corresponding add-in.
In conclusion, we can note that the easiest and most reliable way to recognize text from PDF to Excel for isolated cases is to use online services. If you convert a large amount of documents, then it makes sense to buy licensed software.
Have a great day!
How to translate PDF to Excel, step by step instructions, methods.
Probably you want to know how to consistently earn on the Internet from 500 rubles a day?
Download my free book
=>>
Sometimes, documents in PDF format have to be translated into Excel. Of course, the PDF format is one of the universal ways to transfer information in electronic form. At the same time, since this version of the document is essentially based on a snapshot of content, such files cannot be edited.
Therefore, if it is necessary to edit the file in PDF format, it is better to translate it into Excel. However, in this case, the question arises as to how to do this.
To translate from one format to another, you can use one of the following options:
- Use Internet resources.
- Install third-party programs for converting or reading documents in PDF format on your PC.
In this article, you can learn more about the possibilities for translating files from PDF to Excel.
Converting to Excel using PDF readers
Programs used to read PDF files can also be used to convert to Excel. The most popular of these is the Adobe Acrobat Reader DC utility. The whole 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, let's proceed to the first step of converting a file from PDF to Excel:
- First, you need to open the PDF file through Adobe Acrobat Reader DC. If this utility is not installed, then you need to download it from the official site.
- After the file is opened in Adobe Acrobat Reader DC, it will need to be saved as text. To do this, click on "File"
- From the menu that opens, select "Save as Other".
- Then 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 the new format, before clicking on "Save".
Close Adobe Acrobat Reader DC and proceed to the next step - working with Microsoft Office Excel. Just before that, you need to open the resulting text file using notepad and select all the data necessary for translation into Excel format.
The best way to do this is to use the keyboard shortcut "Ctrl + English letter A". To copy the text to the clipboard, hold down simultaneously "Ctrl + English letter C". After that, open Excel and use the "Ctrl + V" keys to paste the text into the first cell.
Formatting
Now you can start the main work:
- 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 toolbar. In it, you need to click on "Text by Columns". Do not forget that one of the text columns must be completely selected.
- Next, a new system window will open in front of you. In it, select "With separators" and click on "Next".
- As a separator, select the "Space" item or any other option that is required in accordance with your document and click on "Next" again.
- As for the column format, it is better to keep it general.
- Then click "Finish".
All this will have to be done with each column separately and the table will have to be corrected manually. If in the "Column data format" section you need to select the "Text" item, then in the "Place in" line specify any column from the sheet.
To do this, just click on any cell from the sheet and its address will immediately be reflected in this field. If you are still in doubt, then you can see the cell address in the white line, 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 you can consider another option, which will be much simpler than the previous one. In this case, you can download and install on your PC a special utility that automatically converts from one format to another.
However, it should be noted that most of these utilities are provided on a paid basis only. But there are also pretty good free options.
Considering programs for converting PDF files to Excel, the following can be distinguished:
- ABBYY PDF Transformer +.
- Pdfexcelconverter.
- TotalPDFConverter.
- Smallpdf, etc.
In fact, although the programs are different, however, in any case, to work with them, you must first download them on the official website, install them on a PC. Next, to carry out the conversion, first open the file in the utility that you want to convert from PDF and start the process of converting it to Excel. Keep in mind that some programs only translate the format from one to another, which does not mean creating tables at all. Therefore, after everything is done, it is likely that you need to make some manipulations in Microsoft Office Excel in order to give the data the required appearance and design. Also, some of the utilities provide only a few free conversions, after which you have to either uninstall the program or purchase a paid version.
Internet resources
Using Internet resources to translate files from PDF to Excel is another fairly simple and convenient option. In this case, you do not need to download and install anything on your PC at all. It is enough just to go to the Internet through a browser and find a resource specially designed for this. And there are quite a few of them.
The most popular resources for converting PDF files to Excel are:
- PDF.io.
- Smallpdf.com.
- CleverPDF.com, etc.
To translate the file format from one to another, first go to the resource that provides these services. Then add the required file to the site and wait for its conversion. Once it's over, you can download the Excel document.
Outcomes
Asking the question of how to translate PDF to Excel, as you can see, there are several ways to resolve them. The only problem is that in most cases, after translating a document from PDF to Excel, you need to edit it to put everything in order and give the data the proper look.
Related articles:
P.S. I am attaching a screenshot of my earnings in affiliate programs. Moreover, I remind you that everyone, even a beginner, can make money this way! The main thing is to do it correctly, which means to learn from those who are already earning money, that is, from the professionals of the Internet business.
Pick up a list of verified, especially relevant, Affiliate Programs 2018 that pay money!
Download the checklist and valuable bonuses for free
=>>
