Ex41T/Excel-Data-Remake-Script — reverse-engineered prompt

Build me a simple Python tool that processes a WordPress order export in .xls format and turns it into a cleaner Excel file for packing and courier work.

It should let me pick the input file with a normal file dialog, then read the expected WordPress columns, remove repeated customer rows, clean product names by stripping HTML tags, and break product bundles like “Pakiet Klasyczny” into their individual items with quantities. It should also calculate total product weights from names like 150g, 500g, and 1kg, grouped into kilograms.

The output should be a new Excel workbook with three clear sheets, one for cleaned products, one for product weight totals, and one courier friendly delivery report with only the needed customer and address details. Please make the sheets easy to read with adjusted column widths and highlight rows that contain important phrases like “w kawałku”.

Keep it focused on this exact WordPress export format and make it easy for a non technical person to run.