CSV and Excel File Description

Files with a comma separated value (*.csv) extension are in plain text. They contain characters stored in a flat, nonproprietary format and can be opened by most computer programs. Each *.csv file contains a set of tabular data, with each record delineated by a line break and each field within a record delineated by a comma. A field that contains commas as part of its content has the additional delineation of a quote mark character before and after the field's contents. When a quote mark character is part of a field's content, it is included as two consecutive ""quote mark"" characters.

Computers with Microsoft Excel installed open *.csv files in Excel by default, with the fields automatically arranged appropriately in columns. Other database programs also open *.csv files with the fields appropriately arranged.

The 24 CSV files (i.e., "NSDUHsubstateExcelTab#-2008.csv") reflect the "2006-2008 Substate SAE Table #" tab in the 24 Excel files. Each contains the table title, column headings, and data.

The 24 CSV Notes files (i.e., "NSDUHsubstateExcelTab#Notes-2008.csv") reflect the "Table # Notes" tab in the 24 Excel files. Each consists of a single column of records containing the table title and table notes.

Go to the Table of Contents

This is the page footer.

This page was last updated on  .