I have a table from PDF and how do I export this to Excel? I like Iain Shaw ‘s answer. There are alternatives which may suit you, depending on. how technically savvy your are, how little you like spending money, how often you are going to do this, and how big the table is. If I was going to copy a table like the example (which is pretty simple and small) then I would do the following (I’m using Windows and Pdf To Excel Conversion Reader). It depends on the “text” being understood by Pdf To Excel Conversion . In Pdf To Excel Conversion Reader, “Swipe” the table so the text is highlighted. Copy the text to the clipboard (Cntrl-C). You _can_ paste (Cntrl-V) the text into Excel but you will find that you have lost the columns. Instead, paste (Cntrl-V) the text into a text editor (I use Notepad) but you can use Word as well. Edit the text to add a TAB character each time you need to move to the next column. Now copy your edited text onto the clipboard (Cntrl-C again). Paste it into Excel (Cntrl-V). You will find that your text is in the right columns. I’ve just tried this out and I know it works (for me anyway ;-) ) If you are going to do this on a large table, experiment with a small sample so that you understand the technique first. Beware! There are some gotchas, like if your text contains certain characters (eg “/”) then Excel may guess that you mean dates when you don’t. You can fix this either in the intermediate text file or by adjusting the formatting of the affected cells in Excel.
If you're copying and pasting a table which I know you don’t have, and you do have the Excel macros, you might have noticed that it seems to not work so well. This is because I know where most of you are coming from! I have been working on this at the time of writing this article and have found that the best way to explain it is to show you what it looks like — which would require me to go to a bit of detail. I would love to see how many of you have worked through the article (or if anyone wants to make suggestions — feel free to email me), but know what I mean. First off, you want to use Microsoft Excel to do this. I am using a 64bit version, so 64bit Excel is required for the PDF To Excel Conversion. Here.