I can make Microsoft Excel open up a semicolon separated value text file by placing "sep=;" at the beginning of the file. Then upon double clicking, it properly separates every column and row into the correct cells. However, the issue with this is that it makes the file unusable to other programs that aren't expecting the "sep=;" line at the very beginning. But if I remove this, then Excel opens it and doesn't properly map the values to the correct cells (a single cell will have several entries, including the semicolon separator).
I can always use the "Data -> From Text/CSV" feature to import the file, but this is slow and takes a while, especially if I just want to quickly view the contents.
Is it possible to make Excel correctly display the data in a semicolon separated value file without changing the content of the file when double clicking on it? Or am I out of luck?
I am also OK with changing the file extension to something unused if necessary, such as ".scsv" instead of ".csv" if this will require some registry tweaks. The other programs that require the semicolon separated value files don't care about the extension, only the file content.