Power Spreadsheets

Excel and VBA tutorials and training. Learn how to use Microsoft Excel and Visual Basic for Applications now.

Convert PDF To Excel: 3 Easy Methods You Can Use Right Now

[If you're looking for a step-by-step explanation of how to extract data PDF to Excel using VBA, please refer to this post . In there, I explain how you can use VBA to implement the 3 PDF to Excel conversion methods I discuss below, and provide macro code examples.]

Excel Tutorial about how to convert PDF to Excel

Most recent versions of Microsoft Office have several features that allow you to, among others, import data into Excel from the following sources:

  • The most common text file formats, such as comma-separated values (.csv) and text (.txt) files.
  • A Microsoft Access database.

In some of these cases, the tools you require to do the job are readily available in Excel's Get External Data group of commands within the Data tab.

Commands to get external data in Excel

However, the Get External Data group of commands isn't the topic of this blog post.

When the particular file format you're using isn't supported by Excel, importing data may be slightly more complicated.

As a general matter, I have no problems with these limitations. You probably won't encounter such problems very frequently as long as you don't work with obscure file formats that aren't supported by Excel. There is, however, one big exception to this rule.

This is a particular file format whose data is not that easy to bring into Excel despite being very popular and widely used:

Portable Document Format (.pdf) files are one of the most widely used file formats for electronic documents . You probably encounter PDF files at work (almost) every day . In some of those cases, you may need to analyze the data within a particular PDF file with Excel.

If you're in such a situation, you may ask:

How can you convert a PDF file into an Excel worksheet?

You may have also noticed that successfully converting a PDF file into an Excel worksheet is hard . Doing this requires knowledge of both Excel and PDF.

At the same time, the ability to accurately and quickly convert PDF files to Excel is very valuable .

My purpose with this blog post is to help you easily convert PDF files to Excel worksheets . Among other things, I explain 3 different methods you can use to convert a PDF file to Excel and some criteria you can use to determine which method to use . The methods are organized from the simplest (which also returns the less precise results) to the most advanced (usually providing the most accurate conversions).

You can use the following table of contents to navigate to the relevant section where I explain the method that you're interested in.

Table of Contents

If you're interested in the opposite process (converting Excel files to PDF), I provide a thorough explanation of the topic plus 10 examples of VBA code in this blog post .

Before I explain each of the methods that you can use to convert a PDF file to Excel, let's start by taking a look at:

What Are PDF Files

The acronym PDF stands for Portable Document Format.

In very broad terms the PDF format is a digital format that you can use to represent electronic documents . One of the main appeals of the PDF file format is that the document representation is independent of any of the following:

  • Operating System.

The reason for this is that the PDF file itself carries the complete description of the document layout and all the information that is necessary to correctly display the electronic document. Therefore, PDF documents allow you (and other users) to:

  • Exchange/Share/View documents;
  • In an easy/reliable/accurate way;
  • Independent of the environment/software/hardware used to create/view/print the document;
  • While preserving the content/formatting/appearance of the document.

In other words: When you use the PDF format to represent a document, the formatting is preserved regardless of the software, hardware or operating system used when the file is opened later.

A further advantage of the PDF file format is that PDF files are compact . PDF reduces file sizes by using:

  • Compression algorithms; and
  • A specific file structure.

Considering the above, it isn't that difficult to see why the PDF file format is so widely used. Among other advantages, the PDF format:

  • Retains the intended document formatting; and
  • Enables sharing.

This explains why my cheat sheet with keyboard shortcuts for Excel (which you can get here ) is saved (and shared) as a PDF file. The PDF format enables me to set (i) a particular formatting for the document, and (ii) share it with you. Later, once you open the document, you'll see the list of keyboard shortcuts in the format that I originally intended.

Microsoft (in the webpage I link to above) does mention an additional important characteristic of PDF files that, in the end, is what gives rise to the topic of this blog post:

Data within a PDF file can't be easily changed .

Depending on your perspective, you may consider this to be an advantage or a disadvantage. More precisely:

  • If your main purpose is to prevent (or at least make difficult) the modification of a particular document, you may be happy that the data within a PDF file can't be easily changed.
  • If you need to work with, and manipulate, the data within a PDF file, you're probably annoyed by how difficult is it to edit a PDF document.

Most Excel users, you and me included, found ourselves in the second camp most of the time. We need to work with the data within the PDF file. Therefore, we usually want to have the ability to convert a PDF file to Excel.

I assume that you also want to have the ability to convert PDF files to Excel, so let's take a look at some of the most popular methods to bring data from PDF files into Excel :

Method #1 To Convert PDF Files To Excel: Copy And Paste

The most basic method of bringing data from a PDF file into Excel is to simply copy and paste .

Since some (not all) PDF files allow you to copy data , there are cases where you may be able to bring all the data you require into Excel by using the basic commands of copy and paste .

Let's take a look at a practical example of how you can copy and paste data from certain PDF files into Excel:

The following screenshot shows a table within a pdf document. More precisely, you can find this table in page 22 of the Working Paper from the European Central Bank titled Inflation forecasts: Are market-based and survey-based measures informative? by Magdalena Grothe and Aidan Meyler.

PDF table to convert to Excel

Throughout this blog post, I show the results obtained when applying each of the different methods to convert this table from PDF to Excel. This Convert PDF to Excel Tutorial is accompanied by an Excel workbook containing these results. You can get immediate free access to this example workbook by subscribing to the Power Spreadsheets Newsletter .

Step #1: Select And Copy The Data

The first step to copy data from a PDF file is to, simply, select the relevant data and copy it . You can generally use the “Ctrl + C” keyboard shortcut for purposes of copying data.

PDF data to copy to Excel

Step #2: Paste The Data Into Excel

Once you've copied the relevant data from the PDF file, and this is available on the Clipboard, you need to go to Excel and paste it.

Even though this sounds easy, in practice it doesn't work that smoothly. In fact, this step highlights some of the main limitations of this method of converting PDF files to Excel.

You may want to consider:

  • Using the Paste Special command; and
  • Trying some of the different options that appear .

You can access the Paste Special dialog box by:

  • #1: Clicking on the drop-down section of the Paste split button in the Home tab of the Ribbon ; and
  • #2: Selecting “Paste Special…”.

You can also open the Paste Special dialog box by using the keyboard shortcut “Ctrl + Alt + V”.

In the Paste Special dialog box, you can choose from several options . The following image shows how the Paste Special dialog box looks like when I paste the data from the PDF table that appears above:

Paste Special dialog in Excel for PDF data

For this example, I select the option to paste as Text and click on the OK button on the lower-right corner of the dialog box.

Paste text in Excel from PDF

The following screenshot shows the pasted data in the Excel worksheet:

Example of data pasted in Excel from PDF

In most cases this isn't precisely the result you want . However, you'll rarely be able to get better results when using this method.

As a general rule: Directly copying and pasting from PDF to Excel (usually) results in a single column of data .

This is precisely what happens in the example above. And you can generally expect this to happen whenever following this method .

As a consequence of the above, you'll usually need to complete the process with the following…

Step #3: Cleanup The Data

Even though pasted data in Excel generally requires some cleanup, you have a variety of tools you can use to make the cleanup easier, faster and more precise.

Since this blog post isn't about data cleanup, I don't go into any specific methods. However, some of the tools and features that you may find helpful (depending on the particular situation) are the following:

  • Text functions and formulas .
  • The Remove Duplicates command.
  • Get & Transform / Power Query .
  • The Text to Columns command.
  • Flash Fill.

I may cover some of these topics in future tutorials within Power Spreadsheets. If you want to receive an email when I publish new material in Power Spreadsheets, please make sure to register to our Newsletter by entering your email address below:

Overall, this first method of converting a PDF file to Excel leaves some things to be desired . The following are, in my opinion, its 2 biggest drawbacks:

  • Limitation #1: The method only works when you're able to copy the data from the PDF file. As you may have experienced, there are times where you are not able to copy data from a PDF file.
  • Limitation #2: Any data that you paste into Excel using this method generally unwinds into a single column and requires cleanup. In other words: You may still have to do a substantial amount of work in order to get the data from the PDF file into a form that is ready for analysis.

There are some situations in which you may not have any other option for purposes of converting a PDF file to Excel. This is the case if, for example, you don't have access to any of the tools that are required to apply the other methods that I explain below.

In any case, as long as you have access to a recent version of Microsoft Word or to Word Online, the following method may help you achieve better results when converting a PDF file to Excel .

Method #2 To Convert PDF Files To Excel: Use Microsoft Word

In order to make use of this method, you need access to one of the following :

  • One of the most recent versions of Microsoft Word (2013 or later).
  • Access to Microsoft Word online and OneDrive.

In broad terms, the logic behind converting a PDF file to Excel is the same regardless of which of the above versions of Word you use. You, basically, follow these 2 simple steps :

  • Step #1: Open the relevant PDF file using Microsoft Word.
  • Step #2: Copy the relevant content from the Microsoft Word file and paste it into Excel.

However, let's take a more detailed look at each of these methods to convert a PDF File to Excel using Word. In both cases, I use the same sample table as above, which you can find in page 22 of the Working Paper from the European Central Bank titled Inflation forecasts: Are market-based and survey-based measures informative? .

Convert PDF File To Excel Using A Recent Version Of Microsoft Word

Let's start by taking a look at how you can use a recent version of Microsoft Word to convert a PDF file to Excel:

Step #1: Open The PDF File

You can open the PDF file you want to convert using any of several methods , including the following 2:

How to open PDF file with Word

After you've asked Word to open the file, a dialog box (such as the one below) is displayed . This dialog box informs you about the following:

  • The PDF file will be converted to an editable Word document. This is perhaps the main key for the whole process of converting a PDF file to Excel using this method.
  • The conversion may take a while. This depends on different factors, such as the size of the file you're converting and the amount of graphics within the file.
  • The resulting Word document is optimized to allow text edition. As a consequence of this, the converted Word file will likely look different from the source PDF. This is very likely, in particular, if the file you're converting has many graphics.

When Word displays this dialog box, click on the OK button.

Word message about PDF conversion

As mentioned above, the conversion may take a while, so you may have to wait a little before proceeding to the next step.

Step #2: If Necessary, Enable Editing Of The File

Depending on the source of the PDF file, Word may open it in Protected View.

PDF with Protected View in Word

To exit Protected View , follow these 2 easy steps:

Enable Editing for PDF file in Word

Step #3: Copy The Relevant Sections Of The Editable Word Document

Once you've completed step #1 and (if necessary) step #2 above, Word displays the original PDF file as an editable Word document.

Converted PDF file in Word

When you have the editable Word document, select the section that you want to take into Excel . In the example below, I select the same table as in the previous method:

Select data from PDF in Word

Once you've selected the relevant information in the editable Word document, copy it . For these purposes, you can use any of the following methods:

Right click menu to copy PDF table in Word

  • Method #3: Use a keyboard shortcut such as “Ctrl + C”.

Step #4: Paste In Excel

By now, you have the information you need in an editable format. Therefore, you can go to Excel and paste it by using, among others, any of the following methods:

  • Method #1: Press the Paste button in the Home tab of the Ribbon.
  • Method #2: Use the “Ctrl + V” keyboard shortcut.

In the example above, the resulting table (once pasted in Excel) looks as follows:

Table converted from PDF in Excel

In some cases, including this example, the conversion from PDF to Excel isn't perfect .

Notice, for example, how Word hasn't been able to convert the values in the first section of the table (Mean error) to an editable form. In this case, those values are pasted as an image. Therefore, you must use another method (including those described in this Excel tutorial) to bring them into Excel before being able to work with them.

Excel table with image from PDF file

You won't encounter these shortcomings always. In some cases, this method works just fine.

However, the feature Word uses to convert PDF files to Word documents (called PDF Reflow):

  • Works best with simple files that contain (mostly) text.
  • Doesn't handle more complex elements (for ex., tables with cell spacing) very well .

If you encounter problems while using Word to convert a PDF file to Excel, you can always try one of the other methods I describe in this blog post.

Convert PDF File To Excel Using Microsoft Word Online

Even though the process for converting a PDF file to Excel using Word Online is substantially similar to that I followed when using the desktop version of Word, there are a few small differences. Let's take a look at the 5 easy steps you can use to convert a PDF file to Excel using Word Online.

Step #1: Upload The PDF File To OneDrive

Go to OneDrive and upload the PDF file you want to convert to Excel using either of the following methods:

OneDrive online to upload PDF file

Step #2: Open The PDF File Using Word Online

To open the PDF file using Word online, go to the OneDrive window in your browser, right click on the file and select “Open in Word Online” from the contextual menu.

How to open PDF with Word online

Step #3: Make The PDF File Editable

Once Word online has opened the PDF file, convert it into an editable document by clicking on the Edit in Word button in the upper part of the screen.

How to set a PDF file to Edit in Word Online

Word online displays a dialog box informing you that it will make a copy of the PDF file and convert it into an editable Word document. Confirm by clicking on the Convert button on the lower part of the dialog box.

Convert PDF file to Word Online

Once Word online has finished the conversion, it displays another dialog box informing you changes in the layout of the PDF file may have occurred. Click on the Edit button on the lower right corner of the dialog box.

Edit PDF File button for conversion in Word Online

Step #4: Copy The Section Of The Document You Want To Take To Excel

Once Word online has converted the PDF file to an editable document, the screen looks roughly as follows. The actual document will (most likely) be different in your case.

Converted PDF file in Word Online

Go to the section of the editable document that you want to bring into Excel, and select it . In the screenshot shown below, I select the same table I use for the previous examples within this Excel tutorial:

Table from PDF file in Word online

Once you've selected what you want, copy it by using the keyboard shortcut “Ctrl + C”.

If you have problems when trying to copy from Word online, you can use the desktop version of Microsoft Word in your computer to continue with the process . To do this, click on the Open In Word button that appears to the right of the Ribbon tabs.

Open PDF file from Word Online with Word

If you choose to open the editable file in Microsoft Word, the desktop version of Word is launched. You can then follow the steps I describe in the previous section to copy the relevant data.

Step #5: Paste The Data In Excel

Once you've copied the data, go back to Excel and paste it by using (among others) one of the following methods:

Paste button for PDF file data

The following screenshot shows the resulting table in Excel (after I've adjusted the column width):

Converted PDF data in Excel

Not surprisingly, the results are almost identical as those obtained by opening the PDF file with a recent version of Microsoft Word (explained above).

Just as when opening the PDF file with Microsoft Word, you'll notice that the results aren't always perfect (although in some cases they will be). In the case of the example displayed above, for example, all the Mean errors (first section of the table) are pasted as an image.

Image from PDF file in Excel

In order to be able to manipulate those values in Excel, you'll need to bring them using another method (such as the other ones explained in this blog post) or type them directly in Excel.

Method #3 To Convert PDF Files To Excel: Use A PDF Converter

If you have to constantly convert PDF files to Excel or want to avoid the shortcomings of the other 2 methods described above, it may be a good idea to use a PDF converter.

There are several PDF converters in the market. I use Able2Extract .

Even if you don't end up using Able2Extract, you may want to steer clear of online PDF conversion services when converting sensitive or confidential PDF files. In addition to potential privacy/confidentiality concerns, the results obtained with online converters aren't always satisfactory.

As a consequence of the above, I show you how to convert a PDF file to Excel using Able2Extract . As when explaining the other methods above, I use the table within the European Central Bank Working Paper titled Inflation forecasts: Are market-based and survey-based measures informative? as an example.

Let's take a look at how you can convert a PDF to Excel in 6 easy steps when using Able2Extract:

Step #1: Display The Open Dialog Box

In order to get Able2Extract to display the Open dialog box, click on the Open button on the top left corner of the screen or use the “Ctrl + O” keyboard shortcut .

Open button to convert PDF file

Step #2: Open The File You Want To Convert

Once Able2Extract displays the Open dialog box, use it to browse to the folder where the file you want to convert is located.

Once you've located the PDF file to be converted, select it and click the Open button on the lower right corner of the Open dialog box.

Open PDF file to convert

Step #3: Select The Data You Want To Convert

Able2Extract opens the PDF file you want to convert. It also explains how you can select the data you want to convert.

PDF file within converter program

As explained by Able2Extract, you can select data using any of the following methods :

Method #1 To Select Data With Able2Extract

Click on the Select All icon on the toolbar.

Select All button for PDF file in converter

Method #2 To Select Data With Able2Extract

Go to the Edit menu and select any of the following options or use the appropriate keyboard shortcut:

Edit menu to select PDF data

Let's take a look at each of these options separately:

Option #1: Select Page Range…

Option to select page range of PDF file

Select Page Range (keyboard shortcut “Ctrl + R”) allows you to select a particular range of pages , without actually selecting all of the content of the PDF file.

Able2Extract displays the Select Page Range dialog box after you've clicked on “Select Page Range…” in the Edit menu or used the “Ctrl + R” keyboard shortcut.

You determine the pages to be converter by typing the relevant range and clicking on the OK button on the lower section of the Select Page Range dialog box. For example, to convert pages 21 and 22, you'd enter “21-22” and click “OK”.

Dialog to select page range in PDF converter

Option #2: Select All Pages.

Option to select all pages in PDF converter

The Select All Pages option (keyboard shortcut “Ctrl + A”) allows you to select all of the pages of the PDF document.

Option #3: Select All on Page.

Option to select all on page with PDF converter

Select All on Page (keyboard shortcut “Ctrl + B”) selects all the data in the current page of the PDF file.

Option #4: Select Area.

Option to select area in PDF converter

The option to Select Area (keyboard shortcut “Ctrl + *”) allows you to use the mouse to select a particular section of the PDF file to convert.

For example, I can use this option to select the table in page 22 of the European Central Bank Working Paper that I use as an example throughout this blog post.

Example of selection in PDF document to convert

Method #3 To Select Data With Able2Extract

The third way of selecting data with Able2Extract is very similar to using the Select Area option in the Edit menu. Simply use the mouse to select the portion of the PDF document that you want to convert.

Selection of data in PDF file with converter

Step #4: Select Excel As Output File Type

Once you have selected the data you want to convert from PDF to Excel using any of the methods explained above, click on the Excel button on the toolbar or use the keyboard shortcut “Ctrl + E” to select Excel as the output file type for the conversion.

Button to convert PDF to Excel

Step #5: Click On Convert

Once you've clicked on the Excel button of the toolbar, Able2Extract provides you 2 options regarding the way in which you want the conversion to occur:

  • This is the default option, and is also the recommended choice for most PDF to Excel conversions. If you choose this option, Able2Extract determines the positioning of the columns automatically.
  • To choose Automatic conversion, click on the Convert button that appears on the lower left section of the Convert to Excel dialog box.

Automatic PDF conversion to Excel button

  • In the special cases where the Automatic conversion doesn't work properly (for example, the resulting Excel table isn't properly aligned), you can use the Custom conversion option to specify the column structure. This allows you to designate the column structure before Able2Extract carries out the actual conversion into Excel.
  • To use the Custom conversion option, click on the Define button on the lower middle section of the Convert to Excel dialog.

Option for custom PDF conversion to Excel

For this particular example, I choose Automatic conversion . I may explain how to use the Custom conversion option in a future blog post.

Step #6: Save The Excel Spreadsheet

After you click on the Convert button to use Automatic conversion, Able2Extract displays the Save As dialog box.

Use this dialog to select the location and filename of the converted Excel file, and click on the Save button on the lower right corner to confirm your choice. Notice how the Save As dialog box is saving the resulting file as an Excel Spreadsheet.

Save converted PDF file to Excel

Once you click on “Save”, Able2Extract converts the selected section(s) of the PDF file into Excel, and launches Excel.

The results I obtain when converting the sample table are shown in the screenshot below . Notice how, among others, Able2Extract was able (i) to replicate the table structure and (ii) extract all of the significant values from the source PDF document.

There's still some cleaning up work to be done. Notice, for example, how negative numbers have been extracted as text (I highlight one such value below).

Example of correct PDF conversion to Excel

These are, however, small issues that are relatively easy to fix.

For example, the negative numbers that are stored as text can easily be converted into actual numbers by using the VALUE function and, if necessary, Excel's text functions.

If you're interested in using Able2Extract to convert PDF documents to Excel files, you can download it, and get a 7-day free trial, by following the link below:

Download Able2Extract (affiliate link)

How To Convert PDF Files To Excel: Which Method To Use

In this blog post, you have seen 3 different methods to convert a PDF file to Excel :

  • Method #1: Copy and paste.
  • Method #2: Use Microsoft Word.
  • Method #3: Use a PDF converter.

You may be wondering which of the 3 methods that I explain in this blog post should you use when converting PDF files to Excel.

Each of the 3 different methods has different advantages and disadvantages .

As a general matter, the results obtained when copying and pasting data from a PDF file to Excel (method #1) are (in my opinion) not particularly good . Therefore, in most situations, you're likely to be better off using Microsoft Word (method #2) or a PDF converter (method #3) .

For purposes of choosing between Microsoft Word (method #2) and a PDF converter (method #3) for purposes of converting PDF files to Excel, I suggest you consider the specific situation you're in and, particularly :

  • If you constantly convert lengthy or complex documents from PDF to Excel, you may want to consider using a PDF converter such as Able2Extract.
  • If you find yourself constantly carrying out the process of converting a PDF file to Excel, a PDF converter (such as Able2Extract) may come in handy.

An additional factor to consider is that, as shown in the examples above, a good PDF converter (like Able2Extract) is less prone to introducing errors in your data . Some of the manual conversion methods may introduce errors in your data and you will need to carry a more thorough re-check to confirm the accuracy of the conversion.

The following rule of thumb may help you choose between Microsoft Word and a PDF converter (for your PDF file conversion needs):

  • Microsoft Word tends to work well when converting shorter, simpler documents.
  • PDF converters (for ex., Able2Extract) tend to be the better option when dealing with longer, more complex (for ex., tables, repeating headers or footers) documents.

This Convert PDF to Excel Tutorial is accompanied by an Excel workbook containing the results I obtain when using each of the methods to convert PDF files into Excel I cover above. You can get immediate free access to this example workbook by subscribing to the Power Spreadsheets Newsletter . This workbook contains 4 different worksheets, each of them shows the results of each of the conversion methods I explain above.

After reading this blog post you have a good knowledge about 3 of the most popular and common methods to convert PDF files to Excel :

  • Copy and paste.
  • Use Microsoft Word.
  • Use a PDF converter, such as Able2Extract.

You've also seen some criteria that can help you decide which method is the right one for you and learned more about the relationship between PDF and Excel files.

This knowledge will help you to convert PDF files to Excel worksheets quickly and easily. You're also likely to start seeing new possibilities and opportunities for analyzing data or carrying other analysis that you didn't do before because, for example, the source data was stored in PDF format.

guest

I publish a lot of Tutorials and Training Resources about Microsoft Excel and VBA . Here are some of my most popular Excel Training Resources:

  • Free Excel VBA Email Course
  • Excel Macro Tutorial for Beginners
  • Excel Power Query (Get and Transform) Tutorial for Beginners
  • Excel Keyboard Shortcut Cheat Sheet
  • Excel Resources

pdftoexcel.com logo

  • Bahasa Indonesia
  • Bahasa Malaysia

Convert PDF to Excel

Convert any pdf (scanned or regular) to excel instantly, in a hurry.

Always be the first in the line and avoid waiting!

Upload the document, the conversion will start automatically.

No need to leave an email or other personal information.

All files are deleted from our servers after 6h max (without a trace) .

Safe and Secure

All data uploaded to our servers will be used for conversion purposes only and deleted promptly after conversion. Your files are accessed only by automated software agents.

Full Document Conversion

The web app converts entire PDFs to Microsoft Excel. If your PDF file has multiple pages, rest assured that the full document will be converted to Excel free.

Exact Spreadsheet Recognition

All tables trapped in PDF will be extracted accurately. The rows and columns structure will be the same as in the original file, but fully editable and ready for reuse.

Excel’s .xlsx Format

The new spreadsheet will be in .xlsx format ready to use in Microsoft Excel, LibreCalc, OpenCalc or any other office suite compatible with MS Office.

There is no need to leave an email address or other identifiable data. Upload your file and the document will be converted right on the page.

Extract Scanned Tables

Besides regular PDF files, the service works with scanned PDFs as well. Using the latest OCR technology, it accurately recognizes numbers and data.

Quick and Easy

Conversion speed depends on the file size and servers' overload.

Drive, Dropbox and OneDrive

Import PDFs from your Google Drive, Dropbox or OneDrive account. Log in, choose a file and start converting.

This service is free to use, without any file conversion limits. Try it out right now.

How to convert PDF to Excel Free Online

pdftoexcel.com how to image

  • Upload or drag and drop any PDF (regular or scanned) to PDFtoExcel.com. Alternatively, you can import the PDF for conversion directly from Google Drive, Dropbox or OneDrive.
  • The conversion starts automatically as soon as the file has been uploaded.
  • Wait for PDFtoExcel.com to finish conversion.
  • Download your .XLSX spreadsheet by clicking on the Free Download button.

This website uses cookies to ensure you get the best possible experience. By continuing you agree to our Terms of Service and Privacy Policy

Convert PDF To Excel

This online pdf converter allows you to convert pdf into excel spreadsheets. convert from pdf to xls or from pdf to xlsx. easily create tables from your pdf documents with this excel converter.

To get the best results, select all languages that your file contains.

Firefox extension for PDF2Go

Stay connected:

How to convert PDF to Excel?

  • Upload your PDF file.
  • Choose Excel 2007-2013 (*.xlsx) or Excel 2003 or older (*.xls) from the dropdown menu.
  • Use any of the optional settings to improve the conversion.
  • Click on "Start".

Background image showing a folder

Convert PDF To Excel Online for free and wherever you want

Versatile pdf to excel converter.

It's easy. Just upload your PDF document by selecting it from your hard drive, providing a link, adding it from a cloud storage or dragging it into the upload box.

Once your PDF is uploaded, choose a Microsoft Excel spreadsheet format from the dropdown menu. You can choose between XLS and XLSX.

When you're done, click on "Start" and the PDF converter will take care of the rest.

PDF Converter To Excel Online

There is no need to install a program or download an app. PDF2Go works online with any web-browser. All you need is a stable internet connection and PDF2Go.com.

No malware, no virus, just your converted Excel spreadsheet is downloaded.

Why Convert From PDF To Excel?

PDF is a versatile document format, but it can be difficult to edit it. To easily extract a table or edit text in a spreadsheet format, you can to convert PDF to editable Excel spreadsheets.

Using OCR (Optical Character Recognition), you can even make scanned book pages editable. Don't waste time copying text manually, let us do the work for you!

PDF To Excel Conversion Is Safe

If you convert your PDF document to Microsoft Excel on PDF2Go, you can be sure that your file is 100% safe.

SSL encryption, regular server clean ups and secure uploads & downloads are key. We also do not obtain any rights on your documents.

For more info, feel free to check our Privacy Policy.

What Can I Convert To?

With this PDF converter, you can easily convert from PDF to Excel, more specifically to the Microsoft formats XLS and XLSX. Of course, you can also convert your PDF to other formats!

Mobile PDF Converter

Convert PDF from any computer, smartphone or tablet!

On PDF2Go, you can convert PDF to Excel online. It doesn't matter if you're on the train or bus, at home or at work – all you need for it to work is an internet connection!

Rate this tool 4.1 / 5

You need to convert and download at least 1 file to provide feedback

Feedback sent

Thank you for your vote

Blog & Articles

How to convert a PDF file to Excel Online

How to convert a PDF file to Excel Online

The article explains how to convert a PDF file to Excel.

Paperless Office – The Future Of Doing Business

Paperless Office – The Future Of Doing Business

Read our top 6 reasons for implementing a paperless office today! Find out why is this way of doing business efficient, preferable, and environmentally friendly.

PDF2Go Educational Account - All You Need To Know

PDF2Go Educational Account - All You Need To Know

Find out how to open an educational account and use all PDF2Go tools completely free of charge.

Dictionary & File Formats

PDF is short for Portable Document Format. PDF documents can contain formatted text, different fonts, hyperlinks, images, and even media such as sounds and videos.

A JPG (or extended JPEG, Joint Photographic Experts Group file) is an image file format.

OCR is short for Optical Character Recognition. This process is used to recognize the visual representation of text, for example in an image.

Specify a downloader that fits your task

Piwik

How to convert a PDF file to Excel

  • To convert a PDF to Excel, open the PDF file in Word.
  • Save the PDF in Word as a webpage, then open that webpage file in Excel.
  • You can also export a PDF to Excel using Adobe Acrobat if you have a paid version of the service.

PDF files are great for delivering documents in a standard format that's exactly the same no matter what device or software you use to view it — but they are difficult to edit. If you have a spreadsheet in PDF format, often the easiest way to manipulate the data is to convert the PDF to Excel and edit it there. 

There's no one-click way to convert a PDF to Excel format within Excel itself, but if you have both Word and Excel, it's fairly easy to do. In addition, there's a simple way to convert PDF to Excel if you own a copy of Adobe Acrobat. 

How to convert a PDF to Excel with Microsoft Office

To convert a PDF using Office, you'll need both Microsoft Word and Microsoft Excel. 

1. Find the PDF on your computer. Open the folder that contains the file, but don't open the PDF. 

2. Right-click the PDF and, in the pop-up menu, click Open with .

3. Click Word . If you don't see Word, click Choose another app and then, in the pop-up window, click More apps and scroll until you see Word and then click OK .  

4. Word should start automatically, but you'll see a dialog box asking permission to convert the PDF to Word. Click OK . It might take a few minutes for this process to complete, depending upon how large and complex the PDF file is. 

5. In Word, click File , then Save As . 

6. Use the Save As window to save the file as a Web Page (*.htm, *.html) . Note where you save the file, because you'll need to find it again in a moment. 

7. Start Excel . 

8. Click File , then Open , and choose the webpage version of the document you just saved.

The PDF should now open in Excel, ready to edit. You can save the file in Excel as an Excel file for future use. 

How to convert a PDF to Excel using Adobe Acrobat 

There's another way to convert a PDF to Excel format: You can use Adobe Acrobat Pro or Adobe Acrobat Pro DC (assuming you have purchased or own a subscription to these programs). 

1. Start Adobe Acrobat and open the PDF you want to convert. To do this, click File , then Open , and navigate to the PDF file on your computer — or you can drag the file into your Acrobat window.

2. In the Tools pane on the right side of the screen, click Export PDF .

3. In the Export PDF window, choose Microsoft Excel Document (*.xlsx) from the Convert To drop-down menu. 

4. Click Export to Excel . 

5. When the export is complete, click the Exported Files icon at the top of the page and click the file you just created. In the Save As dialog box, choose a location and save the new spreadsheet to your computer.

We may receive a commission when you buy through our links, but our reporting and recommendations are always independent and objective.

pdf export in excel

  • Main content

PDF to Excel Converter

CloudConvert offers the most advanced, industry leading PDF to XLS conversions. We do automatically extract the tables from any PDF document. Unlike our competitors, you get an actual usable, clean Excel spreadsheet. This saves you hours of copy & pasting!

capture website as

Create archive.

PDF is a document file format that contains text, images, data etc. This document type is Operating System independent. It is an open standard that compresses a document and vector graphics. It can be viewed in web browsers if the PDF plug-in is installed on the browser.

XLS is Microsoft Excel spreadsheet file that stores data and manipulates several mathematical operations. It uses a visual basic operation to implement several numeric functions. This spreadsheet file is supported by most of the open source or proprietary spreadsheet software.

+200 Formats Supported

CloudConvert is your universal app for file conversions. We support nearly all audio, video, document, ebook, archive, image, spreadsheet, and presentation formats. Plus, you can use our online tool without downloading any software.

Data Security

CloudConvert is ISO 27001 certified and has been trusted by our users and customers since its founding in 2012. No one except you will ever have access to your files. We earn money by selling access to our API, not by selling your data. Read more about that in our Security Overview .

High-Quality Conversions

Besides using open source software under the hood, we’ve partnered with various software vendors to provide the best possible results. Most conversion types can be adjusted to your needs such as setting the quality and many other options.

Powerful API

Our API allows custom integrations with your app. You pay only for what you actually use, and there are huge discounts for high-volume customers. We provide a lot of handy features such as full Amazon S3 integration. Check out the CloudConvert API .

How-To Geek

How to save an excel sheet as a pdf.

Don't settle for a cluttered-looking Excel printout. Here's how to save a spreadsheet as a clean, easily readable PDF file.

Quick Links

Excel files as pdfs, setting up the page, defining a print area and fitting, sheet options, saving or printing as pdf.

Saving an Excel spreadsheet as a PDF can be confusing, and the finished file often looks different from how we want it to be presented. Here's how to save a sheet as a readable clean PDF file.

There are many scenarios when you may want to save an Excel document as a PDF file instead of a spreadsheet. For example, if you wish to send out only a specific portion of a larger sheet, or you don't want it to be editable. However, converting an Excel file to a PDF can be a bit tricky.

We often don't think of Excel spreadsheets as documents with borders, pages, and margins. However, when it comes to turning these files into PDF documents that can be read, printed, or distributed to others, it's something that you should be conscious of. Your file should be readable and understandable, without random stray columns on other pages or cell sizes that are too small to read.

Here's how to turn your spreadsheet into a presentable and printable PDF document.

Excel - Page Setup

If you're using Office 2008 or later, navigate to the Page Layout tab. Here, you'll see several options grouped under the Page Setup section. Here are the first three:

  • Margins:  How large the whitespace is between the edge of a document and the first cell
  • Orientation:  Whether you want your finished file to be in landscape or portrait
  • Size:  The page size of your finished document

These work mostly the same as they do in a Word document, so set them based on how you want your finished PDF to look like. Take note that most Excel spreadsheets are more readable in landscape orientation than in portrait, unless you have very few columns. Sheets that are saved in portrait tend to have columns that fall outside of the final print area, which can make your document very difficult to navigate and read.

Additionally, you can add a header and footer to your final layout. Click the arrow on the lower-right corner of the Page Setup section, then click on the Header/Footer tab. You can select one of Office's generated options, or create one of your own by using the "Customize" feature.

Excel - Header and Footer

You also have the option to change the background of your printout. To do this, click the Background button in Page Setup. You can select an image from your laptop or from the cloud, and this image will be tiled across your entire sheet.

Related: How to Print an Excel Spreadsheet with a Background

Next, you need to determine what area is going to be turned into a PDF, as well as how many rows and columns will be on each page.

The first way to define the area is by using click and drag to select all the cells that you want in your document. Afterward, go to Page Setup > Print Area > Set Print Area. This will create a thin grey line around the entire area that will be printed. When you create your PDF, everything outside this area will not be included. You can also manually input the cells by clicking the arrow on the lower-left corner and going to Sheets > Print Area.

Excel - Print Area

Similar to Microsoft Word, you can also create page breaks to segment different tables. These page breaks can be both horizontal and vertical. Go to the cell where you want to place a page break, click the "Page Layout" tab on the ribbon, and select Page Setup > Page Breaks > Insert Page Break. This will create a break right above and to the left of your current cell.

Excel - Page Breaks

Another important thing to do is to define the Scale to Fit option. To the right of Page Setup, you'll see three options: Width, Height, and Scale. The Width and Height options allow you to set how many pages the rows or columns of your table will appear in. For example, if you have a lot of rows but just a few columns, setting the Width to one page is ideal. Scale, on the other hand, will determine the overall resizing of your entire print area.

Excel - Scale to Fit

The last menu you should pay attention to is Sheet Options. These are settings that affect the appearance of your final printed sheet. To access the full sheet options, click on the arrow on the lower-left corner of Sheet Options sections.

Excel - Sheet Options

Here's an overview of the various customizations you can do in this menu:

  • Print Titles:  You can freeze specific rows and columns of the sheet in place so that they appear on every page, such as headers and labels.
  • Gridlines: This lets you set whether or not to show gridlines, which are the lines between cells that appear when there's no border painted on them.
  • Headings:  This allows you do display headings, which are the fixed alphabetical (A, B, C) and numerical (1, 2, 3) labels on the x-axis and y-axis of Excel spreadsheets.
  • Comments, Notes, and Errors: This displays the  embedded comments , notes, and error warnings in the final document.
  • Print Order:  This lets you set whether to create a document going down first or going right first.

In this menu, you can go to the Print Preview screen, where you can get a glimpse of your final document. You can also go to the screen with the shortcut Ctrl+P.

Related: How to Print a Worksheet with Comments in Excel

With your document correctly formatted and all set to go, there are two ways you can create a PDF.

To save the file as a PDF in Excel, open the Save As dialog, and select PDF from the "Save as type" dropdown menu. Alternatively, you can go to Export > Export to XPS/PDF. From here, you have a few options. You can decide whether to optimize the file for Standard or Minimum, which will determine the final quality and filesize of the document. You can then click "Options" to select the area to publish:

  • Selection:  The current cells you have selected
  • Active Sheets:  The current sheet that you're in
  • Entire Workbooks:  All the workbooks in the current file you're working on
  • Table:  A defined table that you've created via Microsoft Excel

You can also opt to ignore the print area you've set entirely.

Excel - Save as PDF

You could also print the file as a PDF. Microsoft has a built-in PDF printer  called Microsoft Print to PDF that you can select in the printer dropdown menu. If you have another PDF drive, such as Adobe PDF, Foxit, or PDF Xchange, you can use one of those as well. Before you click "Print", look through your print preview to make sure everything looks correct.

Excel - Print as PDF

Related: How to Print to PDF in Windows: 4 Tips and Tricks

Excel Dashboards

Excel Tutorial: How To Export Pdf In Excel

Introduction.

Exporting PDF in Excel is a vital skill for professionals and students alike. Whether you need to share data with colleagues, clients, or instructors, the ability to convert your Excel spreadsheets into PDF format is crucial. In this tutorial, we will guide you through the process of exporting PDF in Excel, providing you with the knowledge and tools to streamline your workflow and effectively communicate your data.

Preview of Steps:

  • Step 1: Open your Excel spreadsheet
  • Step 2: Select the data or sheet you want to export
  • Step 3: Go to the "File" tab and choose "Save As"
  • Step 4: Select "PDF" as the file format and specify the location to save the file
  • Step 5: Click "Save" to export your Excel file as a PDF

Key Takeaways

  • Exporting PDF in Excel is essential for sharing data with colleagues, clients, or instructors.
  • By following the step-by-step guide provided, you can streamline your workflow and effectively communicate your data.
  • Customizing PDF export settings in Excel allows for advanced options and added security features.
  • Troubleshooting common issues with PDF export in Excel is crucial for ensuring a smooth export process.
  • Integrating PDF export into Excel workflows can lead to time and cost savings, as well as streamline collaboration and document sharing.

Understanding PDF export functionality in Excel

When working with Excel, the ability to export data to a PDF format can be incredibly useful. Understanding the PDF export functionality in Excel is important for efficiently sharing and preserving data in a professional and secure manner.

Exporting to PDF format allows users to create a secure and non-editable version of their Excel spreadsheets. It is often used for sharing documents externally, as PDFs are universally compatible and maintain the original formatting of the Excel file.

There are several benefits to exporting Excel files to PDF format. This includes ensuring that the data remains unchanged, preserving the layout and formatting, and making the document accessible to individuals who may not have Excel installed on their devices.

PDF export functionality is available in various versions of Excel. While the process may slightly differ between versions, the ability to export to PDF is commonly supported in Excel 2010, 2013, 2016, and Microsoft 365. Understanding the specific steps for each version can help users effectively utilize this feature.

Step-by-step guide to exporting PDF in Excel

Exporting an Excel file to PDF format is a simple process that allows you to easily share and distribute your data in a secure and professional manner. Follow the steps below to learn how to export PDF in Excel.

A. Opening the Excel file you want to export

Before you can export your Excel file to PDF, make sure to open the specific file you want to convert. This can be done by simply locating the file on your computer and double-clicking on it to open in Excel.

B. Selecting the "File" tab and choosing "Save As"

Once your Excel file is open, navigate to the "File" tab located in the top-left corner of the Excel window. Click on it to access the dropdown menu and then select the "Save As" option.

C. Choosing the PDF format from the drop-down menu

After selecting "Save As," a new window will appear allowing you to choose the file format for the export. From the dropdown menu labeled "Save as type," select "PDF" as the desired file format for the export.

D. Naming the file and selecting the location to save it

Once you have selected the PDF format, you will need to provide a name for the file. Enter the desired file name in the "File name" field. Additionally, choose the location on your computer where you want to save the exported PDF file.

E. Finalizing the export process

After naming the file and selecting the save location, click on the "Save" button to finalize the export process. Excel will then convert your file to PDF format and save it to the specified location on your computer.

By following these simple steps, you can efficiently export an Excel file to PDF format, making it easier to share and distribute your data with others.

Customizing PDF export settings in Excel

Microsoft Excel offers a range of options for customizing the settings when exporting a file to PDF. These settings allow you to tailor the PDF export to your specific needs, ensuring that the resulting file meets your requirements.

When exporting a file to PDF in Excel, you can explore the advanced options to customize the settings. This includes options such as selecting the quality of the output, choosing whether to include comments or markups, and adjusting the font embedding.

Excel allows you to adjust the page layout and print settings when exporting to PDF. This means you can specify the paper size, orientation, and scaling options to ensure that the PDF output matches your desired layout and appearance.

To enhance the security of your PDF export from Excel, you can add features such as password protection and encryption. This ensures that only authorized individuals can access the file and prevents unauthorized modifications.

Troubleshooting common issues with PDF export in Excel

When exporting your Excel file to PDF, you may encounter some common issues that can affect the formatting and compatibility of the document. Understanding how to troubleshoot these issues can help you ensure a smooth and successful PDF export process.

When exporting to PDF, you may encounter formatting issues such as missing or distorted elements, incorrect page breaks, or inconsistent font sizes. To address these issues:

Check the page layout:

Use the page break preview:, embed fonts:.

After exporting to PDF, you may encounter compatibility issues when viewing the document in different PDF viewers. To resolve these problems:

Use standard fonts:

Test the pdf in different viewers:, consider pdf settings:.

During the export process, you may encounter errors or warnings that can affect the quality and integrity of the PDF document. To handle these issues:

Review error messages:

Check file size and complexity:, update excel and pdf software:, integrating pdf export into excel workflows.

Exporting to PDF in Excel is a valuable feature that can greatly enhance professional workflows. In this post, we will explore the various use cases for PDF export, the benefits of integrating it into Excel workflows, and the potential time and cost savings associated with this feature.

Creating professional reports

When working on financial statements, project summaries, or any other type of report, exporting to PDF ensures that the formatting and layout remain consistent across different devices and platforms.

Sharing data with clients or stakeholders

By exporting Excel data to PDF, professionals can easily share information with clients or stakeholders who may not have access to Excel or need a more universally accessible file format.

Archiving important documents

PDF export is also useful for archiving important Excel documents, ensuring that the content remains intact and easily accessible in the future.

Enhanced compatibility

PDF export allows users to share documents with colleagues or clients without worrying about compatibility issues, as PDF files can be opened on any device without the need for specialized software.

Improved document security

PDF files can be password-protected, adding an extra layer of security when sharing sensitive information with external parties.

Streamlined review and feedback processes

PDF files provide a standardized format for reviewing and providing feedback, making collaboration more efficient and effective.

Reduced formatting time

Exporting to PDF eliminates the need to manually adjust formatting for different devices, saving time and ensuring consistent presentation of data.

Minimized printing costs

PDF files can be easily shared electronically, reducing the need for printing and lowering associated costs.

Efficient document archival

By archiving documents in PDF format, professionals can save time and resources on long-term document storage and retrieval.

Exporting PDF in Excel offers a myriad of benefits, including preserving formatting, ensuring document security, and easy sharing. It is a valuable skill for professionals across different industries, and mastering this feature can greatly increase efficiency and productivity. I encourage all readers to practice the tutorial and familiarize themselves with the process. By doing so, you can streamline your workflow and enhance your proficiency in using Excel for various tasks. Remember, the ability to export PDFs is an essential skill to have in today's digital age, and it can set you apart in the workplace.

Excel Dashboard

Immediate Download

MAC & PC Compatible

Free Email Support

Related aticles

Excel Tutorial: What Does #### Mean In Excel

Excel Tutorial: What Does #### Mean In Excel

Understanding Mathematical Functions: How To Call A Function In Vba

Understanding Mathematical Functions: How To Call A Function In Vba

Understanding Mathematical Functions: How To Add Function In Google Sheets

Understanding Mathematical Functions: How To Add Function In Google Sheets

Understanding Mathematical Functions: How To Fill In A Table Using A Function Rule

Understanding Mathematical Functions: How To Fill In A Table Using A Function Rule

Understanding Mathematical Functions: What Are The Basic Functions Of A Cell

Understanding Mathematical Functions: What Are The Basic Functions Of A Cell

Making Write 15 Minutes On A Timesheet

Making Write 15 Minutes On A Timesheet

Making Identify Sheet Sizes

Making Identify Sheet Sizes

Mastering Formulas In Excel: What Is The Formula For Standard Deviation

Mastering Formulas In Excel: What Is The Formula For Standard Deviation

Mastering Formulas In Excel: What Is The Formula Of Force

Mastering Formulas In Excel: What Is The Formula Of Force

Mastering Formulas In Excel: What Is Net Present Value Formula

Mastering Formulas In Excel: What Is Net Present Value Formula

Mastering Formulas In Excel: How To Write Formula In Google Docs

Mastering Formulas In Excel: How To Write Formula In Google Docs

Mastering Formulas In Excel: How To Do A Formula In Google Sheets

Mastering Formulas In Excel: How To Do A Formula In Google Sheets

  • Choosing a selection results in a full page refresh.
  • Billing Plan
  • Payment Method
  • Notifications
  • OCR Converter
  • Video Converter
  • Audio Converter
  • E-book Converter
  • Image Converter
  • Archive Converter
  • Vector Converter
  • Document Converter
  • Video to MP3
  • PDF Converter
  • Image to PDF
  • Image to Word
  • Unit Converter
  • Time Converter
  • Video Compressor
  • Image Compressor
  • GIF Compressor
  • MP3 Compressor
  • WAV Compressor
  • Compress PDF
  • Compress JPEG
  • Compress PNG
  • Video to GIF
  • WEBM to GIF
  • APNG to GIF
  • GIF to APNG
  • Video Trimmer
  • API Job Builder
  • API Documentation
  • File Conversion API
  • Image Conversion API
  • Audio Conversion API
  • Document Conversion API
  • PDF Conversion API
  • MP4 Conversion API
  • Video Conversion API
  • JPG to PDF API
  • Video to MP3 API
  • HEIC to JPG API
  • PDF to JPG API
  • Webp to PNG API
  • PDF to WORD API
  • MP4 to MP3 API
  • Webp to JPG API
  • WORD to PDF API
  • HTML to PDF API
  • Website Screenshot API
  • Video Compression API
  • Compress PDF API
  • Image Compression API

PDF to XLS Converter

Convert PDF to XLS online, for free.

  • From Device
  • From Dropbox
  • From Google Drive

Drop Files

Drop any files here!

  • Apply from Preset
  • Save as Preset

How to Convert PDF to XLS?

  • Click the “Choose Files” button to select your PDF files.
  • Click the “Convert to XLS” button to start the conversion.
  • When the status change to “Done” click the “Download XLS” button

Easy to Use

Simply upload your PDF files and click the convert button. You can also batch convert  PDF  to XLS format.

Best Quality

We use both open source and custom software to make sure our conversions are of the highest quality. In most cases, you can fine-tune conversion parameters using “Advanced Settings” (optional, look for the icon).

Free & Secure

Our PDF to XLS Converter is free and works on any web browser. We guarantee file security and privacy. Files are protected with 256-bit SSL encryption and automatically delete after a few hours.

What is a PDF (Portable Document Format) file?

The Portable Document Format (PDF) is a universal file format that comprises characteristics of both text documents and graphic images which makes it one of the most commonly used file types today. The reason PDF is so widely popular is that it can preserve original document formatting. PDF files always look identical on any device or operating system.

How to open a PDF file?

Most people head right to Adobe Acrobat Reader when they need to open a PDF. Adobe created the PDF standard and its program is certainly the most popular free PDF reader out there. It's completely fine to use, but I find it to be a somewhat bloated program with lots of features that you may never need or want to use.

Most web browsers, like both Chrome and Firefox, can open PDFs themselves. You may or may not need an add-on or extension to do it, but it's pretty handy to have one open automatically when you click a PDF link online. I highly recommend SumatraPDF or MuPDF if you're after something a bit more. Both are free.

Developed by: ISO

Initial Release: 15 June 1993

Useful links:

https://en.wikipedia.org/wiki/Portable_Document_Format

https://acrobat.adobe.com/us/en/why-adobe/about-adobe-pdf.html

Convert other files to XLS format

FreeConvert.com can convert your other files to XLS format:

  • XLS Converter
  • XLSM to XLS
  • XLSX to XLS

Convert Your PDF files to other formats

FreeConvert.com can convert your PDF files to these other formats:

  • PDF to PPTX
  • PDF to MOBI
  • PDF to DOCX
  • PDF to WORD
  • PDF to TEXT
  • PDF to XLSX
  • PDF to EPUB
  • PDF to AZW3
  • PDF to JPEG
  • PDF to TIFF
  • PDF to WebP
  • PDF to HTML

Related Tools

FreeConvert.com can convert your files to these related formats:

Want to convert large files without a queue or Ads?

Upgrade Now

  • MP4 Converter
  • MP3 Converter
  • HEIC to JPG

Document & Ebook

  • PDF to Word
  • EPUB to PDF
  • EPUB to Mobi

Archive & Time

  • Pound to KG
  • KG to Pound
  • Feet to Meter
  • Collage Maker
  • Image Resizer
  • Color Picker

Mobile Apps

  • Collage Maker Android
  • Collage Maker iOS
  • Image Converter Android
  • Image Converter iOS

© FreeConvert.com v2.23 All rights reserved (2024)

  • PRO Courses Guides New Tech Help Pro Expert Videos About wikiHow Pro Upgrade Sign In
  • EDIT Edit this Article
  • EXPLORE Tech Help Pro About Us Random Article Quizzes Request a New Article Community Dashboard This Or That Game Popular Categories Arts and Entertainment Artwork Books Movies Computers and Electronics Computers Phone Skills Technology Hacks Health Men's Health Mental Health Women's Health Relationships Dating Love Relationship Issues Hobbies and Crafts Crafts Drawing Games Education & Communication Communication Skills Personal Development Studying Personal Care and Style Fashion Hair Care Personal Hygiene Youth Personal Care School Stuff Dating All Categories Arts and Entertainment Finance and Business Home and Garden Relationship Quizzes Cars & Other Vehicles Food and Entertaining Personal Care and Style Sports and Fitness Computers and Electronics Health Pets and Animals Travel Education & Communication Hobbies and Crafts Philosophy and Religion Work World Family Life Holidays and Traditions Relationships Youth
  • Browse Articles
  • Learn Something New
  • Quizzes Hot
  • This Or That Game New
  • Train Your Brain
  • Explore More
  • Support wikiHow
  • About wikiHow
  • Log in / Sign up
  • Computers and Electronics
  • Adobe Software
  • Portable Document Format (PDF)

How to Copy a Table from a PDF to Excel

Last Updated: January 5, 2024 Fact Checked

Using Excel 365 for Windows

Using microsoft word.

This article was co-authored by wikiHow staff writer, Nicole Levine, MFA . Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources. This article has been viewed 221,774 times. Learn more...

Do you have a PDF table that you want to add to an Excel sheet? If you try copying the table from the PDF and then pasting it into Excel, you'll get jumbled and non-sensical text. Fortunately, it's easy to copy a table from a PDF to Excel if you have Microsoft 365 (Office 365) for Windows. If you're using a Mac or have an earlier version of Excel, you can still copy and paste the table by opening the PDF in Microsoft Word. This wikiHow article will teach you two simple ways to copy a table from a PDF to an Excel workbook.

Things You Should Know

  • With a Microsoft 365 subscription on Windows, you can use Power Query to import a table from any PDF.
  • You can also open a PDF in Word and enable editing to copy the table into an Excel worksheet.
  • When you paste a PDF table into Excel with either method, the data will be organized into columns and rows just as it was in the PDF. [1] X Research source

Step 1 Open Excel on your Windows PC.

  • This method covers using the Power Query feature to import a table from a PDF into Excel . This feature is only available with a Microsoft 365 (Office 365) subscription on Windows. Unfortunately, this feature is not yet available on Excel for Mac. [2] X Research source

Step 2 Select a cell.

  • Knowing the page number on which the table you want is located in the PDF will be helpful, as each table is labeled by page number.

Step 8 Click Load.

  • If you'd rather work with the table data in Power Query before copying it to your worksheet, click Transform Data instead. [4] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source

Step 1 Open the PDF in Microsoft Word.

  • Open Microsoft Word.
  • Click the File menu and select Open . If you don't see a File menu, just click Open .
  • Select the PDF that contains the table and click Open . [5] X Research source
  • Click OK when prompted to convert the PDF into a Word document. It may take a few moments to display the file.

Step 2 Use your mouse or trackpad to highlight the table you want to copy.

  • If prompted, click OK again to make the file editable.

Step 4 Select the table you want to copy to Excel.

  • If you'd rather keep the formatting of the original table, such as custom colors, fonts, and bold text, you can use Ctrl + V (PC) or Cmd + V (Mac) instead.

Expert Q&A

Video . by using this service, some information may be shared with youtube..

You Might Also Like

Reduce PDF File Size

  • ↑ https://nanonets.com/blog/copy-tables-from-pdfs-excel/
  • ↑ https://techcommunity.microsoft.com/t5/excel-blog/announcing-data-import-from-pdf-documents/ba-p/1569202
  • ↑ https://support.microsoft.com/en-us/office/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a#ID0EBH=Mac&ID0EBF=Windows_newer_versions
  • ↑ https://www.adobe.com/acrobat/resources/how-to-convert-pdf-to-word-on-mac.html

About This Article

Nicole Levine, MFA

1. Open Excel. 2. Select a cell where you want to start the table. 3. Click Data . 4. Click Get Data . 5. Click From File and From PDF . 6. Navigate to and double-click your PDF. 7. Click the table you want to copy from the PDF to Excel. 8. Click Load . Did this summary help you? Yes No

  • Send fan mail to authors

Is this article up to date?

Am I a Narcissist or an Empath Quiz

Featured Articles

Deal with Friendship Problems at School

Trending Articles

Everything You Need to Know to Rock the Corporate Goth Aesthetic

Watch Articles

Cook Fresh Cauliflower

  • Terms of Use
  • Privacy Policy
  • Do Not Sell or Share My Info
  • Not Selling Info

Keep up with the latest tech with wikiHow's free Tech Help Newsletter

PDF to Excel converter

User friendly web app to convert pdf to excel quickly and easily.

  • SSL secured file transfer
  • Automatic file deletion from the server after one hour
  • Servers are located in Germany
  • Free and easy to use PDF solution with many features for download
  • PDF24 Creator brings all PDF24 tools as offline version. All files remain on your PC.
  • Using PDF24 is fun and you will never want to use any other tool again.

Information

That's how easy it is.

Select your PDF files to be converted to Excel or drag them into the file box and start the conversion. Then save the created Excel files on your computer.

PDF converter for Excel files

On this page you can easily convert PDFs to Excel files. The online PDF converter from PDF24 also supports some other file formats and can also convert many file formats to PDF format.

Security is important to us

The security of your files is important to us. Your files are no longer than necessary accessible on our server. Your PDFs and Excel files will be completely removed from our system after a short time.

Easy to use

PDF24 makes it as easy and fast as possible to convert PDF to Excel. You do not need to install or configure anything, just select your PDF files and start the conversion.

Supports your system

To convert PDF files to Excel, there are no special requirements for your system. This tool works under all common operating systems and browsers.

No installation required

You do not have to install any software. The conversion of PDF to Excel is done on our servers. Your system will not be burdened and does not require any special requirements.

Questions and Answers

How can i convert pdf files to excel.

  • Use the file selection box to select the PDF files you want to convert to Excel files.
  • Start converting your PDFs to Excel by clicking on the Convert button.
  • Save the converted PDF files as Excel by using the download button.

Is it secure to use PDF24 Tools?

PDF24 takes the protection of files and data very seriously. We want our users to be able to trust us. Security aspects are therefore a permanent part of our work.

  • All file transfers are encrypted.
  • All files are automatically deleted from the processing server within one hour after processing.
  • We do not store files and do not evaluate them. Files will only be used for the intended purpose.
  • PDF24 is operated by a German company, Geek Software GmbH. All processing servers are located in data centres within the EU.
  • Alternatively, you can get a desktop version of the PDF24 tools with the PDF24 Creator . All files remain on your computer here, as this software works offline.

Can I use PDF24 on a Mac, Linux or Smartphone?

Yes, you can use PDF24 Tools on any system with which you have access to the Internet. Open PDF24 Tools in a web browser such as Chrome and use the tools directly in the web browser. You do not need to install any other software.

You can also install PDF24 as an app on your smartphone. To do so, open the PDF24 Tools in Chrome on your smartphone. Then click on the "Install" icon in the upper right corner of the address bar or add PDF24 to your start screen via the Chrome menu.

Can I use PDF24 offline without an Internet connection?

Yes, Windows users can also use PDF24 offline, i.e. without an Internet connection. Simply download the free PDF24 Creator and install the software. The PDF24 Creator brings all PDF24 tools to your PC as a desktop application. Users of other operating systems should continue to use PDF24 Tools.

Convert PDF to Excel

Convert your pdf to excel documents effortlessly, or drag and drop files here.

*Files deleted after 24 hours

Convert up to 2 GB files free, Pro users can convert up to 100 GB files; Sign up now

Drop your files here

How to convert a pdf to excel file online.

To convert a PDF to Excel, drag and drop or click our upload area to upload the file

Our tool will automatically convert your PDF to Excel file

Then you click the download link to the file to save the Excel file to your computer

PDF to Excel conversion FAQ

How does your pdf to excel converter handle tables and data, can i edit the converted excel spreadsheet easily, does the converter support the conversion of complex tables and formulas, are there any limitations on the number of rows or columns for excel conversion, can i convert scanned pdfs with tables to excel, file-document created with sketch beta. pdf.

PDF (Portable Document Format), a format created by Adobe, ensures universal viewing with text,images, and formatting. Its portability, security features, and print fidelity make it pivotal in document tasks, apart from its creator's identity.

file-document Created with Sketch Beta. EXCEL

Excel files, in XLS and XLSX formats, are spreadsheet documents created by Microsoft Excel. These files are widely used for organizing, analyzing, and presenting data. Excel provides powerful features for data manipulation, formula calculations, and chart creation, making it a versatile tool for business and data analysis.

Rate this tool

Convert other files.

217,423 Files converted since 2019

Privacy Policy | Terms of Service | About us | Contact Us | API

© 2024 PDF.to | VPS.org LLC | Made by nadermx

Insufficient credits

You need more credits to be able to convert more files

  • ☝ Convert as many files as you want
  • ☝ Batch uploading so you can drag and drop as many files at a time instead of one by one
  • ☝ Convert larger files up to 100GB
  • 🚀 Have the ability to ask for extra conversion tools to be added to PDF.to

PDF to Excel

Convert pdf to excel spreadsheets fast and easy.

or drag & drop

Best free PDF to XLS tool

Convert pdf to excel fast, files are automatically deleted, cross-device pdf to excel converter, user-friendly pdf to xls solution, convert pdf to xls at no cost.

Use this tool at least once to rate it.

How to convert PDF to Excel?

Pdf to excel - faq.

PDF to Excel and Excel to PDF

  • Compress PDF
  • PDF Converter
  • PDF Scanner
  • Delete PDF Pages
  • Extract PDF Pages
  • Number Pages
  • AI PDF Summarizer
  • PDF to Word
  • PDF to Excel
  • Word to PDF

Excel to PDF

  • Protect PDF
  • › Excel to PDF

Add PDF , image , Word , Excel , and PowerPoint files

Supported formats:

  • Free to use without registration
  • All it takes is a Drag & drop—easy!
  • No software download or installation

How To Convert Excel to PDF Online:

  • Drag & drop your file into the Excel to PDF converter.
  • Wait as the tool saves the spreadsheet to PDF format.
  • Continue working on your file with other tools, if needed.
  • Download, share, or save the PDF to Dropbox or Google Drive.

Excel to PDF Blog Articles

smallpdf green banner 2@2x.png

pdf export in excel

Export your PDF to other file types in seconds.

pdf export in excel

Convert PDFs to Microsoft docs.

When you need a Microsoft document but don’t have the source file, don’t worry. With Adobe Acrobat, exporting a PDF file to a Microsoft Word, Excel, or PowerPoint document is simple. That means you can spend less time retyping by simply reusing the content in your PDF.

You can even do it on the go, from any device. When you export to PDF or vice versa using Acrobat, all formatting, page numbers, and fonts of your original file stay intact.

pdf export in excel

Turn a PDF into an image or webpage.

Take any PDF document and export it as a JPG (JPEG), TIFF, or PNG image — then save as a new file. You can even turn a PDF into a functioning HTML webpage.

With Acrobat, you really can work from anywhere.

Export just about any file format to an editable PDF on the go with Acrobat. When you have all the PDF tools you need in a single solution, you can stay productive — wherever, whenever. Adobe makes it easy to create, edit, share, and e-sign PDFs across desktop, mobile, and web. You can even reduce file size for easier sharing.

pdf export in excel

Try it online.

You can try some of our PDF tools right now — online, on the spot. Discover how easy and powerful working with PDFs can be with Adobe Acrobat.

PDF to Word

Turn PDF pages into a Microsoft Word document (docx) or rich text format.

Turn any PDF into a JPG or other image file type.

PDF to Excel

Convert a PDF into a Microsoft Excel file.

Convert PDFs to Microsoft PowerPoint files.

pdf export in excel

Rely on Adobe Acrobat. Along with five million organizations.

Acrobat and Acrobat Reader are the choice of millions of organizations around the world to quickly create and edit PDF files and for accessibility to view them on any screen. Acrobat offers powerful PDF converter features to turn PDFs into instantly usable documents of other types. It simplifies workflows and gives teams greater productivity and collaboration so they can keep business moving from anywhere. Make it all happen with Adobe — the company that invented the PDF format.

Choose the plan with the features you need.

Acrobat reader.

The free global standard for reliably viewing, printing, and sharing PDFs.

Acrobat Standard

Save over 30% with an annual plan.*

Annual subscription, cancel within 14 days for a full refund.

Simple PDF tools for editing and converting documents.

pdf export in excel

Secure transaction

Acrobat Pro

The all-in-one PDF & e-signature solution with advanced tools to edit, convert, protect, and sign documents.

*When compared to month to month pricing plans.

Want to know more?

Our Acrobat expert is standing by.

Chat with Support   | 

Contact Sales   |

Adobe also offers Acrobat plans for larger organizations and teams. Learn more

Explore what else you can do with Adobe Acrobat.

You have selected an Acrobat Standard product that is only available for Windows.

Continue to checkout  or close this window to change your selection.

Language Navigation

pdf export in excel

Create a form in Word that users can complete or print

In Word, you can create a form that others can fill out and save or print.  To do this, you will start with baseline content in a document, potentially via a form template.  Then you can add content controls for elements such as check boxes, text boxes, date pickers, and drop-down lists. Optionally, these content controls can be linked to database information.  Following are the recommended action steps in sequence.  

Show the Developer tab

In Word, be sure you have the Developer tab displayed in the ribbon.  (See how here:  Show the developer tab .)

Open a template or a blank document on which to base the form

You can start with a template or just start from scratch with a blank document.

Start with a form template

Go to File > New .

In the  Search for online templates  field, type  Forms or the kind of form you want. Then press Enter .

In the displayed results, right-click any item, then select  Create. 

Start with a blank document 

Select Blank document .

Add content to the form

Go to the  Developer  tab Controls section where you can choose controls to add to your document or form. Hover over any icon therein to see what control type it represents. The various control types are described below. You can set properties on a control once it has been inserted.

To delete a content control, right-click it, then select Remove content control  in the pop-up menu. 

Note:  You can print a form that was created via content controls. However, the boxes around the content controls will not print.

Insert a text control

The rich text content control enables users to format text (e.g., bold, italic) and type multiple paragraphs. To limit these capabilities, use the plain text content control . 

Click or tap where you want to insert the control.

Rich text control button

To learn about setting specific properties on these controls, see Set or change properties for content controls .

Insert a picture control

A picture control is most often used for templates, but you can also add a picture control to a form.

Picture control button

Insert a building block control

Use a building block control  when you want users to choose a specific block of text. These are helpful when you need to add different boilerplate text depending on the document's specific purpose. You can create rich text content controls for each version of the boilerplate text, and then use a building block control as the container for the rich text content controls.

building block gallery control

Select Developer and content controls for the building block.

Developer tab showing content controls

Insert a combo box or a drop-down list

In a combo box, users can select from a list of choices that you provide or they can type in their own information. In a drop-down list, users can only select from the list of choices.

combo box button

Select the content control, and then select Properties .

To create a list of choices, select Add under Drop-Down List Properties .

Type a choice in Display Name , such as Yes , No , or Maybe .

Repeat this step until all of the choices are in the drop-down list.

Fill in any other properties that you want.

Note:  If you select the Contents cannot be edited check box, users won’t be able to click a choice.

Insert a date picker

Click or tap where you want to insert the date picker control.

Date picker button

Insert a check box

Click or tap where you want to insert the check box control.

Check box button

Use the legacy form controls

Legacy form controls are for compatibility with older versions of Word and consist of legacy form and Active X controls.

Click or tap where you want to insert a legacy control.

Legacy control button

Select the Legacy Form control or Active X Control that you want to include.

Set or change properties for content controls

Each content control has properties that you can set or change. For example, the Date Picker control offers options for the format you want to use to display the date.

Select the content control that you want to change.

Go to Developer > Properties .

Controls Properties  button

Change the properties that you want.

Add protection to a form

If you want to limit how much others can edit or format a form, use the Restrict Editing command:

Open the form that you want to lock or protect.

Select Developer > Restrict Editing .

Restrict editing button

After selecting restrictions, select Yes, Start Enforcing Protection .

Restrict editing panel

Advanced Tip:

If you want to protect only parts of the document, separate the document into sections and only protect the sections you want.

To do this, choose Select Sections in the Restrict Editing panel. For more info on sections, see Insert a section break .

Sections selector on Resrict sections panel

If the developer tab isn't displayed in the ribbon, see Show the Developer tab .

Open a template or use a blank document

To create a form in Word that others can fill out, start with a template or document and add content controls. Content controls include things like check boxes, text boxes, and drop-down lists. If you’re familiar with databases, these content controls can even be linked to data.

Go to File > New from Template .

New from template option

In Search, type form .

Double-click the template you want to use.

Select File > Save As , and pick a location to save the form.

In Save As , type a file name and then select Save .

Start with a blank document

Go to File > New Document .

New document option

Go to File > Save As .

Go to Developer , and then choose the controls that you want to add to the document or form. To remove a content control, select the control and press Delete. You can set Options on controls once inserted. From Options, you can add entry and exit macros to run when users interact with the controls, as well as list items for combo boxes, .

Adding content controls to your form

In the document, click or tap where you want to add a content control.

On Developer , select Text Box , Check Box , or Combo Box .

Developer tab with content controls

To set specific properties for the control, select Options , and set .

Repeat steps 1 through 3 for each control that you want to add.

Set options

Options let you set common settings, as well as control specific settings. Select a control and then select Options to set up or make changes.

Set common properties.

Select Macro to Run on lets you choose a recorded or custom macro to run on Entry or Exit from the field.

Bookmark Set a unique name or bookmark for each control.

Calculate on exit This forces Word to run or refresh any calculations, such as total price when the user exits the field.

Add Help Text Give hints or instructions for each field.

OK Saves settings and exits the panel.

Cancel Forgets changes and exits the panel.

Set specific properties for a Text box

Type Select form Regular text, Number, Date, Current Date, Current Time, or Calculation.

Default text sets optional instructional text that's displayed in the text box before the user types in the field. Set Text box enabled to allow the user to enter text into the field.

Maximum length sets the length of text that a user can enter. The default is Unlimited .

Text format can set whether text automatically formats to Uppercase , Lowercase , First capital, or Title case .

Text box enabled Lets the user enter text into a field. If there is default text, user text replaces it.

Set specific properties for a Check box .

Default Value Choose between Not checked or checked as default.

Checkbox size Set a size Exactly or Auto to change size as needed.

Check box enabled Lets the user check or clear the text box.

Set specific properties for a Combo box

Drop-down item Type in strings for the list box items. Press + or Enter to add an item to the list.

Items in drop-down list Shows your current list. Select an item and use the up or down arrows to change the order, Press - to remove a selected item.

Drop-down enabled Lets the user open the combo box and make selections.

Protect the form

Go to Developer > Protect Form .

Protect form button on the Developer tab

Note:  To unprotect the form and continue editing, select Protect Form again.

Save and close the form.

Test the form (optional)

If you want, you can test the form before you distribute it.

Protect the form.

Reopen the form, fill it out as the user would, and then save a copy.

Creating fillable forms isn’t available in Word for the web.

You can create the form with the desktop version of Word with the instructions in Create a fillable form .

When you save the document and reopen it in Word for the web, you’ll see the changes you made.

Facebook

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

pdf export in excel

Microsoft 365 subscription benefits

pdf export in excel

Microsoft 365 training

pdf export in excel

Microsoft security

pdf export in excel

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

pdf export in excel

Ask the Microsoft Community

pdf export in excel

Microsoft Tech Community

pdf export in excel

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

How to remove the header and row line number for Excel to PDF Export?

grafik2.jpg (231,4 KB) When i use Aspose Cells for Java to export an Excel table to PDF, there is always header and row line number, just like this Screenshot, header like “ABCDEFG” and row line number like “12345”.

Is there a way to remove such header and row line number in PDF export?

@zwei Thank you for providing the screenshot.

Could you please zip and attach your sample files, including the input Excel file (if any), the current output Excel file generated by Aspose.Cells? We will review your issue soon.

test.7z (59 Bytes)

It is the Excel file, because the forum doesn’t support xlsx file upload, so I zip it as 7z, just unzip it as xlsx

Our desired result is a PDF export without header/row-line-numbers.

@zwei I unpacked the zip file you provided, but it’s empty. Please confirm.

Original_XLSX.zip (543,2 KB)

Sorry, my bad, false operation. Now it is the zip file of the Excel table.

@zwei We used ver24.2 to convert your file, please check the output file. Original_XLSX.java.pdf.7z (566.8 KB) There were no header and row line numbers. Would you be willing to provide the code for us to further investigate? our code as follow:

Thanks for your code, that is already enough for me.

It is nice to know that your issue is sorted out now. Please feel free to write us back if you have further queries or issue, we will be happy to assist you soon.

IMAGES

  1. How to export PDF files from Acrobat to Excel, and Excel to Acrobat

    pdf export in excel

  2. How to Convert PDF Table to Excel (6 Methods with Guides)

    pdf export in excel

  3. 5 Ways to Convert Excel Files to PDF

    pdf export in excel

  4. Top 5 Ways on How to Export Excel to PDF on Mac and Windows

    pdf export in excel

  5. 5 ways you can easily convert your Excel file into a PDF

    pdf export in excel

  6. Convert an pdf to excel

    pdf export in excel

VIDEO

  1. How to Convert Excel File to PDF

  2. Convert Pdf to Excel

  3. Export data excel to Pdf

  4. PDF Edit, Combine and Export to Excel, All in One Tool

  5. convert pdf to excel

  6. How to Convert PDF Document to Excel? 📊

COMMENTS

  1. Convert PDF to Excel: A free online converter

    Try our free PDF to Excel converter Convert a PDF to Excel online for free with the Adobe Acrobat online converter. Select or drag and drop a PDF file to get started right away.

  2. Convert PDF to Excel —Free Converter PDF to XLS

    How To Convert PDF to Excel for Free. Upload or drop your PDF into the converter above. Choose the option you need—select OCR for scanned PDFs. Wait for us to convert your PDF to an editable Excel sheet. Hit "Download" or share your document—done!

  3. How to Import Data From a PDF to Microsoft Excel

    Connect a PDF File to Excel. To get started, select the sheet you want to work with in Excel and go to the Data tab. Click the Get Data drop-down arrow on the left side of the ribbon. Move your cursor to From File and pick "From PDF." Locate your file in the browse window, select it, and click "Import." Next, you'll see the Navigator pane.

  4. How to convert a PDF to Excel

    Open a PDF file in Acrobat. Click on the "Export PDF" tool in the right pane. Choose "spreadsheet" as your export format, and then select "Microsoft Excel Workbook.". Click "Export.". If your PDF documents contain scanned text, Acrobat will run text recognition automatically. Name your new Excel file and click the "Save" button.

  5. Convert PDF To Excel: 3 Easy Methods You Can Use Right Now

    Step #1: Open The PDF File. You can open the PDF file you want to convert using any of several methods, including the following 2: Method #1: On the Windows File Explorer: (i) Right-click on the PDF file to expand the right-click menu, (ii) select "Open with", and (iii) click on Word.

  6. Convert PDF to Excel Free Online

    Convert PDF to. Excel. Drag & Drop Files. Choose from Dropbox. Choose from Google Drive. Open from OneDrive. Upload the document, the conversion will start automatically. No need to leave an email or other personal information. All files are deleted from our servers after 6h max (without a trace).

  7. PDF Converter To Excel

    Upload your PDF file. Choose Excel 2007-2013 (*.xlsx) or Excel 2003 or older (*.xls) from the dropdown menu. Use any of the optional settings to improve the conversion. Click on "Start". Convert PDF To Excel Online for free and wherever you want. Versatile PDF To Excel Converter. It's easy. Just upload your PDF document by selecting it from ...

  8. How to convert a PDF file to Excel

    In the Export PDF window, choose Microsoft Excel Document (*.xlsx) from the Convert To drop-down menu. 4. Click Export to Excel . 5. When the export is complete, click the Exported Files icon at ...

  9. PDF to Excel

    PDF to Excel Converter. CloudConvert offers the most advanced, industry leading PDF to XLS conversions. We do automatically extract the tables from any PDF document. Unlike our competitors, you get an actual usable, clean Excel spreadsheet. ... PDF is a document file format that contains text, images, data etc. This document type is Operating ...

  10. How to Extract Data from PDF to Excel (4 Suitable Ways)

    First, open the file in Adobe Acrobat. After that, select the Export PDF option from the Tools option shown on the right side of the PDF. If the tools option doesn't display on the right side of your window, you will find it on the right side of the Home tab. Now, choose the Spreadsheet > Microsoft Excel Workbook.

  11. How to Save an Excel Sheet as a PDF

    To save the file as a PDF in Excel, open the Save As dialog, and select PDF from the "Save as type" dropdown menu. Alternatively, you can go to Export > Export to XPS/PDF. From here, you have a few options. You can decide whether to optimize the file for Standard or Minimum, which will determine the final quality and filesize of the document.

  12. How to Extract Specific Data from PDF to Excel

    In the export dialog, there are a number of options to control the rows/columns exported, and the file format. Choose the options you need, and click Export. In the file dialog, choose a location to save the output file. Open the file in Excel to review the extracted data.

  13. Excel Tutorial: How To Export Pdf In Excel

    Step 1: Open your Excel spreadsheet. Step 2: Select the data or sheet you want to export. Step 3: Go to the "File" tab and choose "Save As". Step 4: Select "PDF" as the file format and specify the location to save the file. Step 5: Click "Save" to export your Excel file as a PDF.

  14. Convert PDF to Excel Online for Free

    1 Drag and drop your PDF file onto our online PDF to Excel converter. 2 Click 'Start Conversion', Foxit's service will convert your PDF to Excel file (.xlsx), then wait for the conversion to complete. 3 Click 'Download your file' to save the converted Excel file to your computer.

  15. Convert PDF to Excel online for free

    Convert PDF to Excel in just seconds. Adobe Acrobat online services turn your PDF content into an easily editable Microsoft Excel file. Try it for free! Convert a PDF to Excel online for free with the Adobe Acrobat online converter. Select or drag and drop a PDF file to get started straightaway. Home;

  16. PDF to XLS Converter

    Click the "Choose Files" button to select your PDF files. Click the "Convert to XLS" button to start the conversion. When the status change to "Done" click the "Download XLS" button.

  17. 2 Simple Ways to Copy a Table from a PDF to Excel

    7. Press Ctrl +⇧ Shift + V (PC) or ⌘ Cmd +⇧ Shift + V (Mac) to paste. This copies the table data into the sheet without pasting any special colors or formatting from the PDF. This is a great way to paste if you want the data from the table to be plain text or automatically inherit the formatting of your Excel sheet.

  18. PDF to Excel converter

    Use the file selection box to select the PDF files you want to convert to Excel files. Start converting your PDFs to Excel by clicking on the Convert button. Save the converted PDF files as Excel by using the download button.

  19. PDF to Excel

    How to convert a PDF to Excel file online. To convert a PDF to Excel, drag and drop or click our upload area to upload the file. Our tool will automatically convert your PDF to Excel file. Then you click the download link to the file to save the Excel file to your computer.

  20. PDF to Excel

    1 Upload your PDF by clicking the "+Add file" button or drag and drop file into the browser's tab. Another option: upload a file from Google Drive or Dropbox. 2 The PDF to Excel conversion starts automatically. 3 Get an output spreadsheet and either download it to your device or further share it: upload the document back to Google Drive ...

  21. Excel to PDF

    How To Convert Excel to PDF Online: Drag & drop your file into the Excel to PDF converter. Wait as the tool saves the spreadsheet to PDF format. Continue working on your file with other tools, if needed. Download, share, or save the PDF to Dropbox or Google Drive.

  22. How to Export Data from Excel? (to Doc, PDF, CSV, XML, vCard)

    Open Word> Place the cursor on the page where you want to export the data.> Click on the Insert > Object. Click on Create from File in the Object dialogue box> Browse. Find and select the worksheet. (Make sure your workbook is opened and place the cursor on the dataset that we want to export.)> Click on Insert.

  23. Export PDF files

    With Adobe Acrobat, exporting a PDF file to a Microsoft Word, Excel, or PowerPoint document is simple. That means you can spend less time retyping by simply reusing the content in your PDF. You can even do it on the go, from any device. When you export to PDF or vice versa using Acrobat, all formatting, page numbers, and fonts of your original ...

  24. Create a form in Word that users can complete or print

    Show the Developer tab. If the developer tab isn't displayed in the ribbon, see Show the Developer tab.. Open a template or use a blank document. To create a form in Word that others can fill out, start with a template or document and add content controls.

  25. How to remove the header and row line number for Excel to PDF Export

    test.7z (59 Bytes). It is the Excel file, because the forum doesn't support xlsx file upload, so I zip it as 7z, just unzip it as xlsx. Our desired result is a PDF export without header/row-line-numbers.