Opening Datasets from MND Data Visualization Tool in Excel

Step 1:  Download the dataset from the MND Earth System Data Explorer as a CSV file and save it.

Step 2:  Open a blank Excel spreadsheet

After launching Excel, a blank spreadsheet should appear. Otherwise, click the New icon button or select File: New to generate a blank spreadsheet.

Step 3:  Import the dataset data into the Excel spreadsheet

Under the Data menu, select Get External Data: Import Text File. A Browse window should open. Select the text file corresponding to the downloaded MY NASA DATA dataset that you would like to view. Click Import.

Step 4:  Follow the Text Import Wizard

The MND dataset is comma delimited. The wizard should detect this structure. Simply click Finish, and put the data in the existing worksheet.

Step 5:  Analyze your dataset using Excel tools

Excel can be a very robust analysis tool. Graphics and data filters are at your fingertips! Please refer to your Excel guide for more information.

Related Pages