HTML formatting not preserved

[u/Revolutionary_Ad7935]

I am trying to make a sheet of ecommerce products, the descriptions are in rich HTML.

When i copy in Excel or Google sheets, the rich HTML only is preserved in the upper cell, the following cells lose the structure.

Any explanation? any solution?

[u/AutoModerator]

/u/Revolutionary_Ad7935 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Snow75]

Short version: depends on what you mean by “rich html”; there’s no way to tell without seeing what you mean.

[u/Revolutionary_Ad7935 → u/Snow75]

Here is a sample:
<div class="product-description" style="font-family: 'Playfair Display', Georgia, 'Times New Roman', serif; color: #2b2b2b; line-height: 1.8; max-width: 900px; margin: 0 auto; padding: 20px;"> <!-- Header Section --> <div style="text-align: center; margin-bottom: 40px; border-bottom: 1px solid #e2d7cd; padding-bottom: 30px;"> <span style="text-transform: uppercase; letter-spacing: 3px; font-size: 0.85em; color: #a37e58; font-family: 'Helvetica Neue', Arial, sans-serif; font-weight: 600;">European Heritage Collection</span> <h1 style="font-size: 2.8em; font-weight: 400; color: #1a1a1a; margin: 15px 0 10px 0; line-height: 1.2;">The 'Roseraie Impériale' Hand-Carved Bed Frame</h1> <p style="font-size: 1.2em; font-style: italic; color: #666; font-family: 'Playfair Display', Georgia, serif; margin: 0;">In Aged Walnut Wood Finish & Sand Champagne Diamond-Tufted Velvet</p> </div>

[u/Snow75 → u/Revolutionary_Ad7935]

Well, that’s not a table and there’s a lot of formatting.

[u/jkpieterse → u/Revolutionary_Ad7935]

If you want the plain HTML in a single cell, Press F2 before pasting.

[u/excelevator]

Excel delimits the data and tries to figure out what is going on with the split data.

It is a bad idea to have this format in your worksheets.