Title: Support for large tables?
Last modified: September 3, 2019

---

# Support for large tables?

 *  [stormflora](https://wordpress.org/support/users/stormflora/)
 * (@stormflora)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/support-large-tables/)
 * Hi, I’m trying this out for the first time. I noticed that if I add more than
   several hundred rows (I need a large database), the TablePress editor page lags
   _really_ badly because it tries to load every single row onto the same page.
 * Is there any chance you could optimize this to display only say, 100 rows in 
   the editor at a time (like how it looks to visitors)? That would greatly help
   with editing optimization, and I think it would improve the plugin further.

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/support-large-tables/#post-11892796)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * This is a known issue, but unfortunately, there’s no decent solution yet. Offering
   pagination on that screen is not directly possible, due to the way how tables
   are saved, unfortunately.
 * For now, the best workaround is to manage such large tables offline, e.g. in 
   Excel, and then save them as a CSV file after making changes, and re-importing
   that CSV file, choosing to replace the existing copy of the table.
 * Regards,
    Tobias
 *  Thread Starter [stormflora](https://wordpress.org/support/users/stormflora/)
 * (@stormflora)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/support-large-tables/#post-11892834)
 * I see; I didn’t realize that WordPress had limitations like that.
 * Then, what is the proper CSV (text) format for the table? How is each column 
   separated?
    -  This reply was modified 6 years, 8 months ago by [stormflora](https://wordpress.org/support/users/stormflora/).
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/support-large-tables/#post-11892898)
 * Hi,
 * TablePress best supports CSV files with `,` or `;`. It’s important though that
   this column separator is escaped if used inside a table cell, just like the `"`.
   
   If you use Excel or similar, the saved/exported CSV files will work fine.
 * Regards,
    Tobias
 *  Thread Starter [stormflora](https://wordpress.org/support/users/stormflora/)
 * (@stormflora)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/support-large-tables/#post-11896380)
 * So you suggest simply editing the tables in Excel and then replacing the table
   on the site each time with the new revision then.
 * In that case, I think it would be a good idea to separate the table editor from
   the table settings. That way, you can edit the settings for a table without having
   to load the entire table for it, and only load up the table editor if necessary.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/support-large-tables/#post-11896934)
 * Hi,
 * yes, that’s basically the idea with Excel!
 * Thanks for that suggestion! I’ll check whether that can be a viable option in
   the future, though it might be confusing as well…
 * In the meantime, if you need to change settings for a table, I recommend to import
   a small/empty dummy table, then make the changes, and then upload the actual 
   table CSV file again.
 * Regards,
    Tobias

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

The topic ‘Support for large tables?’ 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, 8 months ago](https://wordpress.org/support/topic/support-large-tables/#post-11896934)
 * Status: not a support question