•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Extract data from Power Query
Our take
Extracting specific data from PDFs, especially when dealing with invoices, can be a challenging task. Power Query (PQ) offers powerful tools, but it’s crucial to navigate its features effectively to avoid unnecessary complications. If you're encountering difficulties in isolating the numbers you need, rest assured that with the right approach, you can streamline the process.
Hi, I've been fighting with powerquery (pq) bc I need to extract specific numbers from a pdf, it has hundreds of pages and the numbers are always at the same spot, but they're not spreadsheets, they're invoices.
I've tried pq but it makes nonsense sheets trying to convert the text to a normal sheet, but I can't find how to keep just the number I need and toss the rest of the info
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#financial modeling with spreadsheets#big data management in spreadsheets#rows.com#Excel alternatives for data analysis#natural language processing for spreadsheets#AI-native spreadsheets#Excel compatibility#google sheets#predictive analytics in spreadsheets#cloud-native spreadsheets#Excel alternatives#generative AI for data analysis#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions