Title: Format not working, no rows found
Last modified: April 15, 2019

---

# Format not working, no rows found

 *  Resolved [pedrovoorwinden](https://wordpress.org/support/users/pedrovoorwinden/)
 * (@pedrovoorwinden)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/format-not-working-no-rows-found/)
 * Hi,
 * I can’t get any format to work, the file is uploaded and the top column names
   are shown, but no rows are found.
    If I save a Excel file to CSV, it doesnt work,
   Editing it with Notepad doesn’t work. Not even when altering the test file, given
   in the documentation provided with the plugin, with Notepad or Excel.
 * My csv file looks like this:
 *     ```
       Username;Email;Password;first_name;last_name
       myfirstusername;myemail@email.com;mypassword;First;Last
       mysecondusername;myemail@email.com;mypassword;First;Last
       ```
   
 * When I upload the test file directly it does work.
 * What should I do?
 * Kind regards,
 * Pedro
    -  This topic was modified 7 years, 2 months ago by [pedrovoorwinden](https://wordpress.org/support/users/pedrovoorwinden/).

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/format-not-working-no-rows-found/#post-11429125)
 * [@pedrovoorwinden](https://wordpress.org/support/users/pedrovoorwinden/),
 * Have you tried using some good CSV software program like LibreOffice?
 * We have never had problems with it.
 *  Thread Starter [pedrovoorwinden](https://wordpress.org/support/users/pedrovoorwinden/)
 * (@pedrovoorwinden)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/format-not-working-no-rows-found/#post-11429214)
 * Hi,
 * I just installed LibreOffice and tried creating a CSV file and test it with the
   plugin.
    LibreOffice however, returns the same output as every program I used,
   and unfortunately, it didn’t work. I still get te header columns and no output
   rows. Can you provide me with the location of PHP functions that are used to 
   decode the csv file so I can see if I can debug the problem with PHPStorm and
   xDebug? Maybe that way I can find a solution.
 * Kind regards,
 * Pedro
 *  Thread Starter [pedrovoorwinden](https://wordpress.org/support/users/pedrovoorwinden/)
 * (@pedrovoorwinden)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/format-not-working-no-rows-found/#post-11429854)
 * Hi,
 * I’ve looked into the code and found out what is happening. The CSV file I was
   using, contained 2 rows, both rows used emails that were already in use by the
   application. It was not allowed to create 2 accounts with the same email. So 
   the code skipped both, resulting in 0 rows to execute. It was my fault all along..
 * Kind regards,
 * Pedro
 *  Plugin Author [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * (@carazo)
 * [7 years, 2 months ago](https://wordpress.org/support/topic/format-not-working-no-rows-found/#post-11430413)
 * [@pedrovoorwinden](https://wordpress.org/support/users/pedrovoorwinden/),
 * Thanks this is not a problem from the plugin, in WordPress you cannot use the
   same emails in different users.
 * Please remember that if this plugin helps you, remain a good review or make a
   little donation.
 * Kind regards,
 * Javier

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Format not working, no rows found’ is closed to new replies.

 * ![](https://ps.w.org/import-users-from-csv-with-meta/assets/icon-256x256.png?
   rev=1174343)
 * [Import and export users and customers](https://wordpress.org/plugins/import-users-from-csv-with-meta/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/import-users-from-csv-with-meta/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/)
 * [Active Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/import-users-from-csv-with-meta/reviews/)

## Tags

 * [empty](https://wordpress.org/support/topic-tag/empty/)

 * 4 replies
 * 2 participants
 * Last reply from: [Javier Carazo](https://wordpress.org/support/users/carazo/)
 * Last activity: [7 years, 2 months ago](https://wordpress.org/support/topic/format-not-working-no-rows-found/#post-11430413)
 * Status: resolved