Skip to main content

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

Now you can format your excel table to any style you desire.

 

 

 

Technical