+ Reply to Thread
Results 1 to 2 of 2

why CSV format changed and how to save utf8 from .xls

  1. #1
    Registered User
    Join Date
    12-02-2020
    Location
    Hungary
    MS-Off Ver
    office 365
    Posts
    10

    why CSV format changed and how to save utf8 from .xls

    Hi,

    This might be a wierd question,as the situation is for me, I faced an issue that I try to explain as deatailed as I can.

    I exported csv file from woocommerce and it should consist of columns but it always comma separated. And former .csv that were comma separated open in columns. (it is after I got a new laptop with the same office version)

    The question is why excel opens .csv in that way, like it switched the format?

    Thank you.
    Tamas
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-12-2021
    Location
    Europe
    MS-Off Ver
    365
    Posts
    45

    Re: why CSV format changed and how to save utf8 from .xls

    The csv file takes the list separator from your pc settings, you need to change the list separator.
    Attachment 743811

    You need to go to control panel -->region --> Additional settings --> list separator and change it
    Attached Images Attached Images
    "Good Morning, Good Evening and Good Night"

+ 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. Macro to log what has been changed before save
    By MrtKr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 05:07 AM
  2. Save excel files as csv with utf8 unicode
    By otariki in forum Excel General
    Replies: 0
    Last Post: 04-24-2013, 08:17 AM
  3. Replies: 3
    Last Post: 01-09-2012, 01:39 PM
  4. Replies: 8
    Last Post: 06-16-2011, 11:49 AM
  5. Save UTF8 TXT without tabstop
    By Eich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2011, 07:34 AM
  6. Save when cell is changed?
    By JP Romano in forum Excel General
    Replies: 2
    Last Post: 07-24-2009, 12:55 PM
  7. [SOLVED] Hyperlinks getting changed on save
    By Dennis Benjamin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2006, 11:50 PM

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