Participant

Question

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

Forum|Forum|2 years ago
February 15, 2024
3 replies
1866 views

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.

Others

This topic has been closed for replies.

Myra Ferguson

Community Expert

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 Marsh

Community Expert

@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-to-stack-including-layers-in-order/td-p/14202346

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

Stephen Marsh

Community Expert

@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.

D

Dmitry TokarAuthor

Participant

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

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

Community Expert

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

Community Expert

<"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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded