Displaying Excel data

  • 2
  • Question
  • Updated 6 years ago
  • Answered
Hi all,

I currently display some Excel data on my website (http://www.rugbyleagueratings.com/) by simply copying from Excel and pasting into a text widget. Within the widget, there is then created a sort of spreadsheet grid in which editing of the formatting of specific cells can be carried out, and it can be resized etc.

I have two questions however:

1) Is there a better way to insert data from Excel so I can e.g. retain the original formatting?

2) Within the text box, is there a way to delete the Excel data once it's been pasted? I cannot work out how to do this if so!
Photo of Ian


  • 15 Posts
  • 0 Reply Likes

Posted 6 years ago

  • 2
Photo of Sanja

Sanja, Official Rep

  • 10698 Posts
  • 495 Reply Likes
Hello Ian,

We strongly suggest not copying and pasting from Excel into your Sitebuilder. This can cause a lot of formatting issues and even cause your page to break. Instead, if you would like to incorporate Excel onto your site, please see this tutorial: Embedding PowerPoint, PDFs and other files onto your website.
Photo of Ian


  • 15 Posts
  • 0 Reply Likes
Neither of those options really cover what I want to do, which is to provide a sort of bespoke set of figures, rather than display the spreadsheet itself, which is not formatted for presentation, and won't be. Also, I'm hoping to avoid directly displaying a spreadsheet.

Given that I am able to insert Excel data without problems (apart from not being able to remove the data again) for the moment, is there a source of information on how this works, and how it can be manipulated, or is this some sort of feature that's not yet fully developed?
Photo of Philip Taylor

Philip Taylor

  • 355 Posts
  • 66 Reply Likes
You could save the spreadsheet, using Save As, as a PDF then upload the PDF. You won't be able to edit it, but you can edit the Excel sheet and upload again - about 5 clicks.
Photo of Gop


  • 7473 Posts
  • 2115 Reply Likes

I have a 200 odd spreadsheet database. I was able to display it using CSS .It appears as a list including images.

It required the creation of a text file of the data including some HTML formatting syntax within the text file. This can be created within the Excel functions then simply export it as a .txt or csv file.

Then format the data using css with the HTML layout defined in your HTML.

What you need to understand is a good working knowledge of text fuctions in Excel, export functions in Excel, HTML syntax so that you can include this in your HTML, CSS.

You can delete data that you have already placed in your site as you have referred to by opening your text widget content within the HTML facility identifying the content and deleting this. You may have to also edit the grid which may remain after deleting the textual content.

If you feel I can be of any help with further info just let me know here.