How to View, Open, and Edit a .CSV on Windows or Mac

PDF download Download Article
The easiest and best ways to open and edit CSV files on a PC or Mac
PDF download Download Article

Comma-separated value (CSV) files contain data from a table in a plain text format, separate with commas. The best way to open a CSV file is to import it into a spreadsheet application like Excel or Google Sheets. This wikiHow teaches you how to properly import CSV files into Microsoft Excel, Google Sheets, and OpenOffice Calc.

Quick Steps

  1. Create a new blank Excel file.
  2. Click the Data tab.
  3. Select From Text/CSV .
  4. Select the CSV file and click Import .
  5. Click Load .
Method 1
Method 1 of 4:

Microsoft Excel 2016 and Later

PDF download Download Article
  1. Open Excel, then click Blank Workbook to start a new file.
    • Follow this method to properly open your CSV file without losing formatting and other data.
    • These steps will work in Microsoft Excel 365, 2019, and 2016.
  2. It's at the top of Excel. [1]
    Advertisement
  3. It's on the left side of the toolbar. This opens the Import window.
  4. This launches the Text Import Wizard, which lets you customize how the file is imported into Excel.
  5. You'll see a preview of how the CSV will look once opened in Excel. The commas in the file delimit the data so that it's separated into rows and columns automatically. You usually won't have to make any changes to the settings, but if the data isn't displaying properly, it may be delimited with a different symbol, like a semicolon or pipe.
  6. This opens the CSV file for viewing and editing in Microsoft Excel.
    • If you make changes to the data and want to save it as an Excel file, click the File menu, select Save As , and make sure "Excel Workbook (*.xlsx)" is selected as the file type.
    7. Advertisement
Method 2
Method 2 of 4:

Microsoft Excel 2013 and Earlier

PDF download Download Article
  1. It's in the middle section. This creates a new blank spreadsheet.
    • 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. It's at the top of Excel.
  3. It's on the left side of the toolbar. This opens the Import window.
  4. This launches the Text Import Wizard, which lets you customize how the file imports into Excel.
  5. It's the first option in the upper-left corner of the window.
  7. If any other items are checked in the "Delimiters" section, remove those checkmarks now.
  9. 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.
  10. This is in the upper-left corner.
  11. Now you'll see your CSV file without any unexpected changes to its format.
    12. Advertisement
Method 3
Method 3 of 4:

Google Sheets

PDF download 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 use it.
  2. 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, then click + Blank spreadsheet to create a new file.
  3. The "Import file" window will open.
  4. This is the tab you'll need to be on to upload the file from your computer.
  5. You can drag the CSV file to the middle of the dotted box to start the upload, or click Browse to select it from your computer.
  6. If it's already selected, you can leave it alone.
  7. This tells Sheets to detect the delimiter used to separate the data into rows and columns.
    • In CSV files, delimiters are usually columns, but they may vary by region and purpose. Sometimes you'll see pipe symbols or semicolons instead.
  8. The option is selected by default, but you can deselect it if you don't want to transform the data in any way.
  9. This imports the CSV into sheets as it was intended to be seen.
    10. Advertisement
Method 4
Method 4 of 4:

OpenOffice Calc

PDF download Download Article
  1. If you have OpenOffice, you can use Calc to open a CSV file.
    • 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. You can download it https://www.openoffice.org/download .
  2. This menu is in the upper left corner and will open a window to browse for files on your computer. [2]
  3. You may have to scroll a bit down the list to find it.
  4. This opens the "Text Import" screen.
  5. This is under the “Separator Options” header.
  6. This tells Calc to use the commas in the CSV file to delineate individual columns.
    • If the data is using a different delimiter, select that instead. If the delimiter character isn't in the list, enter it into the "Other" box.
  7. The contents of your CSV file will now appear correctly in Calc.
    8. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • You can also open CSV files in a text editor if you just want a quick glance at their contents, but the files will not display in a super-readable format.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      2 Easy Methods for Creating a CSV File
      How to
      Get a Calendar on Your Desktop
      How to
      Easily Import Data from Evernote to OneNote
      7 Simple Ways to Add a Check Mark to a Word Document
      3 Quick Ways to Open a Pages File on PC or Mac
      How to
      Open WordPad in Windows 10
      How to
      Redact or Black Out Text in Word: 3 Ways
      How to
      Use Notepad++
      How to
      Delete Recent Documents in Microsoft Word or Excel
      How to
      Change the User Interface Language of LibreOffice
      How to
      Format a Word Document to Look Professional
      A Complete Beginner's Guide to Use LibreOffice
      40 Funny Pranks to Make The Whole Office Laugh
      How to
      Open Notepad
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
      2. ↑ https://wiki.openoffice.org/wiki/Documentation/AOO4_User_Guides/Getting_Started/Getting_Started_with_Calc/Open_and_Save_CSV_files

      About This Article

      Article Summary X

      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
      Thanks to all authors for creating a page that has been read 401,981 times.

      Is this article up to date?

      Advertisement