Python XML Scraper to Excel

A Python script is needed to pull text-only data from a website / mobile-app endpoint that returns XML and drop everything into a single Excel worksheet, with each category neatly separated into its own column. The source exposes only XML responses, so parsing must rely on built-in xml.etree or an equivalent library such as lxml; once parsed, the data should be pushed to Excel via pandas or openpyxl.

The script should:
• Retrieve the full XML payload from the target URL or API, following any necessary headers or authentication I provide.
• Map every relevant XML tag to a clearly named column in one worksheet, preserving order and encoding.
• Export a clean .xlsx file in one run and overwrite or version files automatically (configurable).

Deliverables:
1. Well-commented .py file(s).
2. Sample Excel output proving the layout.
3. Brief readme explaining set-up, dependencies, and how to repoint the script to new URLs or categories.

Acceptance criteria: running `python main.py` on my machine should recreate the sample workbook without manual edits.