Excel

This spreadsheet, data taken from a CSV file, demonstrates techniques in data cleaning. Tools such as Text to Columns, CONCATENATE, and XLOOKUP were used to organize and refine the data. CONCATENATE and XLOOKUP were particularly important for formatting the data correctly for XML output, helping to create information hierarchy with accurate nesting of elements.