Jump to content

Problems to open .csv in excel


st0le
 Share

Recommended Posts

What happens exactly?

Which version of excel are you using? (Older versions have problems with utf8)

If it is sufficient, you can use notepad++

 

Cheers

Hello,

 

I'm using excel 2010, I think that I used it few month ago for edit that.

 

I'll try with notepad++ when I'm in home.

 

Thanks so much.

Share this post


Link to post
Share on other sites

What happens exactly?

Which version of excel are you using? (Older versions have problems with utf8)

If it is sufficient, you can use notepad++

 

Cheers

Hello,

 

Sorry for delay.

 

I did with notepad++ and it opens like:

 

M79zyGM.png

 

In excel is open like this:

 

fEANnmj.png

 

Do you know how can I do?

 

Cheers,

Share this post


Link to post
Share on other sites

Hi stOle,

 

you have choosen the wrong delimiter. In Excel, if you import your csv-file you can choose the delimiter between the data-fields (think it's the second step) , you have to choose the semicolon ";" not the comma ","

 

regards

Whiley

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More