LiveHelpNow Help Desk

Support Center

BASIC

ADVANCED

Exact Match:

  • Home
  • Categories
  • Home
  • Categories
  1. Home
  2. Categories
  3. Viewing Exported CSV files containing Arabic characters

Viewing Exported CSV files containing Arabic characters

  • Date updated 2014-09-13
  • Author LiveHelpNow
  • Comments 0
  • Rating
  • Categories
  • Troubleshooting
  • Tags
  • Export

When i export analytics data, specifically Contact list reports, i am unable to view arabic characters

Excel is not capable to process UTF-8 characters correctly when CSV is opened directly in Excel.

The solution is to use data import:

  1. Save the exported file as a csv
  2. Open Excel
  3. Import the data using Data-->Import External Data --> Import Data
  4. Select the file type of "csv" and browse to your file
  5. In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
  6. Change the Delimiter to comma
  7. Select where to import to and Finish

 

 

Rate this article


Your email is now subscribed to alerts for this article

Your email is not subscribed to alerts for this article

Subscribe to alerts for this article below

Unsubscribe to alerts for this article below


Leave a comment?

Related articles

  • Issues with chat button code
    • 21637
    • 59
    • 0
  • How to stop LiveHelpNow from starting when Windows starts
    • 20225
    • 60
    • 0
  • Invitations to chat and flash objects
    • 25302
    • 59
    • 0
  • Custom information feed with "Same IP - New Chat session" setting enabled
    • 24566
    • 57
    • 0
  • New visitor notification
    • 27068
    • 58
    • 0
  • LiveHelpNow operator panel loads slowly, shows "Page not found" errors or freezes.
    • 21675
    • 59
    • 0
  • Alerter login issue
    • 20157
    • 59
    • 0
  • How to determine if your network has issues connecting to LiveHelpNow
    • 20241
    • 28
    • 0
  • Find Alerter notification software icon in Windows 7
    • 19711
    • 59
    • 0
  • Chat Sessions per Unique Visitor
    • 21217
    • 59
    • 0

Popular Knowledge Base Articles

  • Customize with different languages
    • 21791
    • 27
    • 0
  • LiveHelpNow Section 508 Compliance & Accessibility for Visually Impaired Users
    • 16867
    • 60
    • 0
  • Unsecured content warnings
    • 16163
    • 57
    • 0
  • HelpOut Tab - changing Chat, Ticket and Callback button images
    • 23892
    • 27
    • 0

Knowledge Base Authors

  • Michael Conde
    Michael Conde
    Total articles: 10
  • LiveHelpNow
    LiveHelpNow
    Total articles: 257

Company Sites

Home

Blog

Categories

  • General Questions
  • Getting Started
  • Customization
  • Advanced Customization
  • Troubleshooting
  • All Categories

Connect With Us

  • LiveHelpNow, LLC
  • Customer Service Software
  • 515 S West End Blvd
    Suite 202
    Quakertown, PA 18951

  • 8775483001
  • help@livehelpnow.com
  • https://www.livehelpnow.net
    Powered by Global Knowledge Base a LiveHelpNow product