Is there a way to download an entire Grid Report without copying it page by page?

  • Profile Image
    adatshalom
    Asked on September 15, 2014 at 06:36 PM

    Because of a Table response we have in our form, the Grid Report has a display with each column of the table displaying in a cell, exactly how we would like to see it (and thus saving us mucking around with Excel). However, the only way I can see capturing this (to copy back into an Excel spreadsheet) is to copy each page of the displayed report into the spreadsheet, one by one. Not a huge task, but just wondering if I am missing something easier.

  • Profile Image
    jonathan
    Answered on September 15, 2014 at 07:01 PM

    Hi,

    If you download the submission to Excel, it will assign a separate column for the matrix column/cell.

     

    is this not what you want?

    OR you need them to be in single column only in Excel...

    Please clarify and I'll try figure out a suitable workaround for your requirement.

    Thanks.

     

     

  • Profile Image
    adatshalom
    Answered on September 15, 2014 at 11:10 PM

    No. If you view the Grid Report below, you will see that it merges the responses to create a two-column merged column under the heading "Yizkor book entries". That is the critical column--we want to download a report in this format in one go. Right now, I can copy and paste each page of the Grid Report as it appears on the website into Excel, but I was wondering if there was another way to get all the results in this format.

  • Profile Image
    EltonCris
    Answered on September 16, 2014 at 05:57 AM

    @adatshalom 

    I'm sorry but only Grid Report supports displaying matrix table in that format. It is different when you download the submissions report to Excel or CSV. It is because the submissions are generated as text string. Unfortunately, there's no available workaround for that as far as I know only except if you copy them manually to your Excel. :)

    Thank you!