Welcome!
Welcome to the Marin Software Support Center. We're glad you're here. Here's what you can look forward to:
  • Real-time search so you can find what you need faster than ever.
  • Easy-to-follow video guides for our most popular articles.
  • Interactive simulations and Live Screenshots to make learning easy.
  • Regular content updates to ensure every word you read is accurate and up-to-date.

Managing Campaigns

Home > English > Managing Campaigns > Bulk Actions > Troubleshooting Articles: Bulk Actions > Avoiding Excel Character Encoding

Avoiding Excel Character Encoding

Introduction

When uploading changes via file, the Platform requires that the file be saved in Unicode (UTF-8) text format to avoid any errors related to formatting or encoding.

However, even when saving in Unicode format, excel will still encode certain characters. If the file is not saved and loaded with this format, Excel’s encoding of special characters will cause these characters to display incorrectly in the Platform.

How to Avoid Character Encoding

Characters that Microsoft Excel encodes include non English-language characters/punctuation, and special characters such as trademark symbols. This also includes non-standard punctuation such as double-byte characters (�) or other foreign characters such as ä, è, ë.

If you’re performing an upload that you feel may include characters like this, it’s a good idea to either:

  • Save your bulk upload file as a Unicode Text file (UTF-8), and then upload this file format into the Platform.


Or you can do the following for extra precaution:

  • Copy your workbook into a text editor such as Notepad once you’ve finished making your changes in Excel. You can then save it as a Unicode file from there and upload that file to the Platform without worrying about encoded characters.
     

Make sure to review your upload before loading it into the Platform to ensure that you do not see any issues with characters or the formatting.
 

Note: Notepad does not encode these characters when saved in Unicode format. However, if you use a different kind of text editor, we advise you to check how it handles special/foreign characters before using it to save a bulk sheet.

 

Last modified

Tags

Classifications

This page has no classifications.

 

wiki.page("Internal/Mindtouch_Launch_Sandbox/js.cookie.js")