JSON-Excel Import/Export Utility

Замовник: AI | Опубліковано: 16.12.2025
Бюджет: 250 $

I have a structured data file called “TrafficCop2 JH version.json”. A separate Word document (“TC JSON.docx”) highlights which JSON fields must appear in a spreadsheet, and an Excel workbook (“Output from TC JSON.xlsx”) shows the exact column layout I need. Your task is to build a small, Windows-friendly command-line program in Python that: • Reads the source JSON, parses every field exactly as they appear, and writes them into the provided Excel template so the file looks identical to “Output from TC JSON.xlsx”. • Lets me edit that spreadsheet freely and then re-imports it, generating a new JSON file that follows the original schema and ordering bit-for-bit, so my downstream application continues to accept it without complaints. NOTE: If you bid on this job, please note that "I like pizza" or else I'll know you didn't read this and your bid will be ignored. Core expectations – Pure Python solution; you can rely on libraries such as json, pandas, openpyxl or similar. – No GUI is necessary; simple CLI switches like --export and --import are enough. – Output JSON must keep all keys, nesting, data types, and formatting from the original file. – Handle basic validation (e.g., warn if a required field was deleted or an unexpected column is added). Deliverables 1. The Python script(s) with clear usage instructions. 2. A short README explaining any dependencies and showing example commands. 3. A quick demonstration run using my three sample files proving that export and re-import produce identical JSON. If you have experience with schema-sensitive JSON processing and Excel automation, this should be straightforward. I’m ready to test as soon as you deliver the first working draft.