XSL Transform template - Convert asymmetric and nested XML files to CSV using Python3

I would like 3 XSLT layouts generated, for use in Python. These xsl files will be used to parse w/ ElementTree as follow: [login to view URL]([login to view URL]('[login to view URL]')) against my XML files and write out either a CSV file output or CSV List object and will be used for INSERT INTO database w pyodbc. I have several sample XML files, with staggered and nested elements, and repeating elements. The values needing to be extracted is the Text between the Field tags, set by the XML Attribute For example: <records> <Field property="txtField1">output1</Field> <Field property="txtField2">output2</Field> <Field property="txtField3">output3</Field> </records> <records> <Field property="txtField1">output1</Field> <Field property="txtField2">output2</Field> <Field property="txtField3">output3</Field> <Field property="txtField4">output4</Field> <Field property="txtField5">output5</Field> </records> I have tried using for-loops in Python, arrays, and lxml etree but I'm not getting a consistent output between 3 files and I have some more to process. Please create 3 separate XSL files to capture layout to transform DataForm1, DataForm2 and DataForm3, 1- Include ID (at beginning of every file //FileBegin/FileData/ID) 2- Allow output to return blank ("") if there is a missing attribute in repeating 3a- 1st XSL file to capture layout of ID and FormData1 attributes 3b- 2nd XSL file to capture layout of ID and FormData2 attributes 3c- 3rd XSL file to capture layout of ID and FormData3 attributes 4- Write Output to List, for preparing INSERT INTO database (MS SQL or AccessDB) 5- XSL file must contain very good code comments, so that I can generalize it for any similar files.