When saving an excel file as a csv file it saves the different columns information in one line

%3CLINGO-SUB%20id%3D%22lingo-sub-2542830%22%20slang%3D%22en-US%22%3EWhen%20saving%20an%20excel%20file%20as%20a%20csv%20file%20it%20saves%20the%20different%20columns%20information%20in%20one%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2542830%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20trying%20to%20save%20an%20Excel%20file%20as%20a%20.csv%20file%20for%20import%20on%20the%20computer%2C%20it%20places%20all%20the%20columns'%20information%20in%20one%20column.%20I%20did%20not%20have%20this%20problem%20before.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20advise%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELouisa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2542830%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2542987%22%20slang%3D%22en-US%22%3ERe%3A%20When%20saving%20an%20excel%20file%20as%20a%20csv%20file%20it%20saves%20the%20different%20columns%20information%20in%20one%20line%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2542987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1102303%22%20target%3D%22_blank%22%3E%40Louisaplouisapot%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20csv%20file%20is%20probably%20OK%2C%20but%20I%20suspect%20there%20is%20a%20discrepancy%20between%20the%20list%20separator%20character%20on%20the%20source%20computer%20and%20the%20target%20computer.%20For%20example%2C%20if%20the%20source%20computer%20uses%20a%20comma%20as%20list%20separator%2C%20it'll%20place%20that%20between%20the%20data.%20If%20the%20target%20computer%20uses%20a%20semicolon%20as%20list%20separator%2C%20it%20won't%20recognize%20the%20comma%20and%20dump%20everything%20into%20the%20first%20column.%3C%2FP%3E%0A%3CP%3EYou%20can%20either%20ensure%20that%20both%20computers%20use%20the%20same%20list%20separator%20(it%20is%20a%20system%20setting)%2C%20or%20use%20Data%20%26gt%3B%20Text%20to%20Columns%20to%20split%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

When trying to save an Excel file as a .csv file for import on the computer, it places all the columns' information in one column. I did not have this problem before.

 

Can you please advise?

 

Louisa

1 Reply

@Louisaplouisapot 

The csv file is probably OK, but I suspect there is a discrepancy between the list separator character on the source computer and the target computer. For example, if the source computer uses a comma as list separator, it'll place that between the data. If the target computer uses a semicolon as list separator, it won't recognize the comma and dump everything into the first column.

You can either ensure that both computers use the same list separator (it is a system setting), or use Data > Text to Columns to split the data.