PDF Conversion

[Jmarsiman]

What is the best way to convert pdf to excel?

 

[honestone]

Need more information before we can help you:

1. What exact Mac model do you have?

2. What exact Mac OS are you running?

3. What version of Excel/Office? Office 2016/Excel 2016, Office 2011/Excel 2011, or Office 2008/Excel 2008?

4. Where are you getting the pdf file from?

 

[Jmarsiman]

Thank you for the response.

MacBook Pro (15-inch, Mid 2012) with Sierra 10.12.
Excel for Mac V 15.27
PDF file was scanned from a ledger sheet....data no longer available otherwise.

 

[Kristeen Carter]

Try below given steps to import PDF data into Excel

• Open PDF in Adobe Reader
• Click on “File” and “Save as Text”
• Choose destination folder to save the file and click on “Save” (it will save your PDF as text)
• Open Excel on your Mac and click the “Import” button
• Select the text file (converted PDF) to import and click on “Import”
• Now, select the text file which you just saved and click on “Get Data”. “Text Import Wizard” will open up
• Follow the steps in Text Import Wizard, where you can define how you want to divide the text into rows, columns and other formatting options. Once the formatting is done click on “Finish”.
• Click on “Existing sheet” to import data on the current sheet, click on “Ok” and save the file.

 

[honestone]

Thanks, Kristeen. I'll try and remember that tip.

 

[honestone]

Thank you for the response.

MacBook Pro (15-inch, Mid 2012) with Sierra 10.12.
Excel for Mac V 15.27
PDF file was scanned from a ledger sheet....data no longer available otherwise.

Hopefully, Kristeen's steps will work.

Now, Sierra is actually up to V 10.12.5. If you don't have it, you can upgrade to V10.12.5 via the Combo Updater, available from here:

https://support.apple.com/kb/DL1918?locale=en_US

Note that you can apply that to any prior version of Sierra, ie, 10.12. 10.12.1, 10.12.2, 10.12.3, or 10.12.4.

Also, Office 2016/Excel 2016 is now up to V15.34. Here is a link that has all Office 2016 updates, starting with V15.28:

https://support.office.com/en-us/ar...542-9954-7e3209681a41?ui=en-US&rs=en-US&ad=US

 

[Jmarsiman]

Try below given steps to import PDF data into Excel

• Open PDF in Adobe Reader
• Click on “File” and “Save as Text”
• Choose destination folder to save the file and click on “Save” (it will save your PDF as text)
• Open Excel on your Mac and click the “Import” button
• Select the text file (converted PDF) to import and click on “Import”
• Now, select the text file which you just saved and click on “Get Data”. “Text Import Wizard” will open up
• Follow the steps in Text Import Wizard, where you can define how you want to divide the text into rows, columns and other formatting options. Once the formatting is done click on “Finish”.
• Click on “Existing sheet” to import data on the current sheet, click on “Ok” and save the file.

Thanks, Kristeen... we'll try it.