What is a CSV File?
Comma Separated Values (CSV) file is nothing but a plain text file, where the comma is used to separate data which is saved in a tabular format.
CSV files are very easy to import and thus can be used with every spreadsheet program like ExcelSheets or GoogleSheets as well as any other storage database irrespective of whatever software you use.
CSV files as mentioned above are plain-text files. These files work as a great help for the web developers to start creating. Such files are also called Character Separated Values files.
This occurs when a character, like a semi-colon, or horizontal tab is used to separate or delimit data, instead of a comma. Some other character, like a semi-colon, or a horizontal tab, is used to separate or delimit information.
A set of values is represented in every row of a CSV file. It is delimited with a specific delimiter (the comma is the default delimiter). Every row has same number of values.
The Values from all rows that have the same index create a column. Same type of data of is represented with values in a single column.
Characteristics of a CSV File
Structure of a CSV File
Structurally, these files are ubiquitous and straightforward and are not object-oriented. Therefore, they are very easy to import, export and convert.
Entries in a typical contact list in a CSV file format will appear as name, e-mail, phone number, address.
Aravind Mahajan,email@example.com,98765-12345,420 Bright Street, Mumbai.
M K Gandhi, Mahesh@ xyzp.com, 87654-54321, Moon Avenue, Pune.
Opening a CSV file
You can view a CSV file easily in a spreadsheet program. Most of the operating systems installed in computers will have a default spreadsheet application such as MS-Excel. Otherwise, you can use an online spreadsheet like Google Sheets.
Opening in MS- Excel
Usually, most computers will have MS Excel installed as part of the operating system. By default, CSV files will open automatically in Excel when you double click the file.
You can also do it by opening MS Excel: select File > Open > and then select the CSV file.
In case if the file is not listed, you need to change the file type to TextFiles (*.prn, *.txt, *.csv)
The file is now opened, but you may find all the text in a single column and not separated by commas. To fix this:
- 1Use Text Import wizard > It will prompt you to indicate how you want the text to be separated.
- 2Select the "Delimited" option.
- 3On the next screen, choose the "Comma" option.
- 4The entire text which was bundled into a single column will get separated at each comma and will get placed in individual columns.
What is CSV file?
There may be an issue when CSV files are imported into a third- party application. When you open the file(CSV) in Excel, it will try to interpret the data in the file as per Excel's programming.
Let's say Excel interprets a data(in the CSV file) as DATE - it will change the date format automatically as per the default date setting in Excel.
This leads to a breaking of the original format (as in the CSV file) for third-party applications. A difference is thus created in the original structure of the CSV file.
The following steps ensure opening of a CSV file in Excel without breaking it-
- 1Select the Data tab in an Excel sheet.
- 2Choose "Get External Data" and click on "from text."
- 3Find your CSV file and select "Import."
- 4Once the import wizardopens, choose "Delimited"as the original data type and then click "Next."
- 5Select "Comma" as the delimiter.
- 6De-select the tab checkbox.
- 7Choose the firstcolumn in the data preview and move to the lastcolumn holding on to the shift key. You have selected all the columns as part of the data format. Click "Finish."
- 8Finally, click "OK"to insert the data into the first cell.
The spreadsheet is now ready with the imported data in the original formatting ready for third-party applications.
In case you have made some changes were made in the data while working, you will need to export the file from Excel to CSV again before uploading it onto third- party applications.
Opening in Open Office Calc
Wherever this program is installed on the computer by default, CSV files will open with a double-click in Calc.
It can also be opened by selecting File in the menu bar(File > open > select the CSV file).
Opening in Google Drive
- 1Put in your information to log into your Google account.
- 2Click “Open” to open Google Drive.
- 3Reduce the size of the window to about half the width of the monitor.
- 4Locate the file (or folder) which you want to add to Google Drive.
- 5Drag- and- drop the CSV file from its location to the open space in the My Drive section.
- 6A confirmation prompt will appear at the lower right corner of the browser window.
- 7The particular CSV file will now appear under the My Drive section.
- 8Once the upload is over, double-click the CSV file to open it.
Opening in Google Sheets
To open a CSV file in Google sheets, follow the following steps:
- 1Open Google Sheets and tap on "Start."
- 2A fresh untitled spreadsheet will open.
- 3Select the "File" menu and click on "Import."
- 4Select "Open a File" Window > go to the "Upload" tab.
- 5Select the file from whichever drive it is in your computer.
- 6Get to the import filesettings window, choose "No" for converting text numbers and dates. Next, click on the "import data"button.
- 7Your CSV file is ready and opened as a table.
- 8If required, you can freely edit this spreadsheet
- 9To save this spreadsheet in the CSV format, click on the “File” menu.
- 10Select "Download as" and click on the "Comma-separated values" button.
- 11Your CSV file is saved and ready for further use.
Importing a CSV file into an application
Significant usage of CSV files is in the area of transferring a large amount of data to other programmes. For instance, the preparation of a large departmental store mailing list requires its customer database.
The CSV file containing the necessary information has to be imported into applications that support it.
Saving CSV files
It is quite simple to save a CSV file. In a Microsoft operating system, just click on File > Save as. Select “comma-delimited, (*csv).”
To conclude, we hope you now understand that CSV files are comma-separated plain text files. They are primarily used to view tabular data.
They are also used to save and retrieve data in a spreadsheet application and to import data tables into a database application.
This also helps you to advance your skills and learn more about how you can make work easier as CSV files can arrange a large amount of data instantly.