Help with .csv files

 

The Census Bureau provides CSV ("Comma Separated Value") 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

Clicking on a .csv will allow you to view it. Typically Internet Explorer will load it into Excel automatically, while other browsers like Firefox or Netscape will allow you to view the text file in the browser itself.

Right-clicking on the .csv will allow you to download the file to your computer for use in any application that you choose.

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. This is typical for some of the subcounty files that we provide. There are two ways to fix this.

Solution 1:

Solution 2: