•1 min read•from 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!!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#rows.com
#PDF
#Excel
#data transformation
#Get Data From PDF
#formatting issues
#tables
#conversion
#Adobe
#copy and paste
#multiple pages
#data extraction