Double click csv-file

RedSnake · Mar 30th, 2004, 09:57 AM

Hi!

I'm trying to get my semi-colon delimitered file to automatically open in excel and have every piece of information (between two semi colons) inserted into one column each when I double-click the file in explorer.

It opens fine but then it puts all the data in the first column.

I don't want to make a macro that runs something similar to "text to column" when I start this kind of file, I'd prefer if there was another way.

What can I do?

All help greatly appreciated

Andrew Poulsom · Mar 30th, 2004, 11:10 AM

CSV stands for comma separated values, which is what Excel expects. If you changed the semi-colons into commas Excel should parse it for you automatically.

fairwinds · Mar 30th, 2004, 11:47 AM

Hi,

Not sure but seeing your flag... With Swedish settings, semicolon is delimiter. Could it be someting like file is saved with Swedish settings and you have American on your computer or the other way around?

You could try changing regional options in control panel.

RedSnake · Mar 30th, 2004, 12:22 PM

In the national settings semicolon is used as the delimiter.

I got a swedish OS and swedish version of Office.

fairwinds · Mar 30th, 2004, 12:49 PM

Well, guess I'm wrong then...

Try to change to commas as Andrew suggested.

Mar 30th, 2004, 09:57 AM	#1
RedSnake Join Date: Mar 2004 Posts: 2	Double click csv-file Hi! I'm trying to get my semi-colon delimitered file to automatically open in excel and have every piece of information (between two semi colons) inserted into one column each when I double-click the file in explorer. It opens fine but then it puts all the data in the first column. I don't want to make a macro that runs something similar to "text to column" when I start this kind of file, I'd prefer if there was another way. What can I do? All help greatly appreciated

Mar 30th, 2004, 11:10 AM	#2
Andrew Poulsom MrExcel MVP Join Date: Jul 2002 Posts: 31,599	Re: Double click csv-file CSV stands for comma separated values, which is what Excel expects. If you changed the semi-colons into commas Excel should parse it for you automatically.

Mar 30th, 2004, 11:47 AM	#3
fairwinds MrExcel MVP Join Date: May 2003 Posts: 8,445	Re: Double click csv-file Hi, Not sure but seeing your flag... With Swedish settings, semicolon is delimiter. Could it be someting like file is saved with Swedish settings and you have American on your computer or the other way around? You could try changing regional options in control panel. __________________ "Fair Winds and Following Seas"

Mar 30th, 2004, 12:22 PM	#4
RedSnake Join Date: Mar 2004 Posts: 2	Re: Double click csv-file In the national settings semicolon is used as the delimiter. I got a swedish OS and swedish version of Office.

Mar 30th, 2004, 12:49 PM	#5
fairwinds MrExcel MVP Join Date: May 2003 Posts: 8,445	Re: Double click csv-file Well, guess I'm wrong then... Try to change to commas as Andrew suggested. __________________ "Fair Winds and Following Seas"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode