Difference between revisions of "How to copy data"
Jump to navigation
Jump to search
(Created page with "category:Howto ==How to copy data out of a table== Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format ...") |
|||
| Line 3: | Line 3: | ||
Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format output. Most of the tables of data generated by SAGMILLING.COM contain a special <i>text box</i> where the table contents can easily be copied and pasted into your favourite spreadsheet software (OpenOffice, LibreOffice, Microsoft Excel, Gnumeric, Lotus 1-2-3, etc.) |
Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format output. Most of the tables of data generated by SAGMILLING.COM contain a special <i>text box</i> where the table contents can easily be copied and pasted into your favourite spreadsheet software (OpenOffice, LibreOffice, Microsoft Excel, Gnumeric, Lotus 1-2-3, etc.) |
||
| + | Tables of data include icons that permit data to be exported in a variety of ways. Not every table has all these options available, and the exact output will vary depending on which table is being exported. |
||
| ⚫ | |||
| + | * '''ODS''' icon begins a download of an OpenOffice or LibreOffice spreadsheet. This can be used directly in versions of Microsoft Excel versions 2011 and newer. |
||
| + | * '''PDF''' icon begins a download of a detailed report including, where appropriate, tables and graphs of data. |
||
| ⚫ | * '''Raw cut & paste''' icon opens a box with a large text field containing all the data in the table, formatted in a special form that is easy for spreadsheets to import. Do not worry that the formatted data looks strange to humans -- just select the whole data field (usually clicking the mouse in the field and pressing Ctrl-A on the keyboard) and copy it (usually by selecting Edit|Copy from your browser's menu bar). Then switch to your spreadsheet and paste (usually by selecting Edit|Paste from your spreadsheet's menu bar). |
||
Revision as of 22:56, 8 December 2013
How to copy data out of a table
Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format output. Most of the tables of data generated by SAGMILLING.COM contain a special text box where the table contents can easily be copied and pasted into your favourite spreadsheet software (OpenOffice, LibreOffice, Microsoft Excel, Gnumeric, Lotus 1-2-3, etc.)
Tables of data include icons that permit data to be exported in a variety of ways. Not every table has all these options available, and the exact output will vary depending on which table is being exported.
- ODS icon begins a download of an OpenOffice or LibreOffice spreadsheet. This can be used directly in versions of Microsoft Excel versions 2011 and newer.
- PDF icon begins a download of a detailed report including, where appropriate, tables and graphs of data.
- Raw cut & paste icon opens a box with a large text field containing all the data in the table, formatted in a special form that is easy for spreadsheets to import. Do not worry that the formatted data looks strange to humans -- just select the whole data field (usually clicking the mouse in the field and pressing Ctrl-A on the keyboard) and copy it (usually by selecting Edit|Copy from your browser's menu bar). Then switch to your spreadsheet and paste (usually by selecting Edit|Paste from your spreadsheet's menu bar).