{"id":12398,"date":"2017-07-27T11:18:03","date_gmt":"2017-07-27T01:18:03","guid":{"rendered":"http:\/\/legoeng.local\/?p=12398"},"modified":"2017-09-07T16:26:21","modified_gmt":"2017-09-07T06:26:21","slug":"how-to-export-an-ev3-data-file-to-excel","status":"publish","type":"post","link":"http:\/\/legoeng.local\/how-to-export-an-ev3-data-file-to-excel\/","title":{"rendered":"How to export an EV3 data file (*.rdf) to Excel"},"content":{"rendered":"

\"\"<\/a>To open an EV3 data file (*.rdf) in Excel (or equivalent application), the trick is to convert it to a (*.csv) file using the the Tools > Export Datasets menu option in the EV3 Software.<\/p>\n

If you need more help, read on…<\/p>\n

Collect data<\/h2>\n

To get started, you will need some data. If you’d like some help getting started with datalogging, see Light and Dark Scavenger Hunt<\/a>.<\/p>\n

If the EV3 brick was connected to your computer when you ran the experiment, the collected data should already be visible in the Dataset Table…<\/p>\n

\"\"<\/a>
Some collected data<\/figcaption><\/figure>\n

If the EV3 brick wasn’t connected to your computer, you will need to upload the data. You can either select Tools > Data Log File Manager or select the Upload button…<\/p>\n

\"\"<\/a>
Upload logged data<\/figcaption><\/figure>\n

Export data<\/h2>\n

To export the collected data, use the menu option: Tools > Export Datasets<\/p>\n

\"\"<\/a><\/p>\n

This will create a comma separated values (*.csv) file that can be open normally in Microsoft Excel or other spreadsheet software (or even text-editing software such as Notepad or Microsoft Word).<\/p>\n

\"Experiment<\/a>
Experiment data that has been imported into Excel<\/figcaption><\/figure>\n

For a basic introduction to datalogging, see Light and Dark Scavenger Hunt<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

To open an EV3 data file (*.rdf) in Excel (or equivalent application), the trick is to convert it to a (*.csv) file using the the Tools > Export Datasets menu option in the EV3 Software. If you need more help, read on… Collect data To get started, you will need some data. If you’d like […]<\/p>\n","protected":false},"author":4,"featured_media":12469,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[159],"tags":[74,577],"_links":{"self":[{"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/posts\/12398"}],"collection":[{"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/comments?post=12398"}],"version-history":[{"count":0,"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/posts\/12398\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/media\/12469"}],"wp:attachment":[{"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/media?parent=12398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/categories?post=12398"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/legoeng.local\/wp-json\/wp\/v2\/tags?post=12398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}