There's a better way to handle vendor quotes than the copy-paste marathon you're stuck in, and it starts with rethinking what your spreadsheet is for. The process you described, converting PDFs, copying data into a master file, then running macros to pull out the fields you actually need, isn't just repetitive. It's fragile. Every format variation in those vendor PDFs is a potential error, and every deadline tightens the squeeze. You're not looking for a faster converter. You're looking for a workflow that treats your data as data from the start.
The good news is that you don't need Power Automate to get there. You already have the right instincts: you know the destination should be a clean, structured spreadsheet. The missing piece is parsing logic that lives closer to the source. Instead of flattening each PDF into a generic table and then wrestling it back into shape, consider tools that let you define extraction rules based on patterns, like "grab the line after 'Total'" or "pull the value next to the part number." Modern AI-native spreadsheet tools can learn these patterns across documents, so the first time you process a new vendor format, you're teaching the system, not just fixing the output. That's a meaningful shift from manual cleanup to automated understanding.
What makes this practical for your situation is that you don't need to overhaul your entire stack or wait for IT approval. You can start small: pick one recurring vendor format, build a template that extracts the fields you need, and test it against a few real quotes. Once you see the extracted data land directly in your master file, the time savings compound with every new document. You're not replacing your macros entirely, you're moving the heavy lifting upstream, so the macros you do keep are simpler and more reliable. The pressure you feel now isn't because the work is hard. It's because you're doing the same manual steps over and over, and that's exactly the kind of repetition worth eliminating.
So, the practical takeaway is this: stop treating PDF conversion as the goal and start treating structured extraction as the goal. Look for a tool that lets you build reusable parsing rules, works offline or within your current permissions, and exports straight to Excel. You'll still need to review the first few outputs, but you'll be reviewing a system that learns, not a blank canvas you have to repaint every time. That's how you turn a chaotic pile of vendor quotes into a clean, dependable spreadsheet, and how you get your evenings back.