How did you save the .csv? Does it open in a text editor?
While I had the excel file open I used 'save as' and chose the .csv option.
I also tried saving as .txt and both the Windows and MS-DOS csv options just in case any of those worked better but with no luck.
I just tried opening my .csv file in Textedit and it opened fine.
Does it have a header row with field names?
What encoding did you use for the .csv?
My excel document had a header row with field names
These just appear as the first items in the text edit view
I can't find where I set what encoding to use - I just chose from the dropdown menu for file types. Sorry I'm a bit ignorant in this area. Can you tell me where I set the encoding and what it should be? Your help much appreciated.
Aha! I saved as UTF-16 and successfully imported into my indesign file.