1. Windows Central Question's Avatar
    After upgrading to Windows 10, csv files are no longer opening correctly in excel. Before upgrading the data would display correctly in columns. Since the upgrade the data displays all in one line instead of being in columns. Can anyone tell me what I need to change? Many thanks
    08-15-2015 12:11 PM
  2. Graeme Partridge's Avatar
    Just had exactly the same issue. Something during the windows 10 upgrade set the List Separator value to a " ; " instead of a comma.

    To change
    - Settings - Time & Language
    - Additional date, time & regional setting (at the bottom
    -change date, time or number formats
    - Additional settings ... (Button)

    Change the List Separator from the semi colon to a comma.
    Salvs likes this.
    08-16-2015 10:19 PM
  3. harlequine's Avatar
    I have encountered the same problem. Any help you got?
    08-26-2015 03:00 AM
  4. BelindaHayden's Avatar
    Thanks so much for the help Graeme. CSV files are opening fine now that I have changed the list separator to a comma
    09-13-2015 10:38 AM
  5. BazilM's Avatar
    Great advice. Changing ; to , worked a treat, cheers
    02-08-2016 10:43 PM

Similar Threads

  1. Outlook 2013 and the Action Centre
    By googler003 in forum Windows 10
    Replies: 1
    Last Post: 08-24-2015, 10:42 PM
  2. Windows 10 upgrade
    By Windows Central Question in forum Ask a Question
    Replies: 1
    Last Post: 08-15-2015, 12:23 PM
  3. Replies: 0
    Last Post: 08-15-2015, 11:39 AM
  4. New Fitbit Universal Windows 10 app
    By Blkacesvf41 in forum Windows 10
    Replies: 0
    Last Post: 08-15-2015, 11:08 AM
  5. Why does the appstore point to the Windows store when clicking links?
    By Windows Central Question in forum General Phone Discussion
    Replies: 0
    Last Post: 08-15-2015, 10:43 AM
LINK TO POST COPIED TO CLIPBOARD