SOLVED
Home

I can't find the right import language for csv files.

%3CLINGO-SUB%20id%3D%22lingo-sub-308372%22%20slang%3D%22en-US%22%3EI%20can't%20find%20the%20right%20import%20language%20for%20csv%20files.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308372%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EAlways%20a%20problem%20for%20danes.%20When%20import%20i%20get%20a%26nbsp%3B%C3%83%C2%B8%20instead%20of%20%C3%B8.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20table%20to%20convert%20correct.%20I%20use%20Western%20europe%2C%20but%20tried%20all%20the%20standard%20i%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20do%20I%20have%20to%20make%20a%20macro%20to%20change%20all%20after%20import..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-308372%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EImport%20format%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309588%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20the%20right%20import%20language%20for%20csv%20files.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309588%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309460%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20the%20right%20import%20language%20for%20csv%20files.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309460%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%3C%2FP%3E%3CP%3EYou%20nailed%20it.%20Thanks...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-308938%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20the%20right%20import%20language%20for%20csv%20files.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308938%22%20slang%3D%22en-US%22%3E%3CP%3EI'll%20try%20that.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-308383%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20find%20the%20right%20import%20language%20for%20csv%20files.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308383%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20try%2065001%20(UTF-8)%20encoding%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
o0McArt0o
New Contributor

Hi,

Always a problem for danes. When import i get a Ã¸ instead of ø. 

 

Is there a table to convert correct. I use Western europe, but tried all the standard i excel.

 

Or do I have to make a macro to change all after import..

4 Replies
Solution

Did you try 65001 (UTF-8) encoding?

I'll try that. Thanks

Hi Sergei

You nailed it. Thanks...

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies