Get data from csv file - "Get Worksheet As Collection (Fast)"

[DenizKarakapaln]

Hi   I'm having trouble to read data from a csv file and insert it correctly to a collection. It's like even the colums in the csv file is separated by ",", the action "Get Worksheet As Collection (Fast)" inserts one row in one colum in the collection. The exact same process/object works with a colleague.   If I make a workaround by converting the csv to txt and then to excel (now separated in colums) then the action "Get Worksheet As Collection (Fast)" inserts data in different colums in the collection.   The workaround should not be necessary - any suggestions for what goes wrong with the csv file?   Best reagards Deniz Karakaplan  

[AndreyKudinov]

Use Show action - means your excel opens csv this way. Find out why. May be locale specific.  Consider reading csv directly, although parsing csv has it's own caveats.