# CSV Imports **URL:** \ **Category:** General Discussion\ **Created:** [January 18, 2016, 4:11am UTC](https://forum.mautic.org/t/csv-imports/3243 "2016-01-18T04:11:38Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![eric](https://avatars.discourse-cdn.com/v4/letter/e/898d66/32.png) [@eric](https://forum.mautic.org/u/eric)\ **Post date:** [January 18, 2016, 4:11am UTC](https://forum.mautic.org/t/csv-imports/3243/1 "2016-01-18T04:11:38Z")
I’m trying to import a problematic CSV from a provider that allowed for quotes, commas and backslashes in the fields. Here’s a demo sample of the file - [https://drive.google.com/file/d/0B6V-O8LcvYUMVzNVSmRCM3FXV3M/view?usp=sharing](https://drive.google.com/file/d/0B6V-O8LcvYUMVzNVSmRCM3FXV3M/view?usp=sharing) Any suggestions for import methods? I have thousands of leads for multiple users to import so manual process is out of the question. ---
**Author:** ![eric](https://avatars.discourse-cdn.com/v4/letter/e/898d66/32.png) [@eric](https://forum.mautic.org/u/eric)\ **Post date:** [January 18, 2016, 4:11am UTC](https://forum.mautic.org/t/csv-imports/3243/2 "2016-01-18T04:11:38Z")
I’m trying to import a problematic CSV from a provider that allowed for quotes, commas and backslashes in the fields. Here’s a demo sample of the file - [https://drive.google.com/file/d/0B6V-O8LcvYUMVzNVSmRCM3FXV3M/view?usp=sharing](https://drive.google.com/file/d/0B6V-O8LcvYUMVzNVSmRCM3FXV3M/view?usp=sharing) Any suggestions for import methods? I have thousands of leads for multiple users to import so manual process is out of the question. ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [January 18, 2016, 10:46am UTC](https://forum.mautic.org/t/csv-imports/3243/3 "2016-01-18T10:46:35Z")
I’d suggest to open the CSV in Open Office Calc and then export it to CSV again using comma as delimiter, quotes as enclosure and UTF8 as encoding.