WordPress.org

Support

Support » How-To and Troubleshooting » How to copy Excel Tables with formatting/colors?

How to copy Excel Tables with formatting/colors?

  • I have a bunch of Excel with colorful headers/color rows and columns.

    Whenever I copy and paste the table to WordPress page or post, it loses all of the formatting. Only the data gets copied over.

    Does anyone know how to copy the data AND the formatting?

    To show an example, Ideally, I want the tables/values to look something like the “Tabular Data” as in http://wpremix.com/demo/?page_id=188

    Any help is greatly appreciated.

    Thanks,
    Mike

Viewing 2 replies - 1 through 2 (of 2 total)
  • it is correct that happens.

    tables in html are either constructed in html or via CSS

    you may be able to export from excel to html and paste that code into the html pane on wp. certainly not the best way to do it.

    I’ve been trying to do this as well. I’ve had a lot more luck by using Open Office instead of Excel. Turn your Visual Editor on and paste from Open Office into the WordPress post window (set to Visual). Keeps font, size, background colour, only thing missing appears to be cell borders.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to copy Excel Tables with formatting/colors?’ is closed to new replies.
Skip to toolbar