Hello there,
I have some data in PDF files. I want to covert it to excel format. When i copy and paste it to excel it comes in one row and column. Can anyone help?
Thank you for all suggestions in advance.
Hello there,
I have some data in PDF files. I want to covert it to excel format. When i copy and paste it to excel it comes in one row and column. Can anyone help?
Thank you for all suggestions in advance.
Follow the steps to copy the tables from PDF to Excel:
- Open the file in Adobe Acrobat
- From the main toolbar, select the Table/Formatted Text Select Tool
- Select the table that you want to export
- Right click within the box
- Select Save As
- In the Save As Type window select ANSI Text (*.txt)
- And click Save
- Now open Excel
- Then click on File menu
- Select Open
- Make sure that Files of Type: Text Files
- Then select the Table and click Open
Have a look at this thread: Convert a PDF file to Word, Excel or JPG Format. Also try office Convert Pdf to Excel. It can extract data from almost any type of PDF to Excel without losing any the original Text, Tables, Graphics & Layout. It allows you to convert PDF files of any size.
Solid Converter PDF helps you produce Word and Excel files that are better quality and easier to reuse.
Bookmarks