Hi,
I do a lot of importing exporting from my Ecommerce store. The import file (csv) contains HTML from the site. When I import these CSV's into Excel 2016 (Windows 10), I constantly see weird characters, such as (  ) or ( ’ ). I can do the find and replace easy enough, to remove these characters, but there has to be a better way? I have thought of using Google Sheets instead, as most say you will get cleaner data using that. However, given the amount of work I need to do on these files, Google Sheets is extremely slow, and plus you lose some functions in there, that I am used to.
So is there a better way to import CSV files into Excel, to avoid those characters? Shopify insists that when you "import" a CSV into their platform, it must be in (UTF-8 CSV) format, if this helps. Thank you.
I do a lot of importing exporting from my Ecommerce store. The import file (csv) contains HTML from the site. When I import these CSV's into Excel 2016 (Windows 10), I constantly see weird characters, such as (  ) or ( ’ ). I can do the find and replace easy enough, to remove these characters, but there has to be a better way? I have thought of using Google Sheets instead, as most say you will get cleaner data using that. However, given the amount of work I need to do on these files, Google Sheets is extremely slow, and plus you lose some functions in there, that I am used to.
So is there a better way to import CSV files into Excel, to avoid those characters? Shopify insists that when you "import" a CSV into their platform, it must be in (UTF-8 CSV) format, if this helps. Thank you.
