So if you have the same problem, I gathered a few pieces of information on how to save. txt, i realized that Libre Office Calc doesn’t have such an option like Excel has – “export as txt”. Place in each column proper data: in the “image” column put names of your image files: “image1.jpg”, “image2.jpg”, “image3.jpg”. Important -> The size of the letters matters. Name the columns the same as your layers in Photoshop: “images”, “year”, “number”.
I also rename them to “Image1”.Ĭreate columns – each column is for one layer. Gather all of your images you want to import to the template in one folder. I left the “Image copy” layer – it’s just a frame for “image” layer, I won’t import any images here.īelow you can see a screenshot of the template The text layers:”year” is for the text layer where you will import data of different years from your excel file, and “Number” will obviously contain a number of the image.
I have created a template in the style of album photos. I always name the layers accordingly to data which will be imported to your template. Prepare a template in Photoshop:Ĭreate your template and name the layers correctly. Importing data from Excel to Photoshop – explanation 1. If you have any problems, below you can find a detailed explanation to each step. Click button “Select folder” to choose to which folder you want to save your.
(options -> File -> Export -> Data Sets as Files)Ī new window will open. (options: Image -> variables -> data sets)Ī new window will open. Repeat to all layers that you want to change. Set name to “image”.įor text layers: pick the layer with text (for example “year”) and check the box “Text replacement”. Pick layer “image”, and check the box “Pixel replacement”.