How to Import Data from PDF to Excel

PDFs are one of the most versatile document formats. Furthermore, there is no worry of formats changing or templates being edited accidentally, when documents are shared. Almost any type of document can be shared as a PDF. However, problems arise when trying to edit a PDF document. Moreover, if a structured file format is converted to PDF it is easy to convert it back using any online converter. Whereas, a PDF which is made up of scanned images becomes very difficult to edit.

PDF to Excel

The solutions presented in this article are provided by users which have been tried and verified by others as well. Also, the solutions cover both structured file conversion for editing e.g. a .xlsx (MS Excel) file that was converted to a PDF and back, as well as editing scanned PDF documents.

Open PDFs in Microsoft Word

Even if Excel sheets are converted to PDF, the document cannot be opened again directly in Excel. This is because Excel does not have the capability to convert a PDF document. The solution provided by the users, in this case, is to open the PDF in MS Word (2013 and above) and copy the tables from Word to Excel. For this solution

  1. First, launch MS Word.
    Word 2013 and above main page
  2. Second, click on Open.
  3. Last, click on Browse to find the file you want to open in Word.
    Open or browse files
  4. Now you can copy tables from Word to Excel, there may be some formatting issues, but not much.

Use Google Drive

Not many people know this, but Google Drive is also a good converter for files. Files that cannot be converted using MS Word can be converted using Google Drive. This is a part of the Google G Suite, their professional workplace ecosystem. To convert a PDF using Google Drive

  1. First, upload the file to Google Drive.
  2. Then, right-click on the file and go to Open with.
  3. Click on File-Converter- By Online-Convert.com.
    Open with File-Convert
  4. The link will take you to the conversion website.
  5. You will be asked to permit the website to access your files from Google Drive.
  6. Then, the website will give you several formats to convert to.
  7. Choose Convert to XLSX.
    Convert to XLSX
  8. Subsequently, the website will convert your file and begin auto-download.
  9. Again, it depends on the format of the original file, that you may or may not have to do some manual formatting.

Use PDFtoExcel

Sometimes the previous format of the given PDF document cannot be changed and you have to make do with what you have. The solutions mentioned above are all conversions where the PDF was formed from a structured format like an Excel sheet or a Word document. However, in some cases, PDFs are formed with scanned files or images. Since there is no actual text to convert, normal converters fail and you have to use OCR (Optical character recognition) converters. PDFtoExcel is just such a converter. It can be used for regular as well as scanned PDF conversion to Excel sheets. To use PDFtoExcel

  1. First, go to PDFtoExcel.
  2. Then, upload your document.
    PDFtoExcel homepage and upload
  3. The website will take some time to convert your file.
    Converting PDF to Excel sheet
  4. Lastly, the website will prompt you to download the converted file.
    Download converted file
  5. Again, since it is converting scanned documents and not actual text, you may have to do some final tweaking.

Kevin Arrows


Kevin is a dynamic and self-motivated information technology professional, with a Thorough knowledge of all facets pertaining to network infrastructure design, implementation and administration. Superior record of delivering simultaneous large-scale mission critical projects on time and under budget.

Expert Tip

How to Import Data from PDF to Excel

If the issue is with your Computer or a Laptop you should try using Restoro which can scan the repositories and replace corrupt and missing files. This works in most cases, where the issue is originated due to a system corruption. You can download Restoro by clicking the Download button below.

Download Now

I'm not interested