Creating a spreadsheet / table

Can anyone tell me best way to create a  spreadsheet / table with column lines and cells on a page?

It kind of depends what you are trying to display and how you want it to show on your site.

If you want a table with multiple columns and rows, you would nee to create it in HTML. The easiest way is to use https://www.tablesgenerator.com/html_tables 

You create the table there and copy and paste the HTML code into your page using the "<code>" content block under "MORE"

However, this way is not responsive to the device display size, it may go "off" the page on mobile devices.

If you want it to be responsive, it would be easiest to insert your table as a picture. Create your table in Excel or Google Spreadsheet, use the Snipping Tool to take a screenshot and save it, then upload the picture.

Hope this helps.

Thank you👍

I wouldn't recommend using an image in place of a table as the information will not be accessible to people with disabilities - a legal requirement. It will also make it very difficult to read on smaller devices.

The best solution I have found for responsive and well designed tables on Squarespace is the Custom Table Block. You can add this like a standard Squarespace block on any page. If your table contains more than a few rows/columns, add the data to a Google Sheet and link it to the Block.