Different format of .csv file in Excel online VS Excel desktop app

%3CLINGO-SUB%20id%3D%22lingo-sub-2875157%22%20slang%3D%22en-US%22%3EDifferent%20format%20of%20csi%20file%20in%20Excel%20online%20VS%20Excel%20desktop%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2875157%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20good%20afternoon!%20Does%20anyone%20know%20why%20when%20I%20open%20a%20.csv%20file%20in%20Excel%20online%20it%20shows%20in%20one%20way%20(the%20correct%20one%20actually)%20but%20when%20I%20try%20to%20open%20the%20same%20file%20in%20Excel%20desktop%20app%2C%20it%20returns%20incorrect%20format%20(please%20see%20the%20screenshot%20-%20the%20bigger%20excel%20is%20Online%20version%20and%20the%20smaller%20is%20the%20desktop%20app)%3F%20I%20have%20tried%20in%20MacOs%2C%20Windows%2010%20%2B%20office%2C%20Windows%207%20%2B%20office...%20all%20same%20results.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2875157%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello everyone, good afternoon! Does anyone know why when I open a .csv file in Excel online it shows in one way (the correct one actually) but when I try to open the same file in Excel desktop app, it returns incorrect format (please see the screenshot - the bigger excel is Online version and the smaller is the desktop app)? I have tried in MacOs, Windows 10 + office, Windows 7 + office... all same results.

1 Reply

@barreda1984 

Perhaps you have different regional setting for the cloud (comma as list separator) and for computer OS:s (semicolon as list separator)