# can't import CSV

**URL:** <https://forum.mautic.org/t/cant-import-csv/7185>\
**Category:** Product Support\
**Created:** [January 16, 2017, 3:05pm UTC](https://forum.mautic.org/t/cant-import-csv/7185 "2017-01-16T15:05:43Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Benoitp](https://avatars.discourse-cdn.com/v4/letter/b/c4cdca/32.png) [@Benoitp](https://forum.mautic.org/u/Benoitp)\
**Post date:** [January 16, 2017, 3:05pm UTC](https://forum.mautic.org/t/cant-import-csv/7185/1 "2017-01-16T15:05:43Z")

</div>

i have this message  
  
invalid file type “application/octet-stream”. Use a file that matches of of the following mime types: “text/csv”, “text/plain”.  
  
  
  
but i tried a csv file from excel (Mac-Lion) and openoffice. Nothing works??? Someone can help me.

---

<div class="post-metadata">

**Author:** ![Benoitp](https://avatars.discourse-cdn.com/v4/letter/b/c4cdca/32.png) [@Benoitp](https://forum.mautic.org/u/Benoitp)\
**Post date:** [January 16, 2017, 3:05pm UTC](https://forum.mautic.org/t/cant-import-csv/7185/2 "2017-01-16T15:05:43Z")

</div>

i have this message  
invalid file type “application/octet-stream”. Use a file that matches of of the following mime types: “text/csv”, “text/plain”.

but i tried a csv file from excel (Mac-Lion) and openoffice. Nothing works??? Someone can help me.

---

<div class="post-metadata">

**Author:** ![kerid0](https://avatars.discourse-cdn.com/v4/letter/k/9fc348/32.png) [@kerid0](https://forum.mautic.org/u/kerid0)\
**Post date:** [January 16, 2017, 4:35pm UTC](https://forum.mautic.org/t/cant-import-csv/7185/3 "2017-01-16T16:35:24Z")

</div>

@Benoitp  
Import from excel does not work.  
I copied my data from excel and inserted them into Google Spread Sheets then made import to csv. It worked.

---

<div class="post-metadata">

**Author:** ![Benoitp](https://avatars.discourse-cdn.com/v4/letter/b/c4cdca/32.png) [@Benoitp](https://forum.mautic.org/u/Benoitp)\
**Post date:** [January 18, 2017, 4:49pm UTC](https://forum.mautic.org/t/cant-import-csv/7185/4 "2017-01-18T16:49:37Z")

</div>

Thank you but google spread sheets didn’t work for me. When you have the data in Google spread sheets, do i need to do another action in googlesheet? because the file is in .gsheets

---

<div class="post-metadata">

**Author:** ![Benoitp](https://avatars.discourse-cdn.com/v4/letter/b/c4cdca/32.png) [@Benoitp](https://forum.mautic.org/u/Benoitp)\
**Post date:** [January 19, 2017, 3:52pm UTC](https://forum.mautic.org/t/cant-import-csv/7185/5 "2017-01-19T15:52:11Z")

</div>

I’m on imac (El capitan) - i haven’t Notepad but i change the encodage to UTF-8 with smultron (edit app)  
and i still get the same error.  
I tried the same file with InterSpire Email and the import worked well.  
Is there incompatibility from Mac users? is it the file ?  
need your help to use this

---

<div class="post-metadata">

**Author:** ![Benoitp](https://avatars.discourse-cdn.com/v4/letter/b/c4cdca/32.png) [@Benoitp](https://forum.mautic.org/u/Benoitp)\
**Post date:** [January 20, 2017, 1:29pm UTC](https://forum.mautic.org/t/cant-import-csv/7185/6 "2017-01-20T13:29:18Z")

</div>

Ok thank you, it worked but only for a part of the file. After waiting 2 hours with a page “Import in progress” with no process.  
I’ve been in segment and i see contacts but only 1009 contacts and the file has 2900 contacts???  
Do i have to wait longer??? no progress bar…

---

<div class="post-metadata">

**Author:** ![Benoitp](https://avatars.discourse-cdn.com/v4/letter/b/c4cdca/32.png) [@Benoitp](https://forum.mautic.org/u/Benoitp)\
**Post date:** [January 21, 2017, 1:17pm UTC](https://forum.mautic.org/t/cant-import-csv/7185/7 "2017-01-21T13:17:29Z")

</div>

yes