Code covered by the BSD License  

Highlights from
CSVIMPORT

4.88889

4.9 | 19 ratings Rate this file 302 Downloads (last 30 days) File Size: 4.59 KB File ID: #23573

CSVIMPORT

by

 

06 Apr 2009 (Updated )

CSVIMPORT reads the specified CSV file and stores the contents in a cell array or matrix.

| Watch this File

File Information
Description

  CSVIMPORT reads the specified CSV file and stores the contents in a cell array or matrix
 
  The file can contain any combination of text & numeric values. Output data format will vary
  depending on the exact composition of the file data.
 
  CSVIMPORT( fileName ): fileName - String specifying the CSV file to be read. Set to
                    [] to interactively select the file.
 
  CSVIMPORT( fileName, ... ) : Specify a list of options to be applied when importing the CSV file.
                    The possible options are:
                    delimiter - String to be used as column delimiter. Default
                    value is , (comma)
                    columns - String or cell array of strings listing the columns
                    from which data is to be extracted. If omitted data
                    from all columns in the file is imported. If file
                    does not contain a header row, the columns
                    parameter can be a numeric array listing column
                    indices from which data is to be extracted.
                    outputAsChar - true / false value indicating whether the data
                    should be output as characters. If set to false the
                    function attempts to convert each column into a
                    numeric array, it outputs the column as characters
                    if conversion of any data element in the column
                    fails. Default value is false.
                    uniformOutput - true / false value indicating whether output can be
                    returned without encapsulation in a cell array.
                    This parameter is ignored if the columns / table
                    cannot be converted into a matrix.
                    noHeader - true / false value indicating whether the CSV
                    file's first line contains column headings. Default
                    value is false.
                    ignoreWSpace - true / false value indicating whether to ignore
                    leading and trailing whitespace in the column
                    headers; ignored if noHeader is set to true.
                    Default value is false.
 
  The parameters must be specified in the form of param-value pairs, parameter names are not
  case-sensitive and partial matching is supported.
 
  [C1 C2 C3] = CSVIMPORT( fileName, 'columns', {'C1', 'C2', C3'}, ... )
    This form returns the data from columns in output variables C1, C2 and C3 respectively, the
    column names are case-sensitive and must match a column name in the file exactly. When fetching
    data in column mode the number of output columns must match the number of columns to read or it
    must be one. In the latter case the data from the columns is returned as a single cell matrix.
 
  [C1 C2 C3] = CSVIMPORT( fileName, 'columns', [1, 3, 4], ,'noHeader', true, ... )
    This form returns the data from columns in output variables C1, C2 and C3 respectively, the
    columns parameter must contain the column indices when the 'noHeader' option is set to true.

Notes: 1. Function has not been tested on badly formatted CSV files.
            2. Created using R2007b but has been tested on R2006b.

MATLAB release MATLAB 7.5 (R2007b)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (35)
28 Sep 2014 stijn  
16 Sep 2014 Oscar  
31 Jul 2014 azizullah khan

sir, if csvexport is kindly share it with me..i am facing a problem with csvwirte i.e Error using dlmwrite (line 112)
The input cell array cannot be converted to a matrix.

31 Jul 2014 Adam Li

Great code!

Only issue I really don't understand is why I have to save the file as a Windows CSV file in order for it to work. My code didn't work when the files were saved as only CSV; the column vectors came back empty. Do you think you would be able to fix this problem?

Thanks!

16 Jul 2014 Ashish Sadanandan

@Fan
Try adding a newline to the end of the file

16 Jul 2014 Fan

Works, any idea why it does not import the last row of the data?

10 Jul 2014 Poolla

Awesome, saves lot of otherwise work. Keep it up!

09 Jul 2014 Ged Ridgway

@Marcos, I had a similar problem, which seems to be fixed by adding a carriage return at the end of the csv file (e.g. using the MATLAB editor).

13 Jun 2014 Marcos

Fantastic function, but I am confused by it's behavior with one of the files I need to import.

The format is
# header1 header2 ..... headern
1 v1..............v2.................vn
2 v1..............v2.................vn
.
.
.
11 v1..............v2.................vn

The values are mixed between numeric and chars, but the function only imports the first 11 rows, including the header, so the entire bottom row that starts with 11 is missing.

If I set 'noHeader' to true, then I get all 11 rows with values. I would prefer to not have to do this, so can someone explain why this would be happening?

18 Mar 2014 jason

Pretty cool function. However, It would be nice if it called the imported date by the orginal file name and not 'ans'

24 Oct 2013 DBS  
03 Oct 2013 Greg

Added support for commas that are in between double quotes. so that they stay in one cell. First it replaces commas than are not in between quotes to semicolons, then splits by semicolons. Then removes the quotes. Starts at line 246 (the main for loop)

rowData = fgetl( fid );
if isempty( rowData )
emptyRowsIdx = [emptyRowsIdx(:); ii];
continue
end
%*** added by GSS
repIdx = regexp(rowData, '(?:^|,)(?:"((?:[^"]|"")*)"|([^",]*))');
rowData(repIdx(2:end))=';';
rowData = regexp(rowData,';','split');
for j=1:length(rowData)
if ~isempty(rowData{j}) && rowData{j}(1)=='"'
rowData{j}(1)=[];
rowData{j}(end)=[];
end
end
%****end GSS
nDataElems = numel( rowData );

04 Jul 2013 Jason Kreykes

Some of the entries in the first column of my data contain a comma that should not be interpreted as a delimiter.

For example, the first three rows (with header row) are:
"School","Section Discipline"
"ACS Cogham International HS, UK","Physics"
"Adelphi University","Mathematics"

Can this be accomodated easily?

12 Jun 2013 Dimid Duchovny

Works great. Thanks you!

09 May 2013 vlema

Great function! It worked in a badly formatted csv file. thanks for sharing.

01 Apr 2013 Chris

@Bernoulli Lizard: As Warwick said, if you're a Mac user you need to change the csv to a Windows format. If you you have Perl, using this line in a terminal will do:
perl -p -i -e 's/\r/\n/g' *.csv

05 Jan 2013 Steven Mvuyana

Good day Ashish

Why does the file convert the first colunm to char type?

Excellent CSV import function. Thank you.

02 Oct 2012 Bernoulli Lizard

Chris, what did you do to read more than the first row? I'm having the same problem.

25 May 2012 Ashish Sadanandan

Hi Sayanta,
Call the function as follows:

[C1 C2 C3 C4 C5] = csvimport( 'path\to\file.csv', 'columns', [1:5], 'noHeader', true, 'delimiter', ';' )

22 May 2012 Sayanta

Hello Asish,

Here is the data I want to parse / import with mat lab code. I try to
use your function

[C1] = CSVIMPORT( 'CPU.csv', 'columns',{} );

Here is my data

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;04/04/2012;11:04:46;77

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;
04/04/2012;11:04:47;66.9016

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;
04/04/2012;11:04:47;67.0833

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;04/04/2012;11:04:47;66.1

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;
04/04/2012;11:04:48;66.3115

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;
04/04/2012;11:04:49;66.3934

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;
04/04/2012;11:04:49;86.8525

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;
04/04/2012;11:04:49;78.7288

Patrol7;/NT_CPU/CPU_0/CPUprcrInterruptsPerSec;
04/04/2012;11:04:50;66.4918

I'm getting all data in C1 cell. I want my data (Delimited) in C1 C2 C3 C4 C5 in 5 different cell.

Could you please tell me how can I resolve my problem

Thanks in advance
Sayanta

19 Feb 2012 Ben

You rock! Thank you. The best csv-import function out there.

29 Aug 2011 Warwick

If your'e a Mac user - I found that I had to save the .csv file as a "Windows comma delimted csv" file beforehand. Then it works superbly.

12 Aug 2011 Yuri K

I get a figure window open during this function run at line 275. It appears that I had a string 'White(some information)' that probably runs function white. Anyway to prevent such behavior?

15 Jul 2011 Cheol Hee

Very nice!!! But data replaced some numbers. Fantastic!!

15 Jul 2011 Cheol Hee  
10 Jun 2011 Chris

I got it figured out. Works great!

10 Jun 2011 Chris

It's only reading in the first row. Am I mixing up an argument? My .csv uses commas as the delimiter (obviously) but also has a 'return' to separate each row. Is this valid? Thanks.

05 May 2011 Mais

well done! best csv-import function, i found here!

08 Apr 2011 Christopher Hummersone

Fantastic!

14 Dec 2009 Gordon

This only worked on ascii files, but combined with unicode2ascii
it did a fantastic job.

18 Nov 2009 Gordon

Hi

Is it possible to use this code, or anything else for a csv file available on the web, ie:

http://www.google.com/insights/search/overviewReport?q=matlab&geo=US&cmpt=q&content=1&export=2

thanks

28 Oct 2009 Ashish Sadanandan

Maney,
Try running 'which -all isscalar' at the command line, if MATLAB doesn't find any function by that name then you're either using an old version which doesn't have this function or you have problems with the MATLAB search path. Let's assume it's the former since you'd probably be having other errors too if the cause were to be the latter.

ISSCALAR simply checks whether the operand is a 1x1 matrix. You can replace isscalar(x) with (numel(x) == 1) OR (prod(size(x)) == 1)

HTH,
Ashish

27 Oct 2009 maney

Hi Ashish,
I ran your code and I am getting the following error:

??? Undefined function or variable 'isscalar'.

please advise,
Thanks - maney

24 Aug 2009 vadim

Great job!

24 Aug 2009 vadim  
Updates
28 Apr 2009

Corrected typo in an error message
Added igonoreWSpace option

18 Aug 2011

Replaced calls to str2num with str2double, the former uses eval leading to unwanted side effects if cells contain text with function names

Contact us