Any way to estimate the required space for a SQL dump file?
I have dealt with questions like this in both directions

Mar 20, 2013 : How can I determine the size of a dump file prior to dumping?
May 21, 2012 : How large will a MySQL database be relative to the dump file?

Your question is a little different because you did not give anything about the target MySQL Instance (what Storage Engine will be used, which columns are TEXT/BLOB, what indexing is needed for your data, etc.)
IMHO the most straightforward way I can think of is the following
METHOD #1
Write some Perl/Python script to sum the length of all XML tag delimiters. Subtract the sum you get from the length of the file. That would essentially be the size of a CSV file less delimiters. This would be the bytes of the raw data.
METHOD #2
Do METHOD #1 and also take the count of all XML tag delimiters and add that count to the result of METHOD #1. That would like adding commas back into a CSV file. This make be closer   in size to an actual CSV should you print the output to such a file.