Create a convertible XML excel file with hospitality data

Job ID: 34677856

Budget: €8 – €30 EUR

I own hospitality business Italy. Every 3 months I am required to fill data about my guest into a website provided by National Statistics (Istat).

Data can also be massive uploaded importing an xml file.
I can download an excel file from my hospitality software with most of the data.

I need to create an excel file that can be saved as an xml an imported into the website.

The authority has send me a manual (in Italian, but short and easy to be google translated) about how to write the xml file.

Your assignment:
-create an excel that I can easily fill out every 3 months. with the data I copy from my reservations software.
Then I save an xml and import it into the website.


Attached:
-screenshot of the data form need to filled out manually every 3 month. not all them are necessary (1)
-screenshot of the uploading page (2)
-the excel I download from the reservation software (3)
-Manuals provided by the authority about ho the xml has to be written (TracciatoXML) (TracciatoWeb)

Thank you for your attention.
Best Regards
Related categories: XML Data Processing Data Entry Excel MySQL