st0le Posted February 15, 2015 Share Posted February 15, 2015 Hello,I exported my products in .csv but when I open it with excel, it's open bad and I can't edit that.Anybody know what is the best way to open the file .csv for edit that?Cheers, Link to comment Share on other sites More sharing options...
Whiley Posted February 15, 2015 Share Posted February 15, 2015 , it's open bad... 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 Link to comment Share on other sites More sharing options...
st0le Posted February 16, 2015 Author Share Posted February 16, 2015 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. Link to comment Share on other sites More sharing options...
st0le Posted February 17, 2015 Author Share Posted February 17, 2015 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: In excel is open like this: Do you know how can I do? Cheers, Link to comment Share on other sites More sharing options...
Whiley Posted February 17, 2015 Share Posted February 17, 2015 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 Link to comment Share on other sites More sharing options...
jetx Posted February 18, 2015 Share Posted February 18, 2015 Or (windows) if you have mod which only exports or imports in the ; seperator you can go to control panel/ region and language/ additional settings/ list seperator and change it to either. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now