Posting tables in WordPress with TablePress

TablePress is a great WordPress plugin for importing spreadsheet data into your WordPress site. You need to flatten the spreadsheet into a CSV file but besides that it works terrific!

This is a tutorial I created for a customer. I hope he any many others will find it helpful.

If you are going to upload pictures it’s best to resize them to 1024 wide or 1024 high. It make them easier for people with slower connections to view, they load faster. If you are uncertain how to resize pictures consult your photo/camera program or we can create a generic resizing tutorial here.

Open spreadsheet and select & copy cells like pic below
posting-tutorial-01

Paste copied cells into a another page in the workbook as shown
posting-tutorial-02

Save as CSV file type as shown
posting-tutorial-03

Click OK here
posting-tutorial-04

Click Yes here
posting-tutorial-05

Go to Import a Table as shown
posting-tutorial-06

Select Choose File
posting-tutorial-07

Select the CSV file you created and click Open
posting-tutorial-08

Click Import, check settings as shown
posting-tutorial-09

Once imported scroll down to Pagination & un-check that box as shown
posting-tutorial-10

Click Save Changes
posting-tutorial-11

Select & copy, or note, the shortcode for the table as shown
posting-tutorial-12

Go to pages and open the results page as shown
posting-tutorial-13

Make a new line under the West Texas Team Trail heading (go to the end of that line & hit Enter) and add your table title. Click enter at the end of that line to make a new line for the table shortcode you copied or noted 2 steps back and paste or type it as shown. To insert pictures, make a new line (as discussed above) and click the Add Media button
posting-tutorial-14

 

Click Upload Files
posting-tutorial-15

Click Select Files
posting-tutorial-16

Choose a picture that you have resized to 1024 wide. To add more pictures make a new line for each and repeat the process.
posting-tutorial-17

When done you should have a page that looks similar to this. Click the Publish or Update button to the right. Check your work, you should be done.
posting-tutorial-18