Copying PDF Table to MS Excel Table
First thing you need is an Adobe Acrobat Pro or any Reader version that that will allow you to copy the table with formatting
1. Select the table area in the PDF. Right Click and Copy the Table with Formatting
2. Paste it to an Excel
3. You will soon see that the pasted Table cannot be formatted. Neither can you remove the format
Error: Merged Cells Cannot be formatted
4. To fix error at 3, select the entire range of the table in the copied excel using Ctrl+1 (Control plus One)
5. Click the Alignment Tab
6. Deselect the Merge