It looks to me like you don't actually have the data divided into the columns and it's all in the first column with spaces between.
Great, thanks, so.... How do I divide it into columns? I'm not that good with Excel.
I would recommend to test with different export types in Excel like:
Tab-Divided txt files instead of csv or with different decoding.
When you have learned which is working fine, you can select this always in the future.
(There is also a possibility inside InDesign to change the type between tab separated text and CSV. In my experience it depends very much on the Excel version which would work. Microtrash has a bad history in localizing their programs, e.g. here in German, in numbers we write coma instead of a point, a point of a coma, so decided MS to exchange it every where on the Mac version with the outcome, that CSV files are not coma separated but dot separated and are not working on any data base import. So I can only use tab separated files.)
I'm exactly in the same situation! New to data merge too...
I've solve the problem with the excell exporting to TXT tab separated. I also need to close excell before use the file in indd...
Thank you everybody!
Saving as tab delimited helped, everything works perfectly! In the meantime, I found the problem: Excel 2013, for some reason, saves .csv with semicolons instead of colons, which InDesign does not interpret as needed. Here is an article on the topic, maybe somebody finds it useful in the future:
How Excel saves CSV files depends on the version, localization of Excel, localization of the OS, and OS itself. Each of these combination could result in a different outcome.