Excel-to-XML Converter Needed
Budget: $10 – $30 CAD
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, Python, 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.
Your task is to take the spreadsheet I provide and give me a repeatable way—VBA, Python, 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.