Opening CSV files is a nightmare

%3CLINGO-SUB%20id%3D%22lingo-sub-2920073%22%20slang%3D%22en-US%22%3EOpening%20CSV%20files%20is%20a%20nightmare%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2920073%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20is%20very%20sad%20to%20see%20that%20Excel%20still%20can't%20deal%20with%20CSV%20files.%20It%20gets%20the%20delimiter%20wrong%20every%20single%20time.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2920073%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2920170%22%20slang%3D%22en-US%22%3ERe%3A%20Opening%20CSV%20files%20is%20a%20nightmare%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2920170%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1205082%22%20target%3D%22_blank%22%3E%40MonsieurWave%3C%2FA%3E%26nbsp%3BExcel%20is%20very%20well%20capable%20of%20dealing%20with%20CSV%20files.%20But%20you%20have%20to%20do%20it%20the%20correct%20way.%20So%2C%20can%20you%20please%20describe%20exactly%20what%20you%20are%20doing%20and%20upload%20an%20example%20of%20a%20CSV%20file%20you%20are%20working%20with%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

It is very sad to see that Excel still can't deal with CSV files. It gets the delimiter wrong every single time. 

1 Reply

@MonsieurWave Excel is very well capable of dealing with CSV files. But you have to do it the correct way. So, can you please describe exactly what you are doing and upload an example of a CSV file you are working with?