•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Tools for exporting data from PDF to Excel
Our take
Hi everyone! I recently started a new job where extracting data from various PDFs, like invoice numbers and totals, is a significant part of my role. I need to input this information into a large Excel master file that serves as a registry for other documents. I'm looking for tools that can streamline this process and reduce the repetitive 'copy-paste' task. While I’ve seen suggestions for Power Query, I’m unfamiliar with it and would appreciate recommendations for more user-friendly alternatives. Thank you!
Hi everyone! I started a new job a few weeks ago and a big part of my role involves extracting data from numerous PDFs (e.g., invoice numbers, amounts, total packages, etc.) and entering them into a massive Excel master file. This file acts as a registry and the foundation for other documents. I’m looking for something that saves me from doing 'copy-paste' all day, hundreds of times over. Browsing this group, I noticed some people suggest Power Query for similar tasks, but I’m not familiar with it and would have to learn it from scratch. Does anyone have any tools to recommend, perhaps something more user-friendly than Power Query?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- PDF to Excel Data ExtractionI’m currently working on vendor quotes, and we handle a large number of SKUs. In the PDF files, some items are sometimes entered as duplicates. What I’d like to do is extract all the line items into an Excel file so I can easily sort and identify duplicates. I want this process to be automated, but I’m not sure where to start. I’ve tried using Copilot prompts, but the results are inconsistent, sometimes not all items are pulled correctly. Because of this, I’d like to create a tool that can automate the extraction without relying on prompts or Copilot. I know, I can use Power Query for this one but can you recommend a YouTube tutorial I can watch to learn for this specific tool I want to create? Thank you all so much for your help. submitted by /u/todd_lerrrr [link] [comments]
- Anyone else still copying invoice data from PDFs into spreadsheets?I’m talking to people who receive supplier invoices in PDF and still have to manually extract due date, total, taxes, items, etc. I’m considering a tiny tool that uploads PDFs, extracts the fields, lets you verify them fast, and exports to CSV/Sheets. Would that actually save you time, or is the pain somewhere else? submitted by /u/Zekkeu [link] [comments]
- Extract data from Power QueryHi, 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 submitted by /u/sbeveguy [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#data visualization tools#data analysis tools#big data management in spreadsheets#Excel compatibility#big data performance#Excel alternatives#self-service analytics tools#conversational data analysis#business intelligence tools#rows.com#collaborative spreadsheet tools#real-time data collaboration#intelligent data visualization#enterprise data management#data cleaning solutions#financial modeling with spreadsheets#data extraction