I tried downloading a sample data from both the HHI server as well as the OCHA server and it seems to be working fine for me. Would you mind following the instructions as outlined in the image below and see if it works for you:
The dataset downloaded is then seen as follows:
Please note: if you download your dataset from the KPI as XLS (legacy) format or if you downloaded your dataset from the project (legacy), you will see the dataset as follows (maybe this is what you are seeing):
Please let us know if you are referring to something else. Also try to describe the steps you followed so that we could have a closer look at it.
Have a great day!