How to Open CSV Files

Step-by-Step Guide

1. 1

   Step 1: Launch Microsoft Excel on your computer.

   This menu is in the upper left corner and will open a window to browse for files on your computer.
   
   You can also press Ctrl + O (Windows) or ⌘ Cmd + O (Mac) to perform the same action. , The file will open and display in a new Excel spreadsheet. , If Excel displays all text from the CSV file in a single column, this will allow excel to better parse the data.
   
   The Data tab is located in the top menu bar and will display a set of data-specific options.
   
   If you only want to split certain columns, click and drag the cursor to highlight the columns you want split. , This button is one of the options in the data tab and will open the “Text to Columns” wizard. ,,
2. 2

   Step 2: Click the “File” menu and select “Open”.

3. 3

   Step 3: Select a CSV file and press “Open”.

4. 4

   Step 4: Click on the “Data” tab to access the “Text to Columns” wizard (optional).

5. 5

   Step 5: Click “Text to Columns”.

6. 6

   Step 6: Select the “Delimited” option

7. 7

   Step 7: then click on “Next.” A delimiter sets a boundary between data points in a text file (in this case

8. 8

   Step 8: the comma).

9. 9

   Step 9: Select the “Comma” checkbox then click on “Finish.” All the text that was previously separated by commas will now be placed in separate

10. 10

    Step 10: individual columns.

Detailed Guide

About the Author