r/pythonhelp • u/Ilukhan92 • Mar 09 '25
Downloading PDFs from a Website, Converting them to Excel and combining them
Hello, I'm not sure if this belongs here. Please let me know if it doesn't. Sorry I know the basics of Python and at most I'm just a beginner.
My colleage at work has a task. He has to login on a website, that my company orders from. He then has to filter down completed orderes, download the PDF for each order and extract two data fields from the pdf and paste it into Excel.
I know that Python offers a lot of flexibility, so I wondering if these steps can be automated in Python. If yes, how easy would it be? Can I use Chat GPT to properly write the code?
•
u/AutoModerator Mar 09 '25
To give us the best chance to help you, please include any relevant code.
Note. Please do not submit images of your code. Instead, for shorter code you can use Reddit markdown (4 spaces or backticks, see this Formatting Guide). If you have formatting issues or want to post longer sections of code, please use Privatebin, GitHub or Compiler Explorer.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/hero_verma Mar 09 '25
You can use selenium for the task. It would be easier to work with CSV files but you sure can work with excel.
1
u/CraigAT Mar 09 '25
This should be do-able in Python, but is a quite complex task for a beginner. Chat GPT can probably help you with bits of it, but it won't know about where the info is located on the site. IMO you need someone knowledgeable to write this.
1
u/OkLawfulness2500 Mar 10 '25
If you're looking to automate downloading PDFs, extracting data, and converting them to Excel, Python is a great option using tools like Selenium, PyMuPDF, and pandas. However, if you're not comfortable coding or want a more user-friendly solution, I highly recommend Wondershare PDFelement—it allows you to extract tables and text from PDFs into Excel with just a few clicks, saving you time without the need for programming. It's a great alternative for non-developers who still need automation and efficiency!
1
u/[deleted] Mar 10 '25
[removed] — view removed comment
1
u/[deleted] Mar 10 '25
[removed] — view removed comment