Python Excel eBay Data Tool

I need a single Excel 365 workbook that talks directly to the eBay Trading API through Python. Users will paste any number of ItemIDs into column A, click “Download Data”, and watch the sheet auto-populate Title, full HTML Description, and QuantitySold for each line. A second button, “Export CSV”, must create a file ready for a bulk Revise upload, containing the fixed Action = Revise field plus the ItemID, Title, and Description pulled a moment earlier.

The connection layer can rely on the official eBay SDK, the REST endpoint, or simple requests if that keeps the file lightweight; I only care that it is written in clean, fully visible Python code—no password protection or hidden modules. Typical libraries such as xlwings, openpyxl, pandas, and requests are perfectly fine.

Deliverables
• Excel 365 workbook with two in-sheet buttons wired to Python callbacks
• Well-commented .py or embedded xlwings VBA stub so I can see and edit every line
• Working CSV export that mirrors the on-screen data exactly
• Quick setup notes covering any required Python environment steps and eBay App credentials

Acceptance criteria
• I enter at least 50 ItemIDs, click once, and the data returns without manual refreshes
• Descriptions remain intact HTML, not truncated or reformatted by Excel
• The exported CSV imports into eBay File Exchange (or equivalent) without errors
• All functionality tested on a Windows 10 machine running Excel 365