Opening csv file and keeping data intact

%3CLINGO-SUB%20id%3D%22lingo-sub-2927973%22%20slang%3D%22en-US%22%3EOpening%20csv%20file%20and%20keeping%20data%20intact%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2927973%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20stop%20Excel%20from%20making%20unnecessary%20changes%20to%20data%20when%20I%20open%20a%20csv%20file%2C%20this%20is%20a%20small%20sample%20of%20a%20csv%20file%20I%20wish%20to%20open%20(the%20file%20is%20opened%20just%20by%20double%20clicking%20on%20the%20file%20in%20explorer%20-%20I%20want%20to%20keep%20the%20operation%20simple%20and%20not%20do%20any%20importing%20of%20files%20into%20Excel%3C%2FP%3E%3CP%3E16%3A17%3A38%2C98W%2CAE0679%2C00-0174%2CC-17A%20%2CKHUA%2CKHOP%3CBR%20%2F%3E16%3A23%3A36%2C98W%2CAE0569%2C86-0012%2CC-5M%20G%2CKCEF%2CKCEF%3CBR%20%2F%3E16%3A33%3A39%2C25E%2CAE1472%2C07-7180%2CC-17A%20%2CETAR%2CEGUN%3CBR%20%2F%3E17%3A05%3A40%2C98W%2CAE080D%2C99-0167%2CC-17A%20%2CKPAM%2CKDOV%3C%2FP%3E%3CP%3Eand%20this%20is%20what%20I%20get%20when%20it's%20opened%20in%20Excel%3C%2FP%3E%3CTABLE%20width%3D%22531%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3E16%3A17%3A38%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E98W%3C%2FTD%3E%3CTD%20width%3D%2283%22%3EAE0679%3C%2FTD%3E%3CTD%20width%3D%2292%22%3E00-0174%3C%2FTD%3E%3CTD%20width%3D%2286%22%3EC-17A%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2278%22%3EKHUA%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EKHOP%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E16%3A23%3A36%3C%2FTD%3E%3CTD%3E98W%3C%2FTD%3E%3CTD%3EAE0569%3C%2FTD%3E%3CTD%3E86-0012%3C%2FTD%3E%3CTD%3EC-5M%20G%3C%2FTD%3E%3CTD%3EKCEF%3C%2FTD%3E%3CTD%3EKCEF%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E16%3A33%3A39%3C%2FTD%3E%3CTD%3E25E%3C%2FTD%3E%3CTD%3EAE1472%3C%2FTD%3E%3CTD%3EJul-80%3C%2FTD%3E%3CTD%3EC-17A%26nbsp%3B%3C%2FTD%3E%3CTD%3EETAR%3C%2FTD%3E%3CTD%3EEGUN%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E17%3A05%3A40%3C%2FTD%3E%3CTD%3E98W%3C%2FTD%3E%3CTD%3EAE080D%3C%2FTD%3E%3CTD%3E99-0167%3C%2FTD%3E%3CTD%3EC-17A%26nbsp%3B%3C%2FTD%3E%3CTD%3EKPAM%3C%2FTD%3E%3CTD%3EKDOV%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Enote%20that%2007-7180%20in%20the%20csv%20file%20has%20been%20changed%20to%20Jul-80%20-%20if%20I%20try%20to%20make%20changes%20to%20the%20formatting%20I%20loose%20the%20original%20data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2927973%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2928089%22%20slang%3D%22en-US%22%3ERe%3A%20Opening%20csv%20file%20and%20keeping%20data%20intact%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2928089%22%20slang%3D%22en-US%22%3EDon't%20open%20CSV%20but%20import%20CSV.%20Best%20choice%20is%20Power%20Query.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

How do I stop Excel from making unnecessary changes to data when I open a csv file, this is a small sample of a csv file I wish to open (the file is opened just by double clicking on the file in explorer - I want to keep the operation simple and not do any importing of files into Excel

16:17:38,98W,AE0679,00-0174,C-17A ,KHUA,KHOP
16:23:36,98W,AE0569,86-0012,C-5M G,KCEF,KCEF
16:33:39,25E,AE1472,07-7180,C-17A ,ETAR,EGUN
17:05:40,98W,AE080D,99-0167,C-17A ,KPAM,KDOV

and this is what I get when it's opened in Excel

16:17:3898WAE067900-0174C-17A KHUAKHOP
16:23:3698WAE056986-0012C-5M GKCEFKCEF
16:33:3925EAE1472Jul-80C-17A ETAREGUN
17:05:4098WAE080D99-0167C-17A KPAMKDOV

note that 07-7180 in the csv file has been changed to Jul-80 - if I try to make changes to the formatting I loose the original data

 

Thanks

 

Paul

1 Reply
Don't open CSV but import CSV. Best choice is Power Query.