What is CSV File?
CSV stands for Common Separated Values File. A CSV file, in general, is a plain text file consist of a list of data. CSV files, used for exchanging the data between the various applications.
CSV files are sometimes called the Character Separated Values or the Comma Delimited Files. The idea behind this is you can export complex data from one program to a CSV file then import the data in the CSV file into another program.
Methods to Open CSV File
Method 1: By Using Microsoft Excel
1.Open Microsoft Excel on PC:
However, it may not show the data in the CSV file as intended. Open your CSV file by following this method very carefully and without losing formatting and other data.
2.Click on the Blank Worksheet tab:
The Blank Worksheet tab is lying in the middle section.
3.Click on the Data button:
The Data button sits at the top of Microsoft Excel.
4.Click on the “From Text” button:
The “From Text” button lies on the left side of the toolbar. It opens up the Import Window.
5.Select the CSV File and then click on the “Import” tab:
It launches the Text Import Wizard that allows you to customize how the file gets imports into Microsoft Excel.
6.Select the Delimited Button:
It lies in the upper left corner of the window.
7.Then check the box next to the “Comma” key:
In any other items, it is checked in the “Delimiters” section to remove those checkmarks now.
8.Click the Next button again to continue.
9.Select all the columns in Preview:
- Firstly, click on the header of the first column to select the file.
- Then scroll down to the last column list by using the scrollbar if it gets visible.
- Press the Shift Key and hold it on the keyboard as you click the last column header. All columns are now selected.
10.Select the Text button as the column data format.
11.Click on the Finish tab:
Now you will see the CSV file without any way Using unexpected changes to its file format.
Method 2: By Using Google Sheets
1.Go to docs.google.com to open the spreadsheets:
If you already signed in to your Google account, it would show the Google Sheets, the free Google alternative to Microsoft Excel. If not, then follow the on-screen instructions to sign in Now.
- Google Sheets are free, but you should have a Google account to it. If you don’t have a Google account earlier, then click on the Create Account and then follow the on-screen prompts to create one new account now.
2.Click on the + button:
It is the multicolored plus sign in the upper left corner of the page. It creates the blank sheets file.
3.Click on the “File” menu situated at the top left corner of the sheets.
4.Click on the Import button:
5.Click on the Upload button:
It is the button where you need to rely on to upload the file from the PC.
6.Select or Drag the File:
You can then drag the CSV file in the middle of the dotted box to begin the Upload process or click on the command “Select a file from the device” to select it from the PC.
If you find a blue Select tab at the bottom left corner after selecting the CSV file, click on it to continue.
7.Select the Replace Spreadsheet button on the Import File window:
If it’s already selected, you can leave it alone.
8.Select the Comma button under the “Separator Type”:
It tells the Sheets to use the commas as the separators that are essential for the CSV files.
9.Then select the No button under the “Convert text to the numbers, dates and the formulas”:
It prevents the Sheets from changing the contents of the file during the import.
Method 3: By Using Open Office Calc:
1.Download OpenOffice from the OpenOffice Calc:
If you don’t have Microsoft Office and prefer installing an application on PC rather than Using Google Sheets, OpenOffice Calc is the great free alternative. Just select the operating system from the dropdown list and click on the Download button and then run the installer. The only application you would require for CSV files is Calc, so ensure you select that app and feel free to install any other included software.
2.Open OpenOffice Calc:
Once you installed the software, you will find the Calc on your PC or the Mac.
3.Select the Text CSV button in the File Type menu:
You then scroll down a bit of the list to search it.
4.Select the CSV file and then click on the Open button:
It opens the “Text Import” window.
5.Select the “Separate By” radio tab:
It lies under the “Separator Options” header.
6.Select the “Comma” tab to the checkbox:
It tells the Calc button to use the commas in the CSV file to delineate individual columns.
7.Click on the OK button:
The contents of the CSV file will appear correctly in the Calc software.