Title: Clean up database
Last modified: October 27, 2020

---

# Clean up database

 *  Resolved [donahmar](https://wordpress.org/support/users/donahmar/)
 * (@donahmar)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/clean-up-database-3/)
 * Hi there,
    I use WP All Import to import about 20,000 rows in an excel sheet 
   as posts. WP All Import has created over 500,000+ tables/rows in my database.
   How can I clean this up? I need to keep WP All Import and the posts but I am 
   wondering if there is a different way I should be running my import so it is 
   a cleaner/lighter database.

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

 *  Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * (@wpallimport)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/clean-up-database-3/#post-13593493)
 * Hi [@donahmar](https://wordpress.org/support/users/donahmar/),
 * > I use WP All Import to import about 20,000 rows in an excel sheet as posts.
   > WP All Import has created over 500,000+ tables/rows in my database. How can
   > I clean this up?
 * Depending on the data you’re importing, all of that may be necessary. Are the
   500,000 extra entries in the postmeta table? If so, what are some examples of
   entries that you feel are unnecessary?
 * Also, how many rows are saved in the database when you manually create a post
   rather than importing it?
 *  Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * (@wpallimport)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/clean-up-database-3/#post-13670167)
 * Hi [@donahmar](https://wordpress.org/support/users/donahmar/),
 * I’m marking this as resolved since we did not hear back. Let me know if you still
   have questions about this.
 * Anyone else, please start a new topic.

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

The topic ‘Clean up database’ is closed to new replies.

 * ![](https://ps.w.org/wp-all-import/assets/icon-256x256.png?rev=2570179)
 * [WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets](https://wordpress.org/plugins/wp-all-import/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-all-import/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-all-import/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-all-import/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-all-import/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-all-import/reviews/)

## Tags

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

 * 2 replies
 * 2 participants
 * Last reply from: [WP All Import](https://wordpress.org/support/users/wpallimport/)
 * Last activity: [5 years, 6 months ago](https://wordpress.org/support/topic/clean-up-database-3/#post-13670167)
 * Status: resolved