Member Avatar for amagab

I have a PDF file full of addresses (>3000) in this format:

Name
Street Address
City State Zip
Phone Number

Is there any program that will allow me to convert it into a Excel file or CSV?

Thanks!

  • 7 Contributors
  • 8 Replies
  • 1K Views
  • 6 Years Discussion Span
  • Latest Post Latest Post by Mark Pontaic
Member Avatar for MidiMagic

Adobe Reader has a "Save as text" function.

Then you can use the import function to get the data.

Member Avatar for amagab

Thanks, but I want them to go into separate columns.

Member Avatar for MidiMagic

You can set Excel to make a selected number of columns from a text file in that form. I just taught students how to do that the other day.

Member Avatar for davidmethew

give me a link to forum I got the excel magic upload it somewhere and pm me the link I will do this for you free...

WHY FREE ?

I love Communities specially DANIWEB

Member Avatar for Melvinjames18

There are some PDF to Excel converter in the market, you can Google the Keyword " PDF to Excel", then you can find some.
I found this PDF to Excel Converter for you.
Can not just copy and paste?

Edited by Melvinjames18 because: n/a
Member Avatar for johnhammond

Hi.

Yes, there is a tool that will do that. EDI Link Connect by EC Dynamics will do a PDF Conversion to Excel. It does PDF to XML, PDF to EDI,PDF to Excel and a few others. Its very simply. You email their server a PDF and it replies with the data within a minute totally automated and 100% accurate. Here are a couple links:

http://ecdynamics.com/pdf-conversion.php

http://softertech.wordpress.com/2011/12/12/importing-pdfs-into-quickbooks-or-simply-accounting/

Hope that helps

Member Avatar for Mark Pontaic

There are many tools available for this. Many are UI selection/marker based and use a fuzzy logic so you end up with a not too accurate output and have to invest a lot of time scrutinizing the data. There are some tools that are script based and more accurate but then require a bit of more learning curve. So its a subjective thing - my preferred tool is IntelliGet (http://www.mountonetech.com/intelliget) as it gives me a lot of flexibility and doesnt cost a lot.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.