I'm writing an iOS 8 app that allows you to export data to be sent as an email attachment. Currently, I'm exporting the data to a CSV file with 7 columns and x number of rows. When I first created it, I used a
comma for delimiter, but that wasn't automatically detected by Excel - so I had to go to data-import as so on to read it correctly. I later changed it to a
semicolon, and now it reads correctly in Excel as well by simply double-clicking the file, but I'm not sure if this is the optimal delimiter.
What I need to know is what delimiter I should use that can be read by the majority of spreadsheet readers (including Excel) simply by double-clicking the file.