Where is csv file

This is the tab you'll need to be on to upload the file from your computer. Select or drag the file. You can drag the CSV file to the middle of the dotted box to start the upload, or click Select a file from your device to select it from your computer. If you see a blue Select button at the bottom-left corner after choosing your file, click it to continue. Select Replace spreadsheet on the "Import file" window.

If it's already selected, you can leave it alone. Select Comma under "Separator type. Select No under "Convert text to numbers, dates, and formulas. Click the green Import data button.

This imports the CSV into sheets as it was intended to be seen. Method 3. If you don't have Microsoft Office and prefer installing an app on your computer rather than using Google Sheets, OpenOffice Calc is a great free alternative. Just select your operating system from the dropdown menu and click Download , then run the installer. The only app in the suite you'll need for CSV files is Calc, so make sure to select that one. Feel free to also install any of the other included software. Open OpenOffice Calc.

Click the File menu and select Open. This menu is in the upper left corner and will open a window to browse for files on your computer. You may have to scroll a bit down the list to find it.

Select a CSV file and click Open. This opens the "Text Import" screen. Select the "Separate By" radio button. Select the "Comma" checkbox. This tells Calc to use the commas in the CSV file to delineate individual columns.

Click OK. The contents of your CSV file will now appear correctly in Calc. Include your email address to get a message when this question is answered. This separator, called a delimiter, can be a semicolon, space, or some other character, though the comma is most common. And of course, once you've imported your CSV file into any of these programs, you can then edit the data like you would with any other file. For you. World globe An icon of the world globe, indicating different international options.

Get the Insider App. Click here to learn more. A leading-edge research firm focused on digital transformation. Good Subscriber Account active since Shortcuts. Account icon An icon in the shape of a person's head and shoulders. I run the freeCodeCamp. If you read this far, tweet to the author to show them you care. Tweet a thanks. Learn to code for free. Get started. Forum Donate. Beau Carnes. You can also import data from a CSV file into an existing worksheet. Double-click the icon to view the CSV.

Double-click that one if you like and it will open the CSV file. For example, you might acquire a CSV with a name such as Sales. It has no file extension, but spreadsheet programs such as Excel can this type of file if you launch the program and open it from within the application.