+ Post New Thread
Results 1 to 4 of 4
ICT KS3 SATS Tests Thread, XLS to CSV not working for pupil info in United Kingdom (UK) Specific Forums; We have just had to reinstall QCA (another problem for the server dying) and the census info has been imported, ...
  1. #1

    MK-2's Avatar
    Join Date
    Oct 2006
    Location
    Nottingham
    Posts
    3,237
    Thank Post
    149
    Thanked 581 Times in 307 Posts
    Blog Entries
    8
    Rep Power
    200

    XLS to CSV not working for pupil info

    We have just had to reinstall QCA (another problem for the server dying) and the census info has been imported, but when we try to save the xls file as a csv, it says it saves it as csv, the file extension changes etc, but you open it up and its still column seperated not comma.
    I know this is probably a really easy thing we are overlooking, but can anyone shed some light on us :?

    Cheers

  2. #2
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: XLS to CSV not working for pupil info

    Column seperated? You mean its still an xls file? Can the file open in notepad?

  3. #3


    tom_newton's Avatar
    Join Date
    Sep 2006
    Location
    Leeds
    Posts
    4,491
    Thank Post
    868
    Thanked 855 Times in 675 Posts
    Rep Power
    197

    Re: XLS to CSV not working for pupil info

    You mean it's separated by tabs if you open it in notepad? Simple-ish solution is to fire up excel and (IIRC) there's an advanced tab where you set the delimeter. Set this to "," rather than {tab}

  4. #4

    MK-2's Avatar
    Join Date
    Oct 2006
    Location
    Nottingham
    Posts
    3,237
    Thank Post
    149
    Thanked 581 Times in 307 Posts
    Blog Entries
    8
    Rep Power
    200

    Re: XLS to CSV not working for pupil info

    got it sorted (eventually).

    it was qca moaning about it for some reason.
    thanks for all your help though



SHARE:
+ Post New Thread

Similar Threads

  1. Pupil Import
    By thom in forum ICT KS3 SATS Tests
    Replies: 9
    Last Post: 20th May 2009, 04:27 PM
  2. How long to keep ex pupil work
    By ozydave in forum Network and Classroom Management
    Replies: 24
    Last Post: 31st October 2007, 12:35 PM
  3. Pupil's Files (ie MP3's, exe's etc)
    By mmoseley in forum Network and Classroom Management
    Replies: 17
    Last Post: 27th May 2007, 11:25 AM
  4. Pupil alert!
    By Gatt in forum Comments and Suggestions
    Replies: 56
    Last Post: 8th February 2007, 09:24 PM
  5. software that needs all pupil info inputting
    By chrbb in forum Educational Software
    Replies: 9
    Last Post: 22nd September 2006, 12:13 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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