Any file containing text that is separated by a comma, but can also be a file separated by any other character, is referred to as a CSV (comma-separated values) file.
A CSV file may be opened in any software, however, for the majority of users, a spreadsheet tool like Microsoft Excel, OpenOffice Calc, or Google Docs is the ideal way to see a CSV file.
If Microsoft Excel is already installed on the PC, double-clicking a CSV file should automatically open it in Excel.
Select Microsoft Excel from the list of apps to open the CSV file if you receive an Open With prompt when doing so.
As an alternative, you may launch Microsoft Excel and choose File, Open from the menu bar before choosing the CSV file.
Make sure you choose Text Files (*.prn, *.txt, *.csv) as the file type to be opened if the file is not mentioned.
Open the CSV file in Microsoft Excel if, after opening it, the content seems to be in a single column rather than being divided by commas.
Use the Text Import Wizard, which asks you how you want the text divided, to indicate your preferences.
Select the Delimited option, then select the Comma option on the following page.
The text will be divided into different columns and spaced at each comma.
The CSV file’s formatting may be a problem if you don’t see the Content Import Wizard and the text is still in a single column.
Microsoft Excel considers double quotes surrounding each line of text as a single record rather than as distinct records.
To check for double quotes around the text lines, open the CSV file in a text editor.
You can attempt removing any double quotes from the beginning and end of each line in the CSV file, after which you can try opening the document in Excel once more.
- Open Google Drive.
Log into your Google account if requested.
- Resize the window to a smaller scale, half of the width of the monitor or less works well.
- Find the folder or file that you want to add to Google Drive.
- Drag and drop the CSV file from where it is now located to the empty area in the My Drive section’s center.
- A confirmation prompt will appear in the lower-right corner of the browser window if the file was uploaded correctly.
The CSV is now visible in the My Drive area as well.
- Open the CSV file by double-clicking it when the upload is complete.
When a CSV file is double-clicked, Calc should launch immediately if OpenOffice is already installed on the PC.
Select OpenOffice Calc from the list of apps to open the CSV file if you receive an Open With prompt when doing so.
As an alternative, you may launch OpenOffice Calc and choose File, Open from the menu bar before choosing the CSV file.