Creating table from spreadsheet application (such as Excel, Calc, or Google Sheets) is much faster than to do it from HTML editor. Converting table from spreadsheet application to HTML code is not too difficult but the problem is the generated code is such a mess. This tutorial will show how to create table in wordpress from google sheets in a better way with a cleaner code.
1. Install wordpress plugin, TablePress.
2. Create a table in Google Sheets.
3. Install Google Sheets add-ons, Power Tools. Go to Add-ons menu -> Get Add-ons… -> search Power Tools.
9. Copy the shortcode to your post to insert the table. If you want to merge across row, insert #colspan# to the right of filled cell. To merge across column, insert #rowspan# to the below of filled cell. Don’t forget to click Save Changes button.