Link Excel or Google sheet with Photoshop to localize 16 languages in one PSD file

[Dmitry Tokar]

Hello, I have a question. In my work, I often create marketing materials for mobile games in different languages. In one PSD I have graphics and text localization into 16 languages, translations are sent to me in Excel or Google spreadsheet format. How can I automatically fill text in a PSD file from a document with localization? There is a similar function in Photoshop called Variables, but I need the text replacement to be in one PSD file for all languages.

[kglad]

in the future, to find the best place to post your message, use the list here, https://community.adobe.com/

p.s. i don't think the adobe website, and forums in particular, are easy to navigate, so don't spend a lot of time searching that forum list. do your best and we'll move the post (like this one has already been moved) if it helps you get responses.

<"moved from cc desktop">

[jane-e]

<"moved from cc desktop">

By @kglad

@Dmitry Tokar 

This post is still in the Creative Cloud Desktop forum, so I am moving it now to Photoshop.

Jane

[Stephen_A_Marsh]

@Dmitry Tokar 

This would take a script.

Can you post a .PSD and .CSV sample of the translations? It can be a simplified example just using 3 text layers and 3 languages in the spreadsheet file.

[Dmitry Tokar]

Hi! Thank you @Stephen_A_Marsh for trying to help me solve my problem.

I have attached sample .PSD and .CSV, .XLSX files to the post. with translations

[Myra Ferguson]

You can use your Excel or Google spreadsheet with Variables to create your content. Here's an article with more information:

• https://creativepro.com/photoshop-automation/ 

It will export the graphics separately, so to put them all back into a single Photoshop file, you could use File > Scripts > Load Files into Stack..., and in the Load Layers dialog, select all of the exported images created from the spreadsheet.

[Stephen_A_Marsh]

@Myra Ferguson 

That's a good idea and worth exploring, however, the Load Files into Stack script will load each layered PSD as a flattened file. I wrote a script to load layered files into a stack retaining the layers:

https://community.adobe.com/t5/photoshop-ecosystem-discussions/request-photoshop-script-load-files-t...

This could work for @Dmitry Tokar – and would be much faster than writing new code!