Help with Comma Separated Value (.csv) Files



The Department of Education provides Comma Separated Value (CSV) data files for download. This format allows for data to be easily loaded into a variety of applications. However, they are best viewed in applications that allow data to be manipulated in columns, most common of which are spreadsheets or databases (Excel, Access, etc.).

Viewing .csv files

Common Problem: CSV is too Large for Excel

Some of the .csv files will not load into Excel directly because they have too many rows of data. There are two ways to fix this:

Solution 1:

Solution 2:


Last Modified: 02/12/2015