Can I keep excel/google sheet text formatting when copying it into template editor?

Forum|Forum|3 years ago
June 13, 2023
3 replies
141 views

Hi,

We use Excel/Google sheets to organize our inventory. I was wondering if there was a way to maintain the formatting from excel/google when copying over data for our email campaigns.

When I try to copy this into a text field in the campaign:

I get this as a result:

Is there a way to keep the formatting? (ie colored text, bold, centered columns, etc)?

I am open to other ways of solving this.

Thank you!

This topic has been closed for replies.

Best answer by Taylor Tarpley

Hi @cdz,

Thanks for clarifying that for me!

Unfortunately, there isn’t a native way to do this in Klaviyo. I’d recommend creating an image of this table the way you want it to appear, with the formatting and styling and adding it as an image block into your template.

Hope that helps!

Taylor Tarpley

Community Manager

Hi there @cdz,

Welcome to the Community! Happy to help!

Unfortunately, there really isn’t a way to copy over the styling from Google sheets into Klaviyo. However, do you mind sharing the goal behind this? I would love to see if there are any other workarounds I can provide for you!

Thanks for participating in the Community!

-Taylor

C

cdzAuthor

Contributor I

Hi Taylor!

I think the idea for coloring is just to highlight some inventory when appropriate (ie large discounted items, low quantity, etc.) It’s not a big deal when it’s only a few items, but I’m just trying to find a solution that would work or accomplish something similar for large sets.

The goal behind the centered text is just a visual improvement. Sometimes, mostly on mobile, the QTY column would look a lot better centered. Again, when these lists become large, it’s pretty prohibitive to manually do it.

Appreciate the help!

Thank you for your time.

Taylor TarpleyAnswer

Community Manager

Hi @cdz,

Thanks for clarifying that for me!

Unfortunately, there isn’t a native way to do this in Klaviyo. I’d recommend creating an image of this table the way you want it to appear, with the formatting and styling and adding it as an image block into your template.

Hope that helps!

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials