Skip to main content
A
Andres15A9
Inspiring
April 4, 2021
Answered

How to convert an Excel sheet with RGB Colors values to a Photoshop Swatches Panel?

  • April 4, 2021
  • 2 replies
  • 3183 views

Hi community!
I have a problem that I've trying to solve for the last 10 days and I can not to find the answer...

>> I have an Excel sheet of color names with their RGB values that I need to load in Photoshop Swatches.
I've saved the Excel file as .htm and I managed to load the entire list in Photoshop. All the colors appears perfectly in the Swatches panel, but... rather than the name of each one It shows me the Hexa numbers (not the real color names). And they are a lot of Colors, to edit manually...

Somebody knows how to load the .htm, or even a .csv, to I manage to load the Colors, with its names, in the Photoshop Swatches Panel?

Thank you very much!!

This topic has been closed for replies.
Correct answer Andres15A9

Leave the link to that other AI topic with solution, so we mark your new post as correct answer.


https://community.adobe.com/t5/illustrator/csv-to-swatch-library-script-problems/m-p/11949362#M271020

2 replies

jane-e
Community Expert
jane-eCommunity Expert
Community Expert
April 4, 2021
@Andres15A9 wrote:

but... rather than the name of each one It shows me the Hexa numbers (not the real color names).

 

What is a "real color name" as defined by you? Colors have numbers. If you open the Color Picker for instance, you can see the HSB, RGB, CMYK, and Hexidecimal numbers. Also, they vary according to the color space they are in.

 

Excel uses names such as Accent 5, Darker 25% and Accent 3, Lighter 80%. When you change the Theme, the color in the slots change while the percentages remain the same.

 

Photoshop, InDesign, and Illustrator all support an ASE (Adobe Swatch Exchange) file. If you have swatches in this format, you can import them into any of these applications. The swatches need to be exported or save from one of these applications. ASE files cannot be saved from Microsoft.

 

Unless there is a script that can assign the proper name to the proper swatch, the process will be manual. Double-click a swatch and name it. Then use the panel menu to save the swatches so you never have to do it again.

 

Some examples of your definition of "real color names" will help us determine if this can be done.

 

~ Jane

 

 

A
Andres15A9Author
Inspiring
April 5, 2021

Hi Jane, as I said on my post:
"I have an Excel sheet of color names with their RGB values that I need to load in Photoshop Swatches".
What I called "real names" after that, it was the colors' names that are atributted to the rgb values in my Color list, just that. To that rgb color values It was atributted certain names. I need to respect that names.
I know what is color value/color name LOL


Yes, I was trying all day with Adobe Ilustrators' scripts that appeared here in the community, in another threads, but they didn't work to me.

I know that one of the options is make it manually. But I'm trying to find some "less difficult" way to do that, because are too much colors.
The solution would be a script for Ps, as you say, but I'm not finding it yet...

Thank you!


Disposition_Dev
Disposition_Dev
Legend
April 5, 2021

To rename a swatch, you just assign a new string to the "name" property of a swatch.

 

For example, mySwatch.name = "big bad blue"

 

You'll just need a column in your spreadsheet for the names, just like you have columns for the color values. 

    Kukurykus
    Kukurykus
    Legend
    April 4, 2021

    Script to Create Colour Chip Layers in Photoshop

    Combine two set of images in two folders transparent PNG over background - batch export

    A
    Andres15A9Author
    Inspiring
    April 4, 2021

    Hi! Thank you, but any of the links solve my problem...

    I have a text list with color values, not images...
    I managed to load the colors in ythe Swatches Panel, but I need to know how to load the colors AND its names.

    A
    Andres15A9Author
    Inspiring
    April 4, 2021

    Sorry, I meant to say that those links doesn't solve the question...

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices