Most spreadsheet programs, like Microsoft Excel or Google Spreadsheets, can open CSV files. CSVs look like regular spreadsheets, except that they end in.csv. Read: How to Reset PS5 Controller What is CSV FileĪ comma-separated values file (CSV) is a file that lets you save data in a table format. If it is set to “Text Documents” right now, change it to “All Files.” Depending on the editor, you may have to click a drop-down menu to the right of the “File name” field. In the “Open File” window, choose the CSV file.Open a text editor like TextEdit or Windows Notepad.It doesn’t usually look good, but it makes it easy to see what’s in the file. Instead, the data will be separated by a comma or some other symbol. When you’re done, click the “Finished” button.Ī text editor won’t automatically format or structure the CSV file for you like a spreadsheet will. If you need to, you can click on a column to change how the data is formatted.When the preview looks structured and organized, you’ll know you’ve chosen the right delimiter. Choose the type of delimiter that is being used in the file.Most of the time, you’ll want to choose the option to import delimited data (a comma or another separator) and click Next. To open the CSV, use the Text Import Wizard.Find the place where the CSV file is kept and click on it.The default is usually All Excel Files, but you should change it to All Files. Click Browse, then click the drop-down menu to the right of the File name field in the File Explorer box.Click the File tab on the ribbon, and then click Open.Read: How to Add Photos to iPhone Contacts How to Open CSV File In MS Excel

Open csv file in google sheets