Announcement

Collapse
No announcement yet.

Download project results as Excel/csv

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Download project results as Excel/csv

    I would like to have the ability to download the results for those projects to which my kits belong as an Excel and/or .csv file. I believe project admins can do this, but could the feature be extended to include project members as well? I know admins can set up Yahoo or 3rd party groups and upload their results there, but not all of them do it.

    How hard is this to do? It is already available somewhere and I'm just blind? Any advice appreciated.

  • #2
    Originally posted by brookes View Post
    I would like to have the ability to download the results for those projects to which my kits belong as an Excel and/or .csv file.
    Here's a method I use to copy almost any table from a web page to an excel spreadsheet:

    Place your mouse pointer just above the top left corner of the table - outside the table. In this case, just to the right of where it says Page 1 of x. Hold down the left mouse button, and drag it all the way down to the bottom of the table just below the bottom edge of the table. In this case where it says Page x of x. Release the mouse button. The entire table should be highlighted. Open a new Excel Workbook. Right click on the top left cell, and select "paste special". The "HTML" option should already be highlighted. If it isn't, you may have done something wrong. Otherwise, click OK. It should paste the entire results into the excel spreadsheet. You will probably have to adjust some of the column widths and formatting.

    Comment


    • #3
      Thanks John, I'll try that!


      Originally posted by JOlson View Post
      Here's a method I use to copy almost any table from a web page to an excel spreadsheet:

      Place your mouse pointer just above the top left corner of the table - outside the table. In this case, just to the right of where it says Page 1 of x. Hold down the left mouse button, and drag it all the way down to the bottom of the table just below the bottom edge of the table. In this case where it says Page x of x. Release the mouse button. The entire table should be highlighted. Open a new Excel Workbook. Right click on the top left cell, and select "paste special". The "HTML" option should already be highlighted. If it isn't, you may have done something wrong. Otherwise, click OK. It should paste the entire results into the excel spreadsheet. You will probably have to adjust some of the column widths and formatting.

      Comment


      • #4
        I have been using John's method for some time, but I find that the multi-value markers paste as dates, not numbers. I have found a workaround, but it is very long-winded - is there a way of avoiding this problem that I haven't discovered yet?

        Comment


        • #5
          @brookes
          First, let me add that I forgot to mention you have to "copy" the highlighted image to your clip board (ctrl-c or right-click and select 'copy')before you move to excel.

          @svien
          Try this: Highlight the entire column. (you can do that by clicking on the column heading with the letter in it). Right click on any highlighted cell. In the window that opens up, select 'format'. Select the 'number' tab. Click on 'text'.

          Comment


          • #6
            Thanks John (it's John is it?),
            I'm afraid that doesn't work for me. What I have to do is to configure the whole blank Excel sheet as text, then Paste special-text. But then, before I can do maths on the results, i.e. check for matches, etc, I have to convert the cells back to numbers, and of course split the multi-value markers into individual columns - very boring!

            What I discovered just now is a slightly simpler way of copy/pasting from a web site. On the Office 2013 version I have there is on the Data tab a command for Import from Web where you can input your web page address and the software finds the appropriate data and will import the values. Only tried it once, and it worked and it simplifies the operations. Only valid of course if you want to import the whole page.

            Comment


            • #7
              Originally posted by JOlson View Post
              @brookes
              First, let me add that I forgot to mention you have to "copy" the highlighted image to your clip board (ctrl-c or right-click and select 'copy')before you move to excel.
              Oh, right, of course - I knew that, so I just assumed it was in your instructions.

              Comment


              • #8
                Ahh, I just tried it and it doesn't work - Excel gives me a generic error message of "Microsoft Excel cannot paste the data" when I try HTML. I can paste as Text but then the columns are lost. Ahh! I am using an ancient version of Excel for Mac, so that might have something to do with it.

                ETA: I just tried it as text and turns out it doesn't lose the columns. The alignment is slightly fcocked, and unless I change the entire blank worksheet to Text format the cells, some of them come out as dates, but I can work around those issues.
                Last edited by brookes; 22nd March 2013, 12:50 PM.

                Comment

                Working...
                X