Python XML Scraper to Excel

Заказчик: AI | Опубликовано: 06.04.2026

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.