There is a nice, quick way to transfer numbers to Excel from an Adobe PDF file. First, however, you need to make sure it is not a scanned PDF. Also, this works best for just a few pages maximum. For larger documents, IDEA is extremely useful.
How to do this:
- Zoom in a lot
- Look at the numbers. If the lines are really smooth and clear, you’re good to go. The first image below represents the way it should look for this process to work. The second image probably won’t work.
- Zoom back out
- Select the “Select” tool
- With the mouse pointer at the top left corner of the column, hold down the ALT key. A dotted-line box should appear on the mouse pointer.
- With the ALT still held down, drag down and across the column to select all of the numbers.
- Go to Edit -> Copy or hit CTRL + C to copy the numbers.
- In Excel, select the destination cell and click Paste or hit CTRL + V. The numbers should now appear in the column.
BONUS: Use the OCR feature in Acrobat to possibly do this with a scanned PDF.
#1 by ptz plus on June 28, 2012 - 8:08 am
hello!,I like your writing so much! share we communicate more about your post on AOL?
I need a specialist on this area to solve my problem. Maybe that’s you! Looking forward to see you.
#2 by Jawbone Era on May 30, 2013 - 10:42 pm
Wow, this article is fastidious, my younger sister is analyzing these kinds of things, so I am going to let
know her.
#3 by mobile marketing on August 6, 2013 - 9:35 pm
Hi, I do think this is a great website. I stumbledupon it 😉
I will return yet again since i have book marked it.
Money and freedom is the best way to change, may
you be rich and continue to guide others.
#4 by google web hosting custom domain on October 23, 2013 - 9:25 pm
I know this web page provides quality based articles and additional information, is there
any other web site which presents these kinds of stuff in quality?
#5 by assassin's creed 4 black flag steam alicia keys freedom tour opening on January 8, 2014 - 2:58 pm
Do you have a spam issue on this website; I also am a blogger, and I was wanting
to know your situation; we have developed some nice procedures and we are looking to exchange methods with
others, be sure to shoot me an email if interested.
#6 by Susana on April 14, 2014 - 8:17 am
Hi colleagues, its great paragraph about cultureand completely defined, keep it up all the time.
#7 by celine on September 1, 2015 - 11:27 pm
Many Good reasons to Search for a Reading Centre
#8 by Lora on April 9, 2016 - 3:41 am
Heya terrific blog! Does running a blog such as this take a massive amount work?
I have virtually no knowledge of computer programming however I
was hoping to start my own blog soon. Anyways, if you have any
ideas or techniques for new bblog owners please share. I know this
is off subject however I just needed to ask. Thanks!
#9 by Rubi Henwood on July 19, 2019 - 2:58 pm
Hi there everybody, here every one is sharing these experience, therefore it’s nice to read this website, and I used to pay a quick visit this website everyday.|