Great tutorial mate! When I use this, media encoder renders the text as "undefined" - it looks good in AE. When I change text and save, AE refreshes, everything looks great. I know this must be a path issue since Media Encoder saves it's own AE file into Filename_AME folder - but no matter where I copy-pasted the .csv file, Media Encoder wouldn't see it.
Amazing tip .. and I am so happy that you are going to hit 1Lakh Subscriber soon.... I have seen your journey .. and I have lots of respect what you are doing to educate us all .. Thank you so much, from the bottom of my heart.
How do I replace an audio clip similar to this method? I will create a song with a "name" section and I want to export same song with different names, is there any way to it? Thanks in advance?
Thank you this is epic. Is there away to auto export a composition multiple times using a csv file? If lets say for example I want the each video to change the name of a person that appears in it.
This is great. Is there a way to use CSV to import an image from a specific file location in the same manor? example CSV line would be Brian, Videographer, /photo/brian-600x600.jpg
Привет! Молодец ... This tip helped me cut part of a dayly task. I had written a extendscript to update an animation (a bar graph with results for the local stock exchange), now reading form a CSV file and making a few adjustments, the task is a bit more automated. Спасибо большое из Бразилии
hello, first i would like to say this is a great video thank you so much for your hard work and sharing it with us in a nice simple manner. second i have a question, if i wanna link the number of values in a column to a slide control what expression should i write like if a column got a title and 30 rows i wanna link it to a slide control so that it turns 31 what is the expression here? again thank you so much
Hi, Thanks for the tutorial. QUESTION: How do you go about batch exporting multiple compositions so each has their own unique information displayed from the CSV?
You need as many comps as you have rows but basically you would need to write an expression. column = 0; row = parseFloat(thisComp.name.toString()); footage("sample.csv").dataValue([column,row]); In this example my comp name is just a number, if you want to have a long comp name you'll have to change the expression using something like a .split("-") When you have a bunch of comps called 1,2,3... the expression will see the number and pick that row. There might be an easier way but just saw this video and your comment and thought I'd give it a go solving it.
Thanks so much for this tip Sergei. I am having a couple of small issues, though. First, this only seems to want to work with a basic text editor program like Notepad or Notepad++. Every time I've attempted to edit with something like Excel or another CSV editor, extra characters or spaces are added to the file, which then causes it to show error messages in AE. I then have to go back into Notepad, delete what has been added, and reload the csv in AE for it to be read again. Are there any spreadsheet style editors that you would suggest to make it easier for my team to be able to keep track of the data they're editing and won't cause these issues? Second, when I attempt to export via Media Encoder, all of the text is replaced with "Undefined". Is there a way to allow ME to encode this project, or will I have to render through AE?
I actually figured out my first issue. There was somehow a tab space before one of the fields. After fixing that, I was able to edit in Excel and Save As a csv to update text.
I'm glad you were able to figure it out, Jeremy. You should join our free online mentoring group at ukramedia.com/community. We have a lot of very knowledgeable/talented artists who are very passionate about helping others. See you there!
Really like these daily tips and very useful for want I'm currently working on. I have link the CSV excel file to text layer>source text number. Is there a way to link the text layer>source text number to an point control number counter end number? Would this be an var expression or something similar?
Great Tutorial....One question...if I'm giving sting value then how I will get the dataValue...eg: if the dataValue([0,1]) = ukramedia, how I will get dataValue if typing the sting same name (ukramedia) at any text layer. it will be great help for me if you are answer this question.
Hi! Thank you for the video! It helped me to understand how it work! I have a question. When I use CSV file in my project, After Effects run much much more slower. It really affects my work a lot even though I have quite fast computer. I googled it and found that some people had this problem as well but I didn’t find a solution. Do you have an idea why CSV slows the AF performance so much and how to avoid this? It would really help me A LOT!!! Thank you! :-)
Please do! I have searched everywhere to learn how to do that. I have a few ways I do it myself, but it's very clunky and I would love to learn a more elegant way that would allow you to use larger datasets without creating too much havoc.
So I used the second method. How would I go about dropping a new CSV into there and keep all the pickwick values the same? I currently make 24 different compositions on the same video but they have different values. I assume that if I change values in the CSV it'll change it on every after effects file. there's like 20 different text boxes so I can't really change it all.
@@PhilipDirven I've been using this method of CSV data for over a year, and only started getting "Undefined" during export since a CC update in Jan 2021. I cannot find any solution except to export individual videos directly from Premiere Pro. Would love to know if anyone has found a solution to encode through Adobe Media Encoder.
@@PhilipDirven The other way is to click and drag the .csv file into the comp in After Effects, which doesn't work for projects with large numbers of comps referencing the same .csv. It also creates huge files sizes and slow processing. Very frustrating it's changed for no reason!
@@PhilipDirven Hey mate, just talked to Adobe Support. The only solution we found was to roll back the version of AME to v14.0 (others possibly work but I just tried the oldest available). It appears that for some reason the expression linking functionality has broken in newer versions. I don't know if it will be fixed, but at least they're aware of it now.
I'm not sure about that. I no longer have CS6 installed on my computer. You should join our free online mentoring group at ukramedia.com/community. We have a lot of very talented people on there who would love to help you. See you there!
Thank you ukramedia. But i had an issue with rendering, then i found on reddit : "In order to make AME read the data file you have to put the data file into every composition, that is referencing it." (aetipps)
I'm sorry, but I don't know how you were able to import the csv file into aftereffects. I have CC 2018 and it just won't let me import it! It doesn't even show any errors, no text files are even available as an option for me to import. Help? :(
"The first line is imported blank" that's the information I needed the internet to tell me! Many thanks.
Thanks a lot fot this! you saved my life with a project that requires a lot of name changes :)
Great tutorial mate! When I use this, media encoder renders the text as "undefined" - it looks good in AE. When I change text and save, AE refreshes, everything looks great. I know this must be a path issue since Media Encoder saves it's own AE file into Filename_AME folder - but no matter where I copy-pasted the .csv file, Media Encoder wouldn't see it.
Big Thanks! Great help!
Glad it helped!
Can this be done with from a csv file online? Like can we call it from a website?
I didn't know what CSV is but i can understand because of you thanks for your teaching an good video clips and tips
That's great to hear! Thanks for your comment!
Amazing tip .. and I am so happy that you are going to hit 1Lakh Subscriber soon.... I have seen your journey .. and I have lots of respect what you are doing to educate us all .. Thank you so much, from the bottom of my heart.
So cool! Can you change a color by putting the hex values in a column?
How do I replace an audio clip similar to this method? I will create a song with a "name" section and I want to export same song with different names, is there any way to it? Thanks in advance?
Thank you this is epic. Is there away to auto export a composition multiple times using a csv file? If lets say for example I want the each video to change the name of a person that appears in it.
Can you do this using image or just only text?
muito útil!!! Thanks for sharing
Can you Do That For Pictures , Videos and Audios ??
Great video. Much appreciated.
Glad it was helpful, Jeff!
Hi thanks for this tutorial! helped me a lot. what should I type in the expression box if I want to connect it to a dropdown menu in my Excel CSV?
This is great. Is there a way to use CSV to import an image from a specific file location in the same manor?
example CSV line would be
Brian, Videographer, /photo/brian-600x600.jpg
Was hoping someone would have answered. Maybe the answer is no I guess
Yep, just put the full file path in the cell.
I was wondering the same. If you find a way to do it do let me know :)
Thank you so much for this! :D
This is what I want to learn. Thanks a lot again sir.
That's great to hear, Shakil! Thanks for watching it!
wow... this blew my mind! Thanks
this is going to save me a loooot of time. Thanks!!
Great and so simple ! I try the same text with ".json" and it works. Thanks
Thank you, Mr Polo! You're right, it works well with .json as well.
And the important thing for me, i can open it (csv & json) with LibreOffice calc (excel) :)
Yup!
good job . great tutorial . and a nice person to explain it
Thank you, Hamza!
ukramedia can you make more after effects expressions tutorials
I am planning to do that soon. :-)
I'll be waiting for it . Thanks
Very Good!!!!
thanks, this is very useful and a great explanation!
hey, thanks for your knowledge, but i have probleme when i use csv, it doesnt work in the render, please, can u help me ?
Great, what about multilines, can I import multilines with breaks in each cell
Hi Sergei!
Hope you are amazing!
Can we assign the values from CSV to individual keyframes of a layer's position using the expressions or script?
Привет! Молодец ... This tip helped me cut part of a dayly task. I had written a extendscript to update an animation (a bar graph with results for the local stock exchange), now reading form a CSV file and making a few adjustments, the task is a bit more automated. Спасибо большое из Бразилии
That's great to hear! This knowledge is very valuable.
Nice efforts Sir
you are the best you helped me a lot
hello, first i would like to say this is a great video thank you so much for your hard work and sharing it with us in a nice simple manner.
second i have a question, if i wanna link the number of values in a column to a slide control what expression should i write like if a column got a title and 30 rows i wanna link it to a slide control so that it turns 31 what is the expression here?
again thank you so much
Hi, Thanks for the tutorial.
QUESTION: How do you go about batch exporting multiple compositions so each has their own unique information displayed from the CSV?
You need as many comps as you have rows but basically you would need to write an expression.
column = 0;
row = parseFloat(thisComp.name.toString());
footage("sample.csv").dataValue([column,row]);
In this example my comp name is just a number, if you want to have a long comp name you'll have to change the expression using something like a .split("-")
When you have a bunch of comps called 1,2,3... the expression will see the number and pick that row.
There might be an easier way but just saw this video and your comment and thought I'd give it a go solving it.
@@GregW05 You are amazing Gegory
can it work with replacing images as well?
Thanks so much for this tip Sergei. I am having a couple of small issues, though. First, this only seems to want to work with a basic text editor program like Notepad or Notepad++. Every time I've attempted to edit with something like Excel or another CSV editor, extra characters or spaces are added to the file, which then causes it to show error messages in AE. I then have to go back into Notepad, delete what has been added, and reload the csv in AE for it to be read again. Are there any spreadsheet style editors that you would suggest to make it easier for my team to be able to keep track of the data they're editing and won't cause these issues?
Second, when I attempt to export via Media Encoder, all of the text is replaced with "Undefined". Is there a way to allow ME to encode this project, or will I have to render through AE?
I actually figured out my first issue. There was somehow a tab space before one of the fields. After fixing that, I was able to edit in Excel and Save As a csv to update text.
I'm glad you were able to figure it out, Jeremy. You should join our free online mentoring group at ukramedia.com/community. We have a lot of very knowledgeable/talented artists who are very passionate about helping others. See you there!
Really like these daily tips and very useful for want I'm currently working on. I have link the CSV excel file to text layer>source text number. Is there a way to link the text layer>source text number to an point control number counter end number? Would this be an var expression or something similar?
awesome video
Great Tutorial....One question...if I'm giving sting value then how I will get the dataValue...eg: if the dataValue([0,1]) = ukramedia, how I will get dataValue if typing the sting same name (ukramedia) at any text layer. it will be great help for me if you are answer this question.
Hi! Thank you for the video! It helped me to understand how it work! I have a question. When I use CSV file in my project, After Effects run much much more slower. It really affects my work a lot even though I have quite fast computer. I googled it and found that some people had this problem as well but I didn’t find a solution. Do you have an idea why CSV slows the AF performance so much and how to avoid this? It would really help me A LOT!!! Thank you! :-)
can you apply colors from a csv file by using color codes or something?
Can you make it read down the column of data to show one value per frame (or per second, or whatever timestep you choose)?
Great question, Kate! Yes, you can, I'll have to do a tutorial on that. Thank you for your feedback!
Please do! I have searched everywhere to learn how to do that. I have a few ways I do it myself, but it's very clunky and I would love to learn a more elegant way that would allow you to use larger datasets without creating too much havoc.
So I used the second method. How would I go about dropping a new CSV into there and keep all the pickwick values the same? I currently make 24 different compositions on the same video but they have different values. I assume that if I change values in the CSV it'll change it on every after effects file. there's like 20 different text boxes so I can't really change it all.
Woah, so powerfull. I'm exporting Lower thirds for my clients conference at lightspeed now!
But, when I render I get a video with the text 'undefined' in it. Please help
@@PhilipDirven I've been using this method of CSV data for over a year, and only started getting "Undefined" during export since a CC update in Jan 2021. I cannot find any solution except to export individual videos directly from Premiere Pro. Would love to know if anyone has found a solution to encode through Adobe Media Encoder.
@@PhilipDirven The other way is to click and drag the .csv file into the comp in After Effects, which doesn't work for projects with large numbers of comps referencing the same .csv. It also creates huge files sizes and slow processing. Very frustrating it's changed for no reason!
@@PhilipDirven Hey mate, just talked to Adobe Support. The only solution we found was to roll back the version of AME to v14.0 (others possibly work but I just tried the oldest available). It appears that for some reason the expression linking functionality has broken in newer versions. I don't know if it will be fixed, but at least they're aware of it now.
@@FlexLineMedia There is another solotion. It's called 'CompsFromSpreadsheet' and is a paid app. I have it but didn't look into it yet.
can we change the names using slider controller ?
great！！
Nice tut, but is it possible to make a line break (if i add a line break the csv doesn't display correclty)?
ctrl + enter will break the line and this will be read byAE
Can we call image as the same?
Sir, can you please tell me, JSON or CSV files support in AE CS6 or not?
I'm not sure about that. I no longer have CS6 installed on my computer. You should join our free online mentoring group at ukramedia.com/community. We have a lot of very talented people on there who would love to help you. See you there!
@@ukramedia tnx u sir
I have a lot of texts titles, I need to render images, how can I make every frame to render the next string?
What if you need a comma in the displayed text?
Please make a plug-in like this
how do you change the font with expression to that layer?
Thanks alot
Thank YOU, Aktham!
how to get data from another comps csv data?
What about cyrillic in csv?
Thank you ukramedia. But i had an issue with rendering, then i found on reddit : "In order to make AME read the data file you have to put the data file into every composition, that is referencing it." (aetipps)
I'm sorry, but I don't know how you were able to import the csv file into aftereffects. I have CC 2018 and it just won't let me import it! It doesn't even show any errors, no text files are even available as an option for me to import. Help? :(
Were you able to figure it out?
@@ukramedia I was not. I can import json files for some reason, but nothing else. Is it something pretty obvious I'm missing?
I have the same problem, if you have solved let me know please. Thanks
This doesn't seem to work on CC 2015. No such import possible and there I was all ready to go :)
Has this now changed with the release of AfterEffects CC 2019?
I don't think it has, but I haven't tried it yet.
" ... & Use a CSV File in After Effects"? you are funny!
desnt work for me. idk why.
What version of After Effects are you using?
@@ukramedia CC. I had to find a different method to succed it and i havent found a decent way yet.
I tried it with Arabic text and doesn't work :(
can it work with replacing images as well?