GANDT Ventures GmbH
Company Builder & Digital Consultancy

Author: Remco Livain

About Remco Livain

I am an entrepreneur at heart who has co-founded, developed and lead the international marketing teams of companies such as: GANDT Ventures, Westwing Home & Living (Rocket Internet), MIFLORA (Venture Stars), C-Date, Unleash12 and ENA-Trachten. I mentor the Nexussquared Blockchain (Fintech) Startups with regards to marketing, communication and prototyping. In my spare time I love do outdoors sports and ride my "rennvelo" up and down the Swiss Alps

How to fix UTF-8 issues in csv-files

This is one simple life hack for anyone who works with .csv files and excel. It can be tricky to fix encoding issues, especially with german characters (ö, ä ü). This quick tutorial shows you exactly how you can resolve this problem. The solution is a simple, but effective work around.

We first encountered this problem when exporting a product feed from one of our customers magento backend. Although the file did not seem to be corrupt and it worked in Notepad++, it did not seem to work well in Excel. The encoding issue made it impossible for us to use the product feed (see below).

How to fix UTF-8 issues in csv-files

Background information: What is a product feed? 

A Product feed is essentially a list of products in your shop. This list usually comes in the form of a .csv-file or .xml-file. Either one of the two can be used for up,-  and downloading product information in bulk. Many affiliate marketing publishers work with product feeds (such as Google Shopping, Amazon, or Awin).  

If you have any further questions about this life hack, or need some help with your own data-issues: feel free to reach out to us by using the contact form.

How do you know you are in control of your data?

Want to find out whether you are really in control of your own data? In this short YouTube-Video we dive into the topic of data ownership.

As a decisionmaker, Data Quality is probably the one topic that is holding you back most on a day to day basis. If you want to be able to judge whether data is truly clean, you need to know where it came from. In our opinion you need to understand how data is collected to determine the quality of your data.

Therefore the first simple question we generally ask when we get started on a project is: Who do we need to go to for the insights that we need to be able to help you?  In this short video we dive into the answers we get and some straightforward implications of poor data ownership.

Continue Reading

3 ways your company can benefit from a digital back office

One of the services that we offer is that we work as the digital back office for SMBs. We use our expertise to fill the gaps wherever it is needed. There are a number of ways that you can use our expertise and with this post we would like to share three ways that your company can benefit from our digital back office service.

Process and workflow digitalization

Many aspects of a business can be streamlined and set up more efficiently. The digitalization of workflows is an area of business in which midsize companies and corporate can create tremendous efficiency gains.

We see that many midsize companies still have a lot of paperwork that is done manually. The digitalization of workflows and processes can lower employee distress and workload. Whereas time and efficiency gains help teams focus on that what they do best.

This part of our business involves both strategic help as well as digital project management. It could be that: you are introducing a new inventory management system within the company. And would like to streamline the in and outbound handling processes, but you do not have resources left on your team to manage the process. This is exactly where our digital project management back office service comes in. Continue Reading