1 / 14

The Petroleum Registry of Alberta Energizing the flow of information

Learn how to import CSV data into Excel, manipulate and sort the data, and use filters for data analysis. This training session took place on September 27, 2004, at The Petroleum Registry of Alberta.

dawns
Download Presentation

The Petroleum Registry of Alberta Energizing the flow of information

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Petroleum Registry of AlbertaEnergizing the flow of information Training Session September 27, 2004

  2. Using CSV Reports

  3. Using CSV files: • Double clicking or opening will use excel this may cause some of the data to change specifically zeros may be lost and dates formats may change • It is recommended that unless you are comfortable adding back in zeros and changing formats you actually save the csv file on your computer without opening it and then import the data into an excel spreadsheet.

  4. Directions for importing csv data into excel and then manipulating data 1.Save the csv file on your computer 2.Open a new (blank) excel spreadsheet 3.Choose Data – Get External Data – Import Text File 4.This opens a window you change the file type to All Files 5.Locate the saved csv file and click import

  5. 6. This opens an import wizard screen be sure the Delimited file type is selected

  6. 7. Change the delimiters setting so comma is checked off click Next

  7. 8. Leave the columns with volume and energy as general. Change all other columns to be text by choosing a column and changing the column data format to be text.

  8. 9. Once all the columns are text click finish this takes you back to the open excel file and confirms where you want the data. Click OK.

  9. 10. All the data will now appear on the excel spreadsheet the columns will adjust automatically to fit the content

  10. 11. Once the data is on the excel spreadsheet it can be manipulated. Sorting the data is one type of manipulation. On the excel menu bar select - Data – Sort and another window opens 12. Make your sort selection the drop down box will list all column headers for you to choose from. Click OK and the data will be sorted as requested

  11. 13. Another option for manipulating the data when it is excel is to use filters. On the excel menu bar select – Data – Filter and check AutoFilter

  12. 14. Now each of the columns will have a drop down arrow that can be used to filter the data displayed on the spreadsheet. Using the drop list select one item and then the data will be filtered and displayed.

  13. Summary/Wrap up • Focus Items for All Users: • How to import csv data into an excel spreadsheet • How to manipulate the imported data in an excel spreadsheet.

  14. Summary/Wrap up (con’t) • Your comments are appreciated to assist in future training sessions. • If you have any questions or comments about the content of this presentation, please email them to:petroleumregistry.energy@gov.ab.ca • or fax them to us at 297-3665.

More Related