Sometimes (especially if you are located in the US) when you make an XLS export from Iconosquare into Excel, the data gets scrambled due to regional settings within Excel.
In order to make the mixed-up data appear in separate cells in your Excel file, you need to:
- Right click on your file
- Choose "Open With EXCEL"
- Once your file is opened, click on Column A and select the whole column at once
- Click on the "DATA" tab in the menu
- Select "Text to Columns"
- Click on "Delimited" and "NEXT"
- Select the ";"(semicolon) under delimiter options and "NEXT"
- Click "FINISH"
This can also happen with CSV files. In this case, you should open the report with a different program (if you are using a Mac we would recommend Numbers) before exporting it to Excel.