+ Reply to Thread
Results 1 to 6 of 6

.CSV files with unicode

  1. #1
    Registered User
    Join Date
    09-11-2016
    Location
    Israel
    MS-Off Ver
    Home 2016
    Posts
    22

    .CSV files with unicode

    Hello,

    I have a utility that produces multiple .csv files with sheets.

    The problem is the in many rows it displays Gibberish instead of the actual language it suppose to show (non English)

    The csv encoding is UTF8.

    I've stumbled upon a solution in this link:
    https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0

    my question is, can I perform this solution in a batch process? cause there are many many csv reports, and i don't want to do it manually one by one.

    Thanks!!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: .CSV files with unicode

    ? I'm confused. Are you importing or exporting csv?

    It would be helpful if you have sample raw data along with how end result should look like.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    09-11-2016
    Location
    Israel
    MS-Off Ver
    Home 2016
    Posts
    22

    Re: .CSV files with unicode

    Hi,

    I'm trying to import.

    some of the text in cells is in fact english and some is gibberish. This process fixes it. I wonder if I could fix multiple files at once

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: .CSV files with unicode

    You have Excel 2016. Just use PowerQuery to import CSV.

    You can marge multiple files into single table. If that's not desired...

    Upload sample csv file so that I can test solution.

  5. #5
    Registered User
    Join Date
    09-11-2016
    Location
    Israel
    MS-Off Ver
    Home 2016
    Posts
    22

    Re: .CSV files with unicode

    Thanks

    whats your email ill send the file over

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,720

    Re: .CSV files with unicode

    Hi, I've sent PM with my email address.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Save excel files as csv with utf8 unicode
    By otariki in forum Excel General
    Replies: 0
    Last Post: 04-24-2013, 08:17 AM
  2. Replies: 0
    Last Post: 11-21-2012, 09:51 AM
  3. how to export Unicode data to multiple text files
    By world33 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2010, 12:44 AM
  4. Saving Excel files as CSV with Unicode support
    By Mantas in forum Excel General
    Replies: 3
    Last Post: 08-29-2008, 09:33 AM
  5. Excel ignores "Text qualifiers" in Unicode files
    By Doug in forum Excel General
    Replies: 0
    Last Post: 06-08-2006, 04:35 PM
  6. Unicode
    By Shafiee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-16-2006, 01:25 PM
  7. Unicode Help
    By xcelion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2005, 05:29 AM
  8. BOM and Unicode CSV's
    By Danny Mosquito in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2005, 01:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1