exporting, importing and changing csv files in Excel 2016 to use them later in Outlook 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-2323304%22%20slang%3D%22en-US%22%3Eexporting%2C%20importing%20and%20changing%20csv%20files%20in%20Excel%202016%20to%20use%20them%20later%20in%20Outlook%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323304%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3CBR%20%2F%3EI%20am%20trying%20to%20make%20changes%20and%20corrections%20in%20my%20agenda%20stored%20in%20Outlook%202016%20via%20Excel.%3CBR%20%2F%3EOnce%20exported%20data%20into%20a%20CSV%20file%20(HRO3a.csv)%2C%20I%20split%20data%20into%20columns%20and%20save%20it%20as%20a%20csv%20utf-8%20file%20(HRO3b.csv).%20Then%20I%20correct%20data%20and%20save%20it%20again%20as%20a%20csv%20utf-8%20file%20(HRO3c.csv).%3CBR%20%2F%3EHowever%2C%20when%20I%20try%20to%20import%20the%20data%20once%20corrected%20into%20Outlook%2C%20it%20does%20not%20recognise%20any%20of%20the%20columns.%3CBR%20%2F%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3EThank%20you%2C%20Juan.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2323304%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2345810%22%20slang%3D%22en-US%22%3ERe%3A%20exporting%2C%20importing%20and%20changing%20csv%20files%20in%20Excel%202016%20to%20use%20them%20later%20in%20Outlook%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2345810%22%20slang%3D%22en-US%22%3ESolved%20via%20regional%20settings%2C%20changing%20decimal%20separator%3C%2FLINGO-BODY%3E
Frequent Contributor

hi,
I am trying to make changes and corrections in my agenda stored in Outlook 2016 via Excel.
Once exported data into a CSV file (HRO3a.csv), I split data into columns and save it as a csv utf-8 file (HRO3b.csv). Then I correct data and save it again as a csv utf-8 file (HRO3c.csv).
However, when I try to import the data once corrected into Outlook, it does not recognise any of the columns.
Any suggestions?

Thank you, Juan.

1 Reply
Solved via regional settings, changing decimal separator