Featured:
Allergies
Tech Know
Grilling Guide
eHow Now Blog

How to Read a CSV File in Excel

A comma-separated value (CSV) file can be used to upload information to a database, or it can be created from a device or online application. Fields in a CSV file are separated by commas, and line breaks separate these fields into rows. CSV files can also be viewed in Microsoft Excel, where they are applied to the spreadsheet format that is native to Microsoft Excel. Windows can be configured so that it opens any CSV file in Excel by default.

Instructions

    • 1

      Click "Start" at the bottom left corner of the screen and select Default Programs from the right side of the Start menu.

    • 2

      Click "Associate a file type or protocol with a program."

    • 3

      Scroll to ".csv" and click it once to highlight the listing in blue.

    • 4

      Click "Change program" at the top of the window.

    • 5

      Click "Microsoft Office Excel" and click "OK."

    • 6

      Browse to a CSV file and double-click it to open the file in Microsoft Excel.

Tips & Warnings

  • You can also create CSV files in Excel by clicking the File tab at the top of the screen, then selecting Save As. Click the drop-down menu next to "Save as type" and choose the "CSV" option.

Suggest item

Related Searches:

References

Comments

You May Also Like

  • How to Save As CSV File in Excel

    Comma separated value (CSV) files are text files formatted as a spreadsheet. CSV files are created to import information into a database....

  • How to Create a CSV File From Excel

    Comma-separated value, or CSV, files are text files used to transfer data between the spreadsheets manufactured by different companies. Each cell's value...

  • How to Convert CSV File to Excel

    CSV file type (known as comma-separated values or comma delimited text files) is one reliable, conversion-friendly file format. Converting a CSV file...

  • How to Append a PowerShell Output to an XLS Excel File

    Windows PowerShell is a command line-based scripting tool that comes with the Windows operating system. Administration tasks are performed using cmdlets (command-lets...

  • How to Make an Excel CSV File

    CSV stands for Comma Separated Values. (It is also sometimes referred to as a Comma Separated Variables file). CSV refers to a...

  • How to Convert Excel Data to Comma Separated Text

    Comma separated text is actually called CSV or "Comma Separated Value." This file format is often used to exchange data between applications...

  • How to Read a CSV File

    Comma Separated Value (CSV) files are used to exchange data between applications on different platforms and in different programs. The format is...

  • How to Create CSV Files in Excel 2007

    Microsoft Excel 2007 users can export spreadsheets into dozens of file formats. This is particularly valuable when you are trying to share...

  • How to Read a CSV File in ASP

    Active Server Pages (ASP) is a server side scripting language produced by Microsoft. It offers a wide range of programming functions that...

  • How to Create a Comma-Separated File

    Comma Separated Values (CSV) is a file format used for storing text-based information. The data in a CSV file are stored as...

  • How to Import a CSV to Windows Mobile

    Windows Mobile devices offer users the ability to create, edit, store and transport various file types. Microsoft's mobile-based version of the Excel...

  • How to Import a CSV File into Excel

    CSV, or Comma Separated Value, is a format of computer file used to transfer data between different spreadsheet or database formats. CSV...

Related Ads

thumbnail
Featured