Logo
English (US) Español
Submit a request Sign in
  1. Verticalresponse
  2. Vertical Response Classic (VRC)
  3. Lists
  4. List Management

How to Convert a Spreadsheet File to UTF8

Avatar
Karissa
January 12, 2021 20:01
Follow
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.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

  • How do I create a list of people who have opened my email?
  • Opt-In Status Definitions
  • How are duplicates handled if I select multiple lists for an email?
  • Email addresses in one row and wants them as one column in excel
  • Why is my total sent higher than the total of my lists?
  • How do I delete my Master List?
  • How do I delete a list from my account?
  • Do I need to delete unsubscribes or bounces from my list when I want to send another email?
  • What is "Merge Campaign Recipients?"
  • How do I permanently remove bounced and unsubscribed email addresses from my Master List?
See more

Can't find what you're looking for?

Let us help you!

Submit a request

Copyright © 2011-2022 VerticalResponse. All rights reserved.

Powered by Zendesk