Excel API data query - populates into a single column
It appears you are attempting to import data in JSON format which is not supported by Excel.

Doing a cursory search, I was able to find an Excel plug-in that converts JSON to XLS (Free).

I have not used this myself, so YMMV.