Your Moodle version

Exports: XLS with Groups and Dates

Maintained by Picture of Carina Martinez Carina Martinez
Grade export derived from XLS file. Adds Groups and Dates columns
Moodle 2.1, 2.3, 2.4, 2.5, 2.6

This plugin exports grades in xls file, adding two type of columns:

1. Group column,  shows groups' name which students are enroled. In the "All participants" export (without selection of group), you'll see a row for each student-group couple, it means that for the same student could have as many rows as groups which he was affiliated.

2. Date columns, for each grade item, shows the last modification date for this item grade (Y.m.d  format)


Copy the plugin directory "xlsgd" into moodle\grade\export\.
Check admin notifications to install.


Picture of Carina Martinez
Carina Martinez (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • MD shot of me from his iphone4
    Fri, Jul 26, 2013, 2:57 PM
    Hi Carina,
    Thanks for your submission.

    It would be good to share this properly so here is some feedback in how we can go about that :
    - It is better to include some urls here in the 'useful links' section:
    -- public code repository (eg: github)
    -- issue tracker (e.g: or
    -- if you have any additional documentation you can create a link for it as well.

    Generally, this feels like it could become a generalised feature and become included in core so you might want to consider improving XLS report with a patch in an MDL.
  • Picture of Vicente Herrera
    Tue, Sep 10, 2013, 11:59 PM
    Doesn't work on Moodle 2.3, after selecting report options, when clicking "download" it gives error:

    Debug info:
    Error code: nopermissions
    Stack trace:
    line 704 of /lib/accesslib.php: required_capability_exception thrown
    line 41 of /grade/export/xlsgd/export.php: call to require_capability()
  • Picture of Vicente Herrera
    Wed, Sep 11, 2013, 12:12 AM
    It seems that there is a typo on roles capabilities names. Administrator role never gest capability "gradeexport/xlsdate:view", but "gradeexport/xlsdg:view", etc.

    To fix this, change line 41 of /grade/export/xlsgd/export.php from:
    require_capability('gradeexport/xlsdate:view', $context);
    require_capability('gradeexport/xlsgd:view', $context);

    And it should work just fine...
  • Picture of Carina Martinez
    Fri, Sep 13, 2013, 2:51 AM
    Gracias Vicente!
    Se había colado el error, en el archivo de la carpeta lang en realidad.
    Está corregido y subido.

    Agradezco feedback en este foro:
  • Picture of Daniel Lombardo
    Sun, Sep 15, 2013, 2:24 PM
    Oh God Bless You. and i'm not religious... you just made our lives easier. Moodle 2.5.2 working fine.
  • Picture of Daniel Lombardo
    Sun, Sep 15, 2013, 2:36 PM
    It would also be great to enable or disable the dates. We have a lot of graded items to export at once sometimes, exporting the dates may occasionally put too much load on the server.
  • Picture of Carina Martinez
    Mon, Sep 16, 2013, 8:35 PM
    Thanks Daniel for your feedback. Yes, it would be great some working around this. Well, I hope have some time for think about Aparup suggestions too.... smile
Please login to post comments