Generating Graphics Using Data

[alicornwall]

Hi All,

I am not sure if this is possible at all however I want to populate text in a image from a spreadsheet or a csv file. I know you can do the variables however I don't want to create individual images for each row of data I would like it to import all the data into the graphic and save it.

For example, if I wanted to set up race results graphic and then import the data so it populates peoples position, points and lap time form a csv etc?

I am not sure if Photoshop is the right tool for the job and/or if this is going beyond the limits of the program.

Many Thanks

[macpawel]

you can try to use Illustrator to make charts from data file

If you don't need charts - you can use Variables in Photoshop and Illustrator or Data Merge option in InDesign to prepare nice design.

[c.pfaffenbichler]

If it’s about type content as such then, as macpawel mentioned already, Indesign or Illustrator would seem more fitting tools for the task.

Can you post an example (bot the source-file and the result you want to achieve)?

[alicornwall]

I want to replicate something like the below, this is something I picked up from facebook and like the look of it and want to replicate it. The data I want to put in is from and excel sheet however I am not sure how to attach that. It might need tweaking so it works better for the import but this is the aim.

[c.pfaffenbichler]

The Gradients and the flags may make it less comfortable to handle in Illustrator and Indesign but I think ultimately both should be able to handle those elements, too.

Maybe also ask around on the Fora for those and maybe even on the respective Scripting Fora.

[alicornwall]

Thanks for the help, forgive me what is Fora?

[c.pfaffenbichler]

what is Fora?

If one considers »Forum« as a latin word then the first case plural is »Fora«.

[Mike_Gondek]

You might be able to. I have not used data driven in Photoshop,  but shows text replacement.

Creating data-driven graphics in Photoshop

[Bojan Živković]

You can use Photoshop for such task. It is doable using Variables and data sets. You must prepare separate layers with names and layers with points and assign variables to them. Variables will be connectors between data in txt file and layers in Photoshop. Once you set up things it is easy to replace data on layers with data from txt file.

I have several tutorials on this topic https://www.designeasy.co/search?q=data+driven

Here is tutorial which is covering text replacement variables https://www.designeasy.co/2014/08/easy-way-to-automate-photoshop-with_27.html

Here is one that you may need to hide some text layers if you have smaller amount of data https://www.designeasy.co/2018/04/why-and-how-to-combine-textpixel.html?q=data+driven

If you need more hep or you do not understand something please do not hesitate to ask question.

[Bob_Hallam]

Creating a PSD from Excel Data is possible using Scripting.  I suggest you ask this question in the scripting forums

Photoshop Scripting

You may even find code there that will perform most of this.

[Lumigraphics]

You don't need variables or data sets with this, if the text is going to be in one layer (or multiple layers.) You can read a text file and create text layers with a script.