Title: Wrong encoding while bulk (.zip) import
Last modified: February 4, 2020

---

# Wrong encoding while bulk (.zip) import

 *  Resolved [alya6](https://wordpress.org/support/users/alya6/)
 * (@alya6)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/wrong-encoding-while-bulk-zip-import/)
 * Hi, Tobias!
    I’m using TablePress for a while and have one problem.
 * When I try to make bulk import using .zip archive, my tables are wrong imported.
   Suddenly they have more rows and cells than on my computer and wrong characters
   like ó and other.
 * Interesting that while I import one .xlsx file, the table imports totally okay.
   When I gather the same table in or more that one table in .zip file, they import
   wrong.
 * I checked an encoding using Notepad++, the encoding is UTF-8 (with or without
   BOM – I tried both formats). And checked with OpenOffice – it also says, that
   encoding is UTF-8.
 * Tell me please, why this problem occurs and what should I do?
    Thanks!
    -  This topic was modified 6 years, 4 months ago by [alya6](https://wordpress.org/support/users/alya6/).

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/wrong-encoding-while-bulk-zip-import/#post-12397778)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * To be honest, I don’t know. It might be possible that the libraries that are 
   used for ZIP handling on the server somehow modify the encoding or something 
   like that.
    Can you maybe test again with CSV files? Those are usually better
   in this regard.
 * Regards,
    Tobias
 *  Thread Starter [alya6](https://wordpress.org/support/users/alya6/)
 * (@alya6)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/wrong-encoding-while-bulk-zip-import/#post-12398063)
 * Hi! Thanks for quick answer.
    When I create one table in .csv and import it on
   the website, it imports wrong – it has more rows and cells than on my computer
   and wrong characters like ó and other.
 * Maybe, I can send you one of those tables (in .csv and .xslx format) and you 
   can look what am I doing wrong?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/wrong-encoding-while-bulk-zip-import/#post-12399080)
 * Hi,
 * can you then maybe check the CSV file in a normal text editor? Does it already
   have more rows and columns there? If so, the problem is how Excel saves the table,
   I’m afraid. And TablePress can not know that you don’t want all of these cells…
   
   One idea in this case is to copy/paste the relevant data cells from the existing
   to a new Excel file. Often, Excel will save the table correctly after that again.
 * Regards,
    Tobias
 *  Thread Starter [alya6](https://wordpress.org/support/users/alya6/)
 * (@alya6)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/wrong-encoding-while-bulk-zip-import/#post-12399241)
 * Hi, Tobias!
    I checked file and everything is ok. I found answer on my question:
   while importing I should’ve set files encoding. Earlier I didn’t do that and 
   it was set on .csv format.
 * Now I switched on .xlsx and everything is ok. It’s a shame, that I didn’t knew
   about this function before.
 * Sorry for disturbing. Thanks for your help!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/wrong-encoding-while-bulk-zip-import/#post-12399435)
 * Hi,
 * no problem, you are very welcome! 🙂 Good to hear that this helped!
 * Best wishes,
    Tobias
 * P.S.: In case you haven’t, please [rate TablePress](https://wordpress.org/support/plugin/tablepress/reviews/)
   here in the plugin directory. Thanks!

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

The topic ‘Wrong encoding while bulk (.zip) import’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/wrong-encoding-while-bulk-zip-import/#post-12399435)
 * Status: resolved