Usually when we copy a the content of table from pdf to word and excel, the format will be plain not formatted as a table. This post will show how to overcome this problem.
Step by step
1. Open PDF file, select only the content of the table, excluding the table header. And make sure the number of column is the same for every row you copy.
2. Paste to Word then select all text, -> tab Insert -> Table -> Convert Text to Table…
3. On Convert Text to Table window -> choose Other option -> on Separate text at, fill with blank space.
4. Final result
After formatted into table in Word, you can then copy to Excel.