I have an excel file with data in several columns I want to upload with php (Mac 10.8.2, office2011).

After many detours with decoding issues I ended up with opening the excel file in word, converting to text, copiing into TextEdit and saving as utf-8.

Uploading with `file($myFile);` works fine, but `$medienarray = file($myFile);
print_r($medienarray);` shows that all line breaks are deleted.

But if I manually delete the line breaks in the TextEdit file and type them again, they are recognized after a new upload.

I tried replacing `"\r"` with `"\n"` with a regex:

```
preg_replace('/\r/','/\n/',$medienarray[0],-1,&$anzahl);

```

It shows 20 replacements with no effect.

There are too many data lines to replace all line breaks manually.

Uploading any other text files not created from an excel file work without any line break problems