Importing CSV or Excel Files

This tutorial dicusses the process of importing data in a CSV (comma separated) or from an MS Excel (.xls) file. While the process for importing these two file types is similar, there are some differences, and some advantages and disavantages to each.

After completing this tutorial, you will be able to:

• Identify the proper layout for a spreadsheet to be converted to CSV for import.
• Convert spreadsheets to a CSV in Excel
• Import a simple CSV file with production data into PHDWin
• Identify the advantages of CSV over Excel files for import
• Identify the advantages of Excel files over CSV for import
• Prepare Excel Files for importing into PHDWin
• Import simple Excel files into PHDWin