Have you compared an XML file that you exported from AC, with the one that you got from Excel? I'm not sure, but I suspect the structure may be different.
I faced a similar problem when I experimented with creating my own classification system inside a spreadsheet. It worked (sort of) after I did a bit of manual copy-pasting into the structure that Archicad expected.