This is documentation for Mathematica 8, which was
based on an earlier version of the Wolfram Language.
 MATHEMATICA IMPORT/EXPORT FORMAT | More About »

# CSV (.csv)

 MIME type: text/comma-separated-values, text/csv CSV tabular data format.Stores records of numerical and textual information as lines, using commas to separate fields.Commonly used in spreadsheet applications as an exchange format.CSV is an acronym for Comma-Separated Values.Plain text format.Similar to TSV.
• Import and Export fully support the CSV format and provide various data conversion and formatting options.
• Import automatically recognizes common number formats, including C and Fortran notations.
• Numbers without decimal points are imported as integers.
• Import imports a CSV file, returning an array.
• Export exports a table to a CSV file.
• Import["file.csv"] returns a list of lists containing strings and numbers, representing the rows and columns stored in the file.
• Export creates a CSV file from a table expr, using the CForm of non-numeric table elements.
• Mathematica automatically transforms arbitrary expressions to a list of lists when exporting to CSV.
• Import imports the specified element from a CSV file.
• Import imports multiple elements.
• Export creates a CSV file by treating expr as specifying element elem.
• Export treats each as specifying the corresponding .
• Export exports expr with the specified option elements taken to have the specified values.
• Export uses rules to specify the elements to be exported.
• See the reference pages for full general information on Import and Export.
• Save Selection As exports the selected part of a notebook as a CSV file.
 "Elements" list of elements and options available in this file "Rules" full list of rules for each element and option "Options" list of rules for options, properties and settings
• Data representation elements:
 "Data" two-dimensional array, representing the rows and columns of a .csv file "Grid" table data as a Grid object
 Alignment None how data is aligned within table columns CharacterEncoding "UTF8" raw character encoding used in the file
 CharacterEncoding "ASCII" raw character encoding used in the file
 "EmptyField" "" how to represent empty fields "TextDelimiters" Automatic string or list of strings used to delimit non-numeric fields
• By default, Export delimits text fields containing commas with double-quote characters.
• With an explicit setting of , Export always uses the specified string tokens to delimit text fields, effectively cycling through the list of delimiters.
• puts double quotes around each text field when exporting to CSV.
• Double-quote characters delimiting text fields are not imported by default.
 "CurrencyTokens" {{"\$", "", "", ""}, {"c", "", "p", "F"}} currency units to be skipped when importing numerical values "DateStringFormat" None date format, given as a DateString specification "EmptyField" "" how to represent empty fields "HeaderLines" 0 number of lines to skip at the beginning of the file "IgnoreEmptyLines" False whether to ignore empty lines "Numeric" True whether to import data fields as numbers if possible "NumberSigns" {"-","+"} strings to use for signs of negative and positive numbers
• Import converts table entries formatted as specified by the option to a DateList representation of the form .
• With False, numbers will be imported as strings in the form they appear in the file.
• Import automatically recognizes all common conventions for the encoding of line-separator characters.
• can be set to the following values:
 None no labels Automatic gives successive integer labels for columns and rows {"col1","col2",...} list of column labels {rhead,chead} specifies separate labels for the rows and columns
• Export encodes line separator characters using the convention of the computer system on which Mathematica is being run.
Import a CSV file, showing the first 10 entries:
Import this file, specifying what format to use for parsing dates:
Read all data from the file and plot it using DateListPlot:
Mathematica automatically converts expressions to a list of lists when exporting to CSV:
Import a CSV file, showing the first 10 entries:
 Out[1]//TableForm=
Import this file, specifying what format to use for parsing dates:
 Out[2]=
Read all data from the file and plot it using DateListPlot:
 Out[3]=

Mathematica automatically converts expressions to a list of lists when exporting to CSV:
 Out[1]=
 Out[2]=