Featured:
Allergies
Tech Know
Grilling Guide
eHow Now Blog

How to Read Data From CSV File

CSV stands for a Comma Separated Value file format. This is a plain text format that is usually used to transfer records between databases. The records in CSV files consist of fields separated with a comma -- "May, 115.10," for example. Use any text editor such as Notepad included in Windows to read a CSV file. In addition Microsoft Excel directly supports this format.

Instructions

  1. Using Microsoft Excel

    • 1

      Start Microsoft Excel.

    • 2

      Press the keys "Ctrl" and "O" to open the file browsing window.

    • 3

      Find a CSV file on your computer using the browsing window.

    • 4

      Double-click on the CSV file to read it in Excel; each record will be in a separate row in the Excel spreadsheet.

    Using Windows Notepad

    • 5

      Click "Start" in Windows and expand "All Programs."

    • 6

      Open the folder "Accessories" and click on "Notepad" to start the text editor.

    • 7

      Click the menu "File" in Notepad and choose "Open" to bring up the browsing window.

    • 8

      Select "All Files" in the file type box and find a CSV file on your computer using the browsing window,

    • 9

      Double-click on the CSV file to read the text file content in Notepad.

Related Searches:

References

Comments

You May Also Like

  • 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 Load Oracle Data From a CSV File

    An Oracle database provides your company with a powerful database engine that stores all of the business records. A CSV file is...

  • How to Read a CSV File in C

    Many software products that deal with numbers and calculations have the ability to output data into a Comma Separated Value (CSV) file....

  • 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 Convert XLS to CSV on Perl

    Companies commonly use Excel to store tables of data. Often, those companies will find a use for that data that requires converting...

  • How to Read a CSV File Into Java

    CSV, or Comma Separated Value, files are commonly used as a universal format for exchanging simple data, especially between spreadsheet applications. The...

  • How to Import CSV Files From Outlook to Hotmail

    Comma Separated Value (CSV) is a common file format used to store numerical and text data and to share the data across...

  • How to Create CSV Files

    A CSV file (.csv extension) is a comma delimited, plain text file. These files are preferred for applications that transfer information across...

  • How to Read a Comma Delimited File in Visual Basic

    Visual Basic is a popular programming language created by Microsoft. Visual Basic provides a wide array of functions and methods, allowing programmers...

  • How to Read a Random Access File

    Random access files store records of settings for an application. Simple text files are read line-by-line in the order in which they...

Related Ads

thumbnail
Featured