PDF Conversion


Ad

Advertisements

honestone

New Member
Joined
Sep 17, 2014
Messages
4,855
Reaction score
237
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

New Member
Joined
May 29, 2017
Messages
3
Reaction score
0
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

New Member
Joined
May 25, 2017
Messages
4
Reaction score
1
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

New Member
Joined
Sep 17, 2014
Messages
4,855
Reaction score
237
Thanks, Kristeen. I'll try and remember that tip.
 

honestone

New Member
Joined
Sep 17, 2014
Messages
4,855
Reaction score
237
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/article/Release-notes-for-Office-2016-for-Mac-ed2da564-6d53-4542-9954-7e3209681a41?ui=en-US&rs=en-US&ad=US
 
Ad

Advertisements

Jmarsiman

New Member
Joined
May 29, 2017
Messages
3
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top