Mathematica Stack Exchange is a question and answer site for users of Mathematica. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When importing a csv file is there a way to set the delimiter. I have a csv that uses ";" as its delimiter.

I tried

 rd = import["/Users/rolfbosscha/Downloads/rsdata.csv"]
share|improve this question
You can use ReadList which happens to be much faster than Import See for example…. With only a slight modification: change "," to ";" under RecordSeperators – RunnyKine Nov 19 '13 at 21:14
Mathematica is case-sensitive: use Import, not import. – m_goldberg Nov 19 '13 at 21:21

This seems to work:

Import["data.csv", "table", FieldSeparators -> ";"]

Should be

Import["data.csv", "Table", "FieldSeparators" -> ";"]

See help for "Table" element (ref/format/Table), specifically Options section.

share|improve this answer

I may be mistaken here, but I don't think you can switch from the standard CSV definition (commas separate values) to the one you have (commas take the role of decimal points, and semicolons are used as value separator). A workaround might be to first import as text, switch the offending characters and import that.

As a demo I use ImportString here instead of Import, but it should work almost the same for Import too.

     ImportString["1,2;2;3;4.3\n2,3;4,5;6;7", "Text"], 
     {"," -> ".", ";" -> ","}

{{1.2, 2, 3, 4.3}, {2.3, 4.5, 6, 7}}

Replace the inner ImportString with

Import["/Users/rolfbosscha/Downloads/rsdata.csv", "Text"]

to work with your file. Note that you need to use "Text" instead of "CSV".

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.