Title: import table ID
Last modified: September 14, 2021

---

# import table ID

 *  Resolved [Rich](https://wordpress.org/support/users/rremick/)
 * (@rremick)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/)
 * Hi, is there a way to import the tables while keeping the id number the same.
   I deleted some tables over the years and the id of the original table are now
   out of sync when i import them to a new website.

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14872237)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * What do you mean with “out of sync” here? Do you mean that intermediate table
   IDs are missing?
 * Note that you can change the table ID when editing a table.
 * Importing with keeping a table ID (which would have to be part of the imported
   file) is only possible with the JSON format. The other formats, like CSV, Excel,
   or HTML, simply don’t have a way to store that in the respective file.
 * Regards,
    Tobias
 *  Thread Starter [Rich](https://wordpress.org/support/users/rremick/)
 * (@rremick)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14872827)
 * Where can i look up how to do the json method? I would like to ids to match. 
   Once i deleted a few tables the id of the table and the import id dont match 
   when i import them.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14873438)
 * Hi,
 * To see what the JSON format looks like, just export one of your tables to a JSON
   file and inspect that in a normal text editor, like Notepad on Windows or Text
   Edit on Mac.
 * Now, I’m still a bit confused here: Where exactly do the table IDs not match?
   What are you comparing the table ID that is assigned to an imported table to?
   To the ID that a table has on an old/different site?
 * Regards,
    Tobias
 *  Thread Starter [Rich](https://wordpress.org/support/users/rremick/)
 * (@rremick)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14876175)
 * Yes,
    In other words the NEW id number of the table imported does not always 
   match the id of the table that was exported
 * The table IDs are not always consecutive because some tables where deleted.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14876342)
 * Hi,
 * ok, so this is about a mismatch between exported and imported table IDs.
    To 
   get around that, you will need to use the JSON format when exporting. That way,
   the table ID will be part of the exported data. When you then import that .json
   file (on the same or a different site), the table ID will be extracted from the
   data and it will be used for the imported table, if it’s not yet in use.
 * Regards,
    Tobias
 *  Thread Starter [Rich](https://wordpress.org/support/users/rremick/)
 * (@rremick)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14880159)
 * Ok, that worked perfect! Thank you!
 * Just one odd thing i noticed, the imported tables no longer fill the width of
   the screen, but maybe 2/3 or 3/4 or so.
 * Like it thinks there is a sidebar when there isnt. I can email you screen shots.
   The article is not published yet so i cant send the url.
 * I hope that makes sense
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14881079)
 * Hi,
 * good to hear that this helped!
 * These widths problems are unrelated to the export/import of the table. Instead,
   they are likely related to the theme on the new site.
 * It could indeed be possible that the pages into which you embedded the table 
   use a “Page Template” with an (empty) sidebar. You should then be able to choose
   a different “Page Template”, like “Full width” or “No sidebar” on the “Edit” 
   screen of the page.
 * Another possible cause could be a JavaScript problem. To fix that, please add
   this to the “Custom CSS” textarea on the “Plugin Options” screen of TablePress:
 *     ```
       .tablepress {
         width: 100% !important;
       }
       ```
   
 * Regards,
    Tobias
 *  Thread Starter [Rich](https://wordpress.org/support/users/rremick/)
 * (@rremick)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14883153)
 * Thank you for your assistance Tobias!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14883288)
 * Hi,
 * no problem, you are very welcome! 🙂
 * Best wishes,
    Tobias   P.S.: In case you haven’t, please rate TablePress [here](https://wordpress.org/support/plugin/tablepress/reviews/#new-post)
   in the plugin directory. Thanks!

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

 The topic ‘import table ID’ 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/)

 * 9 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [5 years ago](https://wordpress.org/support/topic/import-table-id/#post-14883288)
 * Status: resolved