- Categories
- Computers and Electronics
- Software
- Office
Download Article
Explore this Article
methods
1Microsoft Excel
2Google Sheets
3OpenOffice Calc
Other Sections
Video
Related Articles
References
Article Summary
Written byNicole Levine, MFA
Last Updated: May 14, 2021
Download Article
Comma-separated value (CSV) files contain data from a table in a plain text format. Although CSV files can be opened with text editors, the data they contain is best viewed using a spreadsheet program. Because CSV files use a special formatting, the only way to ensure that they display correctly is to import them using a special process. This wikiHow teaches you how to properly import CSV files into Microsoft Excel, Google Sheets, and OpenOffice Calc.
Method 1
Method 1 of 3:
Microsoft Excel
Download Article
1
Open Microsoft Excel on your computer. It'll be in your Windows menu (PC) or your Applications folder (Mac).
- The simple way to open a CSV file is to click Open on the welcome screen, select your CSV file, and then click Open. However, this may not display the data in the CSV as intended. Follow this method to properly open your CSV file without losing formatting and other data.
2
Click Blank Worksheet. It's in the middle section.
Advertisem*nt
3
Click the Data tab. It's at the top of Excel.
4
Click From Text. It's on the left side of the toolbar. This opens the Import window.
5
Select the CSV file and click Import. This launches the Text Import Wizard, which lets you customize how the file imports into Excel.
6
Select Delimited. It's the first option in the upper-left corner of the window.
7
Click Next to continue.
8
See AlsoImport or export text (.txt or .csv) filesWhat's a CSV File and How Do You Open One?How to Open CSV File in Excel - Learn ExcelWhat is a CSV file? How to open and use the popular spreadsheet fileCheck the box next to "Comma." If any other items are checked in the "Delimiters" section, remove those checkmarks now.
9
Click Next to continue.
10
Select all of the columns in the preview. Here's how:
- Click the header of the first column to select it.
- Scroll to the last column list using the scrollbar if it isn't visible.
- Hold down the Shift key as you click the last column header. All columns are now selected.
11
Select Text as the column data format. This is in the upper-left corner.
12
Click Finish. Now you'll see your CSV file without any unexpected changes to its format.
Advertisem*nt
Method 2
Method 2 of 3:
Google Sheets
Download Article
1
Go to https://docs.google.com/spreadsheets. If you're already signed in to your Google account, this will display Google Sheets, the free Google alternative to Excel. If not, follow the on-screen instructions to sign in now.
- Google Sheets is free, but you must have a Google account to it. If you don’t have a Google account, click Create Account and follow the on-screen prompts to create one now.
2
Click +. It's the multicolored plus sign in the upper-left corner of the page. This creates a blank Sheets file.
3
Click the File menu. It's at the top-left corner of Sheets.
4
Click Import. The "Import file" window will open.
5
Click the Upload tab. This is the tab you'll need to be on to upload the file from your computer.
6
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.
7
Select Replace spreadsheet on the "Import file" window. If it's already selected, you can leave it alone.
8
Select Comma under "Separator type." This tells Sheets to use commas as the separators, which is important for CSV files.
9
Select No under "Convert text to numbers, dates, and formulas." This prevents Sheets from changing the contents of the file during the import.
10
Click the green Import data button. This imports the CSV into sheets as it was intended to be seen.
Advertisem*nt
Method 3
Method 3 of 3:
OpenOffice Calc
Download Article
1
Download OpenOffice from OpenOffice Calc. 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.
2
Open OpenOffice Calc. Once you've installed the software, you'll find Calc in your Windows menu (PC) or the Applications folder (Mac).
3
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.
4
Select Text CSV in the "File type" menu. You may have to scroll a bit down the list to find it.
5
Select a CSV file and click Open. This opens the "Text Import" screen.[1]
6
Select the "Separate By" radio button. This is under the “Separator Options” header.
7
Select the "Comma" checkbox. This tells Calc to use the commas in the CSV file to delineate individual columns.
8
Click OK. The contents of your CSV file will now appear correctly in Calc.
Advertisem*nt
Video
You Might Also Like
Advertisem*nt
About This Article
![3 Ways to Open CSV Files - wikiHow (50) 3 Ways to Open CSV Files - wikiHow (50)](https://i0.wp.com/www.wikihow.com/images/thumb/f/fe/Nicole_Levine.png/-crop-100-100-99px-Nicole_Levine.png)
Written by:
Nicole Levine, MFA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 389,277 times.
How helpful is this?
Co-authors: 7
Updated: May 14, 2021
Views:389,277
Categories: Office
Article SummaryX
1.Open a blank worksheet in Excel.
2.Click the Data tab and select From Text.
3.Select the CSV file and click Import.
4.Select "Delimited" and choose Next.
5.Check the box next to "Comma" and click Next.
6.Select all of the columns in the preview.
7.Click Finish.
Did this summary help you?
In other languages
Russian
French
Spanish
Indonesian
Portuguese
Arabic
Chinese
Thai
Hindi
Korean
Turkish
- Send fan mail to authors
Thanks to all authors for creating a page that has been read 389,277 times.
Is this article up to date?
Advertisem*nt