What Is a CSV File
CSV (comma-separated values) file is a plain text file that includes a list of data. These files are mostly used for exchanging the data between different applications. For example, databases and contact managers usually hold back the CSV files. These files may often be called Character Separated Values or Comma Delimited files.
They mostly use the comma character for separating (or delimit) data, but sometimes they use other characters, like semicolons. The idea is that you can export complex information from one application to a CSV file, and then import the same data in that CSV file into another application.
The Structure of a CSV File
A CSV file has a fairly simple structure. It’s a list of data separated by commas. For example, let’s say you have a few contacts in a contact manager, and you export them as a CSV file. You’d get a file containing text like this:
|Name, Email, Phone Number, AddressBob Smith,firstname.lastname@example.org,123-456-7890,123 Fake StreetMike Jones,email@example.com,098-765-4321,321 Fake Avenue|
That’s all a CSV file is. They can be more complicated than that and can contain thousands of lines, more entries on each line, or long strings of text. Some CSV files may not even have the headers at the top, and some may use quotation marks to surround each bit of data, but that’s the basic format.
That simplicity is a feature. CSV files are mainly designed to be a way to simply export the data and import it into another program. The resulting data is human-readable and can be easily viewed with a text editor like Notepad or a spreadsheet program.
How to Convert CSV to Excel
There exist 3 ways for converting CSV to Excel: you can also open a .csv file directly into Excel, just double-tap on the file in Windows Explorer, or import any CSV file into Excel as external data.
|Method 1: Open a CSV file in Excel Method 2: Open a CSV file in MS Excel by using Windows Explorer Method 3: Import CSV to Excel|
Method 1:-How to open CSV file in Excel
If you had generated a CSV file in another program, you can still open it as an Excel worksheet in the normal way by using the Open command.
- With your Microsoft Excel open head over to the File button and tap on “Open”.
- The Open dialog box appears and then choose the Text Files (*.prn,*.txt,*.csv) from the drop-down menu in the lower right-hand corner.
- Navigate the CSV file and open it as usual by the double-tap on it.
- If you are opening a .csv file, Excel will open it straight away and display the data in a new workbook.
- If you have selected a text file (.txt), Excel will start the Import Text Wizard. See Importing CSV to Excel for full details.
- To get Excel for launching the Import Text Wizard, you can either change the file extension from .csv to .txt extension before opening the file, or you can import the CSV file to Excel as explained further.
Method 2:-How to open a CSV file using Windows Explorer
This is the fastest method to open a CSV file in Excel. In Windows Explorer, just double-tap on a .csv file and have it open as a new worksheet.
However, this technique works only if you have Microsoft Excel set as the default program for .csv files on your computer. If so, then you will see the familiar green Excel icon displayed next to the .csv file’s name in Windows Explorer.
If Excel is not set as the default program, you can set it in this way:
- Right-tap on any .csv file in Windows Explorer, and then choose the Open with… > select the default program from the context menu.
- Tap on Excel on the desktop under Recommended Programs, just assure yourself that you select the “Always use the selected program to open this kind of file” and click on OK.
Method 3:- How to import CSV to Excel
Using this technique you can import data from a CSV file into the existing or a new Excel worksheet. Unlike the previous two methods has been described,
- With the required spreadsheet open, click the cell where you wanted to import the data from a .csv file or .txt file.
- On the Data button, in the Get External Data group, click on “From Text”.
- Navigate to the CSV file you wish to import, choose it and tap the Import button.
- The Text Import Wizard will appear and you will have to follow their steps.
Hopefully, this will help you in understanding the much better way that why we choose these settings with this example.
Step 1:- Select the file type and the row number to start importing the data. normally, you select Delimited and row 1, respectively. The preview window in the lower part of the wizard shows the first few entries of your CSV file. select the file type and the row number to start importing the data from CSV to Excel.
Step 2:- In this step, you choose a delimiter(s) and text qualifier. The delimiter is the character that separates the values in your .csv file. If your CSV file uses some character other than the character that is available in the pre-defined list, then select the Other checkbox and type your custom character.
Step 3:- If you are satisfied with the Data preview, then just tap on the Finish button.
- select the destination for the imported data, either an existing or a new worksheet, and click on OK to finish the importing of your CSV file to Excel.