Photoshop Variables not working

[William35585738b0s9]

"Could not parse the file contents as a data set. There were not enough variable names in the first line of the text file."

I have tried using google sheets to generate my CSV, I've done it through excel, I've deleted the initial sheet in excel and pasted the contents into a new sheet as values, I have tried using text files with commas and nothing has worked. It appears that this issue is rampant on the internet and I don't understand why a reasonable fix hasn't been made to variables. My data is setup correctly and it doesn't work no matter what I try.

TextVariable1	TextVariable2	TextVariable3	TextVariable4	PixelVariable1
1	2	3	4	C:\Users\willi\OneDrive\Documents\Amazon KDP\Complete_Puzzles_Solutions\Solution0.png

I originally had each header as a nongeneric name, but ended up trying the generic names. There are 34 rows and each are formatted like the above. I have tried switching the UTF settings as well. I'm stuck.

[Stephen Marsh]

Please share the CSV and PSD.

[William35585738b0s9]

I had to strip the PSD of data for confidentiality reasons, but I left the bare bones

[Stephen Marsh · Accepted solution]

You have 5 variables in the CSV, but only 4 text are defined in the PSD, the pixel replacement isn't defined.

Additionally, there are visibility variables for each text layer in the PSD, so a column would also be needed for that with boolean values.

I have tested with both the standard PSD data set export and exporting direct to JPEG, WEBP etc:

https://community.adobe.com/t5/photoshop-ecosystem-discussions/using-datasets/td-p/2665594/page/2#U1...

[William35585738b0s9]

The pixel was defined prior, I suppose it was removed when I had to edit the data. As for the visibility, should I leave this option as unchecked? I thought that this would make each layer invisible by default.

[William35585738b0s9]

I tried it without the visibility toggled and it works. Thank you! This was driving me nuts. I didn't realize it considered visibility as a separate list item

[Stephen Marsh]

@William35585738b0s9 

You’re welcome! The official guide could use more examples, I think that they tried to keep it simple:

https://helpx.adobe.com/au/photoshop/using/creating-data-driven-graphics.html