Lost password?    Lost username?    Create an account
OverviewDownloadsForumSupport
CSV Improved

CSV Improved

Save a CSV file as UTF-8

Often it is almost impossible to know if your CSV file has been encoded as UTF-8. Programs cannot tell you for certain because there is no setting in the file that contains this information. The closest to come to determining a file's encoding is an educated guess or ask the person who created the file. Usually the person creating the file doesn't know either. All is lost then? Not really, you can create your own file and save it with a known encoding.

The choice of spreadsheet in this case is OpenOffice or LibreOffice. If you use Excel to do all your work in, you are out of luck as Excel has no option for enforcing an encoding when saving a file as CSV. This does not mean you can no longer use Excel but when saving the file for CSV open your Excel file with OpenOffice or LibreOffice.

Start OpenOffice/LibreOffice

In this example I will be using LibreOffice (the screens are the same for OpenOffice).

LibreOffice

Open the file

Click on Open and select the file on your computer that you want to save as UTF-8 encoded file.

Save the file

We are not going to use CTRL-S to quickly save the file but we choose File -> Save As (CTRL-SHIFT-S) and then you get this screen:

LibreOffice Save As

There are a few things that are important:

  1. Give your file a name
  2. Save as type must be set to Text CSV (.csv)
  3. You must enable the Edit filter settings

After that is done click on Save.

Setting the filter settings

After you have clicked on Save, LibreOffice will ask you what settings you want to use for the file.

Export settings

The character set must be set to Unicode (UTF-8) as this is what we want to achieve, a UTF-8 encoded file.

The field and text delimiter you can set as you wish or leave it as it is, all other settings can be left unchanged.

After that is done, click on OK.

You now have a UTF-8 encoded file.

 

TESTIMONIAL

Excellent Component, features & support
5 stars
2013-08-06
I have used the full/pro versions of CSVI for a few years now & I would recommend it to anybody with a virtuemart site or site where you may need to import anything else.
Not only does it work brilliantly for Virtuemart Stores, but there are also other standard templates for AWO EZ Reality, K2 AUP, Joomla Articles, Users and lots more.
If its not already set up, you can also use the custom field settings & the developer Roland is always on hand providing excellent support and solutions to your CSV related problems.

Roland has helped me out on many occasions with basic CSV stuff and more complicated bespoke CSVi templates.

It's awesome - Really & will save you hours manually inputting products, articles, coupons, etc.

Try the free version & if you like it buy the Pro version as it's easily worth the price you pay.

STAY INFORMED


Stay informed with the CSVI newsletter.