• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

New Here ,
Feb 15, 2024 Feb 15, 2024

Copy link to clipboard

Copied

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.

Views

223

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe
Community Expert ,
Feb 15, 2024 Feb 15, 2024

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 16, 2024 Feb 16, 2024

Copy link to clipboard

Copied

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

janee_0-1708083010511.png

Jane

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 16, 2024 Feb 16, 2024

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 17, 2024 Feb 17, 2024

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 17, 2024 Feb 17, 2024

Copy link to clipboard

Copied

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

 

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 17, 2024 Feb 17, 2024

Copy link to clipboard

Copied

LATEST

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

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines