Covert xml structure of file

An xml file containing unsufficient field structure has to be converted in a new structure to be reimported to a new and beter structured mysql database. Many of the text fields are containing information which should be split in different fields of different types. Especially geoinformation is not split in separate fields. The database contains only some 160 records, so manually processing instead of writing a script is an option.