1.  Delimited text files (fields of data are separated by delimiters such as commas or tabs)

• Open Microsoft Excel. Click on file and then open.  Make sure that you specify text files in the files of type box, and locate and open the desired file.
• After you open the file, the text import wizard window will open and lead you through a series of steps to import the file. Click on the next button to proceed to the next step, or click on back to go back to the previous step.  Click on cancel to exit the window.
• Choose the original data type by clicking on delimited.  Adjust the row number from which you want to start importing data if it is different from one.  Click on the next button.
• Specify and click on the type of delimiter(s) (e.g., comma, space) that separate the fields in your data file.  Click on next.
• Select the appropriate data format for your columns.  (The default is general and fits most data needs.) Click on finish.
• Make sure to save the file as an excel file in the appropriate location.

• Open Microsoft Excel. Click on file and then open.  Make sure that you specify text files in the files of type box, and locate and open the desired file.
• After you open the file, the text import wizard window will open and lead you through a series of steps to import the file. Click on the next button to proceed to the next step, or click on back to go back to the previous step.  Click on cancel to exit the window.
• Choose the original data type by clicking on fixed width.  Adjust the row number from which you want to start importing data if it is different from one. Click on the next button.
• Excel automatically sets up field widths for the file, but they can be adjusted by dragging the text lines. Click on next when finished.
• Select the appropriate data format for your columns.  (The default is general and fits most data needs.) Click on finish.
• Make sure to save the file as an excel file in the appropriate location.

If you have any questions, please ask a labster for assistance.