sipxstream Posted October 3, 2016 Share Posted October 3, 2016 Hi, if I have a database with 3000+ products from our supplier, is there any way of auto-formatting the data correctly to fit in the CSV without us having to copy/paste columns – or at least keep it to a minimum? If not, what would be the most efficient and quickest way of formatting data – is there some sort of macro that anyone knows of that we could use? 1 Link to comment Share on other sites More sharing options...
Daniel Patilea Posted October 4, 2016 Share Posted October 4, 2016 You can open the .csv file with Microsoft Office or Apache OpenOffice. This way you can manage the columns easier. Save the file with a special delimiter, "~" for example so the import run smoothly. 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