How to Convert a Spreadsheet File to UTF8

How to Convert a Spreadsheet File to UTF8

In some situations it’s necessary to convert a .CSV Spreadsheet file to UTF‐8 encoding before you can upload the file to VerticalResponse. If you run into this issue, here are simple methods for doing the conversion using Excel for Windows, Open Office for both Windows and Mac OS X, and Numbers for Mac OS X:

In Excel 2007 for Windows:

1. Go to File > Save As. This will bring up the “Save As…” dialog box.
2. Click the “Tools” button. You’ll find this in the lower left hand corner of the box.
3. Select “Web Options”
4. This will bring up another box with a series of tabs. Select the “Encoding” tab and then use the drop down menu to change the encoding to UTF‐8.
5. Click OK and then save the document as a CSV file.

In Excel 2003-2006 for Windows:
Follow the same steps as above, just note that the “Tools” button is located in the
top right of the “Save As” box as opposed to the bottom left as in Excel ’07.

In Open Office for Windows and Max OS X:

1. Go to File > Save As. This will bring up the “Save As…” dialog box.
2. Choose to save the file as CSV.
3. You should see that the “Edit Filter Setting” checkbox is now accessible.
4. Check this box.
5. After you click “Save” a dialog box will appear asking you which character set to use. Select UTF‐8.

In Numbers for Mac OS X:

1. Go to File > Export. This will bring up the “Export” dialog box.
2. Choose the CSV tab.
3. Use the “Text Encoding” drop down menu to select UTF‐8.
4. Click Next and then choose where you want to save the file.