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

Extracting data from PDF in an organized manner?

Hi all,

I'm looking to parse information from different formats of PDFs (Basically Different Vendor quotes) into excel, so far I was using PDF to excel converter and then copying this data into my main file and then using macros to only select fields of the required data. The process is really repititive and takes up a lot of time which adds more pressure when I've got deadlines. I need advice on how I can parse information into excel seamlessly from a PDF file.

Would really appreciate your suggestions.

I know Power Automate is a beautiful solution but currently my company is not going to get this subscription in the near future, so I really need an effective solution to manage my work load.

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#real-time data collaboration
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#real-time collaboration
#PDF
#excel
#data extraction
#PDF to excel converter
#vendor quotes