Python JSON Scraper to Excel

I’m looking for a clean-coded Python application that pulls product-detail JSON from an e-commerce site and turns it into a neatly formatted Excel workbook in one click.

Here’s what I have in mind:
• The script should call the site’s public JSON endpoint (or simulate the site’s own XHR requests if no open API exists), parse the response, and map fields such as SKU, title, price, availability, image URL, and category into columns.
• A single command—CLI or lightweight GUI—is enough, as long as it lets me paste or import the target URL and instantly receive the Excel file (.xlsx).
• The output file must preserve data types (numbers as numbers, dates as dates) and use sensible column headers.

I prefer Python because I’ll maintain the project myself later, so please stick to mainstream libraries—requests or httpx for fetching, pandas or openpyxl/xlsxwriter for the Excel conversion. Feel free to recommend extras like BeautifulSoup or playwright/selenium only if they solve a specific obstacle such as dynamic content behind JavaScript.

Deliverables
1. Well-commented .py source files
2. requirements.txt with pinned versions
3. A brief README explaining setup and usage
4. A sample Excel generated from live data for verification

Acceptance criteria
• Running “python main.py ” produces an Excel file with every product in the response accurately represented.
• No hard-coded credentials or paths; environment variables and relative paths only.
• Handles at least 5,000 products without crashing or corrupting the workbook.

If future pages or additional fields appear, the code structure should make it straightforward for me to extend the parser. Let me know your estimated turnaround and any clarifying questions so we can get started right away.