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.

c.pfaffenbichler
Community Expert
c.pfaffenbichlerCommunity Expert
Community Expert
July 25, 2019

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.

    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