Excel-to-XML Converter Needed

I need to turn an Excel sheet that holds status and transaction data into a single XML text file so my website can import it without complaints. The site expects very specific, custom tags, and I’ll share a sample file plus the exact tag map and hierarchy you must follow. Your task is to take the spreadsheet I provide and give me a repeatable way—VBA, Macro based, Power Query, or any approach you prefer—to generate a UTF-8 XML file that matches the structure perfectly. The converter must: • read every row of the sheet, • map columns to the custom tags I supply, • preserve dates, numbers, and special characters exactly as entered, • output a clean XML file ready for immediate website import. Deliverables I expect: 1. A working script, macro, or template‐driven solution I can run any time the spreadsheet changes. 2. One sample XML file generated from my test sheet to prove the mapping is correct. 3. A brief, step-by-step note (plain text or PDF) showing me how to run the export. Once you’ve delivered, I’ll run the import on our staging site while you’re available on chat or a quick call, just to confirm everything parses correctly. Looking forward to seeing how you’ll streamline this conversion for me.

Projektin tunnus (ID): 40205628