Tablepress allows you to enter tabular data(csv import/export supported) and display them in wysiwyg fields via a shortcode.
This is how the Tablepress dashboard looks like:
When you add a new table, you have the option to create a new table or import one.
Currently these file types are supported:
You can also point a url to download the file from or paste the data in a textarea.
For this example, I’ve created a new table from scratch.
Don’t expect Google Sheets like functionality but it comes pretty close. You can add rows/columns, delete them, swap rows/columns, etc. You can also set table headers and footers.
Best of all, it comes with extensive table features like pagination, search, filters, etc.
Once you’re done with the look and feel, save the table and paste the shortcode found in the Table Information box inside a wysiwyg field in WordPress.
This is how it looks like in the frontend:
You can turn pagination and search off. This table is basically html so you should be able to customize the look and feel of it.
There’s also an options to load your custom css inside Tablepress options page however I won’t use it unless I’m working on a custom theme where I don’t have access to the css source files.
As for importing, these are the currently supported formats:
With Tablepress you aren’t just limited to tabular data. You can even paste images, HTML code, etc. You can also use formulas just like in excel.
By default Tablepress isn’t responsive, however you can get away with just a few css tweaks if you don’t have a lot of columns. If you need your tables to be absolutely responsive, you can buy the responsive tables extension which makes the tables mobile friendly.