On Feb 18, 2008 12:02 PM, Edward Kay <edward@xxxxxxxxxx> wrote: > > > On Mon, February 18, 2008 10:36 am, Jay Blanchard wrote: > > > [snip] > > > That's funny... MS defaults to tabs for a file whose extension is .csv > > > which is an acronym for (C)omma (S)eparated (V)alues. > > > [/snip] > > > > > > Welcome to Microsoft....where do we want you to go today? > > > > I think it defaults to whatever you last used, not to a specific choice. > > > > That would seem to be a possibility. I can quite happliy double-click a > .csv > file and have it open correctly in Excel. > > Yes. And Excel seems to prefer .txt for tab delimited. However, .txt is usually opened by Notepad by default, so you have to right-click and tell it to Open With... Excel. When I do this, it reads it as columnar data rather than a single column. Andrew
