Opening a CSV file

[hsmckee]

When I open a CSV file in Excel, all of the data is being placed in to one cell, with quotation marks around each value.

What settings do I need to change to have the file open correctly?

 

[jimrward]

i take it from the file description of CSV that the values are separated by a comma.

if this is the case then you need to change the default separator within windows to a comma or whatever the field separator is within your file, as follows

goto your windows control panel > Regional Options > Numbers Tab > List Separator and change this character

Excel will then open CSV and place in columns

 

[SilverCreek]

Hi Everybody, i am new here (not so new to excel itself)...


Any ID on how to change the delimitter from within excel-VBA ?

I think that it should be checked-out before trying to import csv's to get the right results (some csv's can be downloaded with other delimitters than ",") If one can set whatever value for the delimitter then you can use whatever is needed to download a csv in the right way)

Kind of like this:
If IsCsvSeparator <> "," then ChangeCsvSeparator(",")

Where GlobalVar WasCsvSeparator grabs the delimitter-value at startup

And where functions
IsCsvSeparator checks the current value
ChangeCsvSeparator change the delimitter to "whatever-needed-char" or restores the old one)

AnyOne?