Skip to main content
A
alicornwall
Participant
July 25, 2019
Question

Generating Graphics Using Data

  • July 25, 2019
  • 4 replies
  • 782 views

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

This topic has been closed for replies.

4 replies

L
Lumigraphics
Legend
July 25, 2019

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.

Bob_Hallam
Bob_Hallam
Legend
July 25, 2019

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.

ICC programmer and developer, Photographer, artist and color management expert, Print standards and process expert.
c.pfaffenbichler
Community Expert
c.pfaffenbichlerCommunity Expert
Community Expert
July 25, 2019

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)?

A
alicornwallAuthor
Participant
July 25, 2019

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.

Bojan Živković11378569
Community Expert
Bojan Živković11378569Community Expert
Community Expert
July 25, 2019

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.

macpawel
macpawel
Participating Frequently
July 25, 2019

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.

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