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.

Reports In Marin

Home > English > Reports In Marin > Creating Reports and Alerts > How To Articles: Creating Reports & Alerts > Importing International Characters from MarinOne into Excel

Importing International Characters from MarinOne into Excel

Table of contents


Search marketers may utilize letters from other character sets, especially if marketing internationally. Character integrity is preserved in MarinOne. However, there may be situations that warrant creating a report for download that includes text containing letters such as ä, ë, ï, ö, or ü. When opening the downloaded report in Excel, these characters may be replaced with question marks.


To work around this, please follow these steps:

  1. Export and download the file from MarinOne as usual. The document will be available as a CSV file.
  2. Launch Excel but do not open the document.
  3. Go to the Data menu tab in Excel.
  4. In the Get External Data section, select From Text.
  5. Highlight the document and click on the Import button. This will launch the Text Import Wizard.
  6. From the File Origin drop-down, select 65001: Unicode (UTF-8).
  7. Choose the correct delimiter (Tab is the default).
  8. Select the worksheet cell in which the wizard should begin to place the document (the default is A1 and should suffice for most use cases).

The file will now be opened with all original characters retained.

To save the document and retain character integrity, remember to perform a Save As command and select the type Unicode Text.



Last modified