PDF text to Excel spreadsheet?

[xunkn0vvnx]

I have a PDF document that I need exported to an Excel Spreadsheet. The problem is that the text and columns are all messed up so it doesn't display properly. Can anybody help? Thanks.

http://jcmfirstventure.com/travelleisure.pdf

[royUK]

You can try any number of online converters but I haven't found one that is successful with Excel

[xunkn0vvnx]

Did you take a look at the spreadsheet? The columns are unfortunately messed up and it doesn't align properly.

[MrShorty]

The data are not quite laid out in a way that makes it particularly easy to import into Excel. I think I would convert it manually, especially if there are only a few files like this to import into Excel.

1) Using the select & copy tools in your PDF reader, copy the desired text to the clipboard.
2) Paste text into Excel
3) Run "Text to Columns" command, probably use "fixed width" format. Select places for column breaks and parse the text.
4) Then you'll need to go through and clean up the text and rows and row breaks. This might best be done with worksheet functions like CONCATENATE().

Alternatively, you might choose to paste the data into a text editor (probably not Notepad) and put the data into a format which is easily imported into Excel (namely, each record is on a single row without carriage returns). Then paste and parse that text file into Excel.

And, FWIW, don't completely ignore the option of typing the data into Excel. I know it seems the least efficient and most tedious way to do it, but I've found myself many times spending more effort and energy trying to find an "easier" to do something when the tedious/less efficient approach would have been faster and easier.