I'm still not sure what your problem is exactly.
Could you perhaps provide an example url where I can see the data and try to explain what it is that's missing?
Can you use a web query from within Excel to pull in the dat directly? (Data, Get eternal data, new web query)