•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Anyone else still copying invoice data from PDFs into spreadsheets?
Our take
Are you still manually copying invoice data from PDFs into spreadsheets? Many people face the tedious task of extracting due dates, totals, taxes, and items from supplier invoices. Imagine a tool that simplifies this process by uploading PDFs, extracting essential fields, allowing for quick verification, and exporting to CSV or Sheets. This innovative solution could significantly reduce the time spent on data entry. But does this resonate with your experience, or do you find the challenges lie elsewhere? Let’s explore the possibilities together.
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?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- What repetitive data tasks are you still doing manually?Lately I've been working a lot with CSV files from different sources (banks, exports, random tools), and I keep running into the same issue: - inconsistent column names - messy date formats - duplicate / empty rows I end up fixing things manually more often than I’d like, even though I know it should be automatable. I’ve tried Power Query and some scripts, but it still feels like there are always edge cases that break the flow. Curious — what’s a repetitive data task you still do manually even though you know it shouldn’t be? submitted by /u/CodigoSinBugs [link] [comments]
- Looking to automate tedious emails that involve attaching a PDF. Could this be automated without external tools?hi Reddit I'm currently working in logistics, and part of our operations workflow is emailing out confirmation letters indicating due dates and type of work received, then shipping/delivery email which contains tracking number we ship out via 3PL, and also an attached invoice. The former is very easy to setup, I already have exported our database with email lists to send out confirmation letters easily. I also wan't to automate the latter, as due to the sheer volume of emails to send out, this soaks up an hour of time each day. Cutting down as much time as possible doing tedious tasks like these will help tremendously in scaling our operations. Is there any solution to this with just using Excel? submitted by /u/InquisitorKaine [link] [comments]
- 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]
- What’s the most frustrating part of cleaning messy Excel/CSV data?I’ve been working with a lot of messy spreadsheets lately (duplicates, inconsistent formatting, mismatched columns, etc.), and it feels like everyone runs into slightly different issues depending on their data. Some people rely on Power Query, while others do things manually, but I still see workflows break when the data isn’t consistent to begin with. Curious what tends to slow you down the most when cleaning or organizing data? Is it duplicates, formatting issues, inconsistent columns, or something else? submitted by /u/SmitleyData [link] [comments]