This tutorial will show you how to UPDATE tables using the TablePress Plugin for your WordPress Website.
Navigate to your website and if there is a login link then click on it or append /login or /wp-login.php to the URL in your browser. Hit Enter/Return to get to the WordPress Login screen.
Enter your username and password and click on the blue Log In button.
2. Go to your WordPress Control Panel
When you are logged in to your website you will see a black bar at the top of the screen. Click on the title of your website in the top left hand corner to switch between your WordPress Control Panel and the front-end of your website. In this example it is Wyvern Sea Angling.
3. Select TablePress
When you switch to your WordPress Control Panel you will be at the Dashboard. You will see a menu on the left hand side of the page which are all the options to control your website. Click on the menu item TablePress.
4. Select Import
When you have clicked on the TablePress menu item it should now be blue and you will be on the TablePress control panel page. You can EITHER click on the submenu ‘Import a Table’ or click on the tab ‘Import’.
5. The Import Page
You should now be on the Import page.
6. Select your file
a) With the File Upload radio button highlighted (blue) click on the ‘Choose file’ button and find the Excel file you wish to upload.
b) Select ‘Replace existing table’
c) In the drop-down box, choose the table you wish to replace.
d) Click on the blue ‘Import’ button.
In this example, the Fish of the Month – Catch & Release table is being replaced with a new version from an Excel file.
7. Save Changes
When the table has been imported you will be taken to the table itself and you should see a message that ‘The table was imported successfully’. At this point click on ‘Save Changes’.
8. Tidy the Table – Select unwanted rows
Often in Excel you will have empty rows and extra heading rows you want to delete. Select these rows by clicking on the tick boxes on the left hand side of the table.
9. Tidy the Table – Delete unwanted rows
Under the table click on the ‘Delete’ button next to the row called ‘Selected Rows’. This will remove the ticked rows from the table. Note: you can also do the same process with unwanted columns.
10. Save Changes!
Don’t forget to save changes. Click on the blue ‘Save Changes’ button under the table.
11. Check the table
Navigate to the front end of your site by clicking on the site title in the top left of the black bar. Go to the page which contains your table and check it looks ok. If you need to re-edit the table, go back to the WordPress Control Panel, click on TablePress in the menu and click on the title of the table you wish to edit.