1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How can I put the data from a PDF into Excel properly?

I have a PDF document that is 13 pages long and I need the data in Excel.

I know I can use the Get Data From PDF option, but when I Transform the data, it always combines all the pages into one table.

Is there a way to keep each page its own Table but still all important onto one Excel Tab?

Using Adobe to convert the PDF to an Excel File also doesn’t work and messes with the formatting.

Highlighting the entire PDF, using copy with formatting, and pasting in excel also messes with the formatting. And highlighting it and then copying regularly also messes with the formatting.

Help please!!

submitted by /u/JMokus
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article