umur957/hiring-cafe-job-scraper ? reverse-engineered prompt

Build me a Python tool that searches Hiring.cafe for jobs using their official API, then saves the results locally. I want to type in a search term like Python Developer, Remote, or Data Scientist, and have it pull back matching jobs with pagination handled automatically, clean up the job descriptions, and save everything to a JSON file.

Then add a second script that takes that JSON file and turns it into Excel files. If the data is large, split it into multiple Excel files so each one stays manageable, and also create a summary workbook with basic stats and a simple breakdown of the files. Please include good error handling for network issues, bad JSON, rate limiting, and Excel encoding problems, and make sure the output is easy to read.

Use the current Python packages that fit this kind of project, and if you need to, look up the current API or library docs online before finishing.