Hello @albano.haruni, I mean there are some modules which could help. It is for Python 3. More information here: [New Feature Preview] Python 3 Support Issue Thread
Look for example for “excel 2 json” or “Pandas DataFrame to json”. I have no experience yet, but I in my opinion it can help you.
You can find more information about Pandas here: https://jakevdp.github.io/PythonDataScienceHandbook/
Or you can build XML using IronPython: https://docs.python.org/2.7/library/xml.etree.elementtree.html
You can use Civil 3D to import Psets from XML: https://knowledge.autodesk.com/support/civil-3d/learn-explore/caas/CloudHelp/cloudhelp/2016/ENU/Civil3D-SurveyShape/files/GUID-25F75F92-3FDB-471D-A470-92A042E1E219-htm.html