Excel Data To Animated 3D Line Graph Using Blender | Easy Graph Animation Tutorial & Python Script

In this Blender tutorial, we have discussed how to convert some excel data into a 3D line graph with animation. We will use a script for this operation - in fact two. The scripts are given below, just scroll down. Please watch the video for the complete tutorial. If you have any question on this tutorial, please leave your comment below.

==================================================

𝐅𝐢𝐫𝐬𝐭 𝐬𝐜𝐫𝐢𝐩𝐭: 𝐓𝐡𝐢𝐬 𝐬𝐜𝐫𝐢𝐩𝐭 𝐞𝐧𝐚𝐛𝐥𝐞𝐬 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 𝐭𝐨 𝐫𝐞𝐚𝐝 𝐟𝐫𝐨𝐦 𝐞𝐱𝐜𝐞𝐥 𝐟𝐢𝐥𝐞𝐬.
𝐘𝐨𝐮 𝐧𝐞𝐞𝐝 𝐭𝐨 𝐫𝐮𝐧 𝐢𝐭 𝐨𝐧𝐥𝐲 𝐨𝐧𝐜𝐞 𝐟𝐨𝐫 𝐲𝐨𝐮𝐫 𝐦𝐚𝐜𝐡𝐢𝐧𝐞 👇👇

𝐒𝐞𝐜𝐨𝐧𝐝 𝐬𝐜𝐫𝐢𝐩𝐭: 𝐓𝐡𝐢𝐬 𝐢𝐬 𝐭𝐡𝐞 𝐚𝐜𝐭𝐮𝐚𝐥 𝐬𝐜𝐫𝐢𝐩𝐭 𝐭𝐨 𝐜𝐫𝐞𝐚𝐭𝐞 𝐭𝐡𝐞 𝐚𝐧𝐢𝐦𝐚𝐭𝐢𝐨𝐧.
𝐘𝐨𝐮 𝐧𝐞𝐞𝐝 𝐭𝐨 𝐫𝐮𝐧 𝐢𝐭 𝐨𝐧𝐜𝐞 𝐟𝐨𝐫 𝐞𝐚𝐜𝐡 𝐞𝐱𝐜𝐞𝐥 𝐟𝐢𝐥𝐞 👇👇

𝐓𝐡𝐢𝐫𝐝 𝐬𝐜𝐫𝐢𝐩𝐭: 𝐘𝐨𝐮 𝐜𝐚𝐧 𝐚𝐥𝐬𝐨 𝐬𝐚𝐯𝐞 𝐲𝐨𝐮𝐫 𝐄𝐱𝐜𝐞𝐥 𝐟𝐢𝐥𝐞 𝐚𝐬 𝐚 𝐂𝐒𝐕 𝐟𝐢𝐥𝐞 𝐚𝐧𝐝 𝐮𝐬𝐞 𝐭𝐡𝐞 𝐟𝐨𝐥𝐥𝐨𝐰𝐢𝐧𝐠 𝐬𝐜𝐫𝐢𝐩𝐭 𝐭𝐨 𝐜𝐫𝐞𝐚𝐭𝐞 𝐚 𝟑𝐃 𝐠𝐫𝐚𝐩𝐡 𝐟𝐫𝐨𝐦 𝐭𝐡𝐚𝐭 𝐂𝐒𝐕 𝐟𝐢𝐥𝐞. This is recommended if you are getting an error while running the above script. In this script, you need to mention the CSV file path instead of Excel, and all other things remain the same.

𝐘𝐨𝐮 𝐧𝐞𝐞𝐝 𝐭𝐨 𝐫𝐮𝐧 𝐢𝐭 𝐨𝐧𝐜𝐞 𝐟𝐨𝐫 𝐞𝐚𝐜𝐡 𝐂𝐒𝐕 𝐟𝐢𝐥𝐞 👇👇

==================================================

We have many more tutorials that can help you learn Blender like a professional. You can go through the following playlists for the relevant topics:

👇 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 𝐅𝐨𝐮𝐧𝐝𝐚𝐭𝐢𝐨𝐧 𝐂𝐨𝐮𝐫𝐬𝐞 𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬:
If you are absolutely new to Blender, take this foundation course.

👇 𝐀𝐥𝐥 𝟏𝟐 𝐂𝐥𝐚𝐬𝐬𝐞𝐬 𝐓𝐨𝐠𝐞𝐭𝐡𝐞𝐫 𝐈𝐧 𝐎𝐧𝐞 𝐇𝐨𝐮𝐫:

👇 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 𝐓𝐢𝐩𝐬 𝐀𝐧𝐝 𝐓𝐫𝐢𝐜𝐤𝐬 (𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬):

👇 𝐄𝐚𝐬𝐲 𝐌𝐨𝐝𝐞𝐥𝐬 𝐅𝐨𝐫 𝐁𝐞𝐠𝐢𝐧𝐧𝐞𝐫𝐬 (𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬):

👇 𝐌𝐚𝐭𝐞𝐫𝐢𝐚𝐥𝐬 𝐘𝐨𝐮 𝐍𝐞𝐞𝐝 𝐈𝐧 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 (𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬):

👇 𝐀𝐥𝐥 𝐓𝐞𝐱𝐭 𝐄𝐟𝐟𝐞𝐜𝐭𝐬 𝐈𝐧 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 (𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬):

👇 𝐂𝐚𝐦𝐞𝐫𝐚 𝐌𝐨𝐯𝐞𝐦𝐞𝐧𝐭 & 𝐒𝐞𝐭𝐭𝐢𝐧𝐠𝐬 𝐈𝐧 𝐁𝐥𝐞𝐧𝐝𝐞𝐫:

👇 𝐔𝐬𝐞𝐟𝐮𝐥 𝐋𝐢𝐠𝐡𝐭𝐢𝐧𝐠 𝐒𝐞𝐭𝐮𝐩 𝐈𝐧 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 (𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬):

👇 𝐑𝐢𝐠𝐢𝐝 𝐁𝐨𝐝𝐲 𝐏𝐡𝐲𝐬𝐢𝐜𝐬 & 𝐑𝐢𝐠𝐢𝐝 𝐁𝐨𝐝𝐲 𝐂𝐨𝐧𝐬𝐭𝐫𝐚𝐢𝐧𝐭𝐬:

👇 𝐅𝐢𝐫𝐞 & 𝐒𝐦𝐨𝐤𝐞 𝐒𝐢𝐦𝐮𝐥𝐚𝐭𝐢𝐨𝐧 𝐈𝐧 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 (𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬):

👇 𝐅𝐥𝐮𝐢𝐝 𝐒𝐢𝐦𝐮𝐥𝐚𝐭𝐢𝐨𝐧 𝐈𝐧 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 (𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬):

👇 𝐌𝐚𝐬𝐭𝐞𝐫𝐢𝐧𝐠 𝐁𝐥𝐞𝐧𝐝𝐞𝐫 (𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬):

If you want to watch our own creations in Blender, you can also check out the following channel where we regularly upload videos on Animation, Space Exploration and AI.

#Blender #Animation #Tutorial #Excel

Timestamp
00:00 Create a link between Blender & Excel
00:56 Convert an excel file into 3D animation
02:32 Further enhancements with Python

[SourceAwareness]

This is Excellent, thanks so much, my Good Friend!! I've been looking for something like this.

[mohamedabdo-xgtw]

I just received my member contents. let's Goooo !

[imine]

The pip install step can be skipped by including the path to your pandas or whatever system python module by doing something like import sys; import pandas as p at the top of your csv script
The way to find the path to include, is open your python console (not the blender python but system python) import whatevermodule;
And thanks for the great video! Was very useful in understanding how to integrate csv files and blender 🙏

[sebbosebbo]

p.s. Text option for data points and other visual style type or shapes....cool idea..

[skillmaxacademy]

Thank you please do construction animation using animation nodes

[pufoamtoolsandguides]

with blender version 3.5 it just copy paste and run. good job

[mayssayasmina]

H great method, can we export this animation to gltf or glb ? thank you

[kebabsharif]

THANK YOU FOR YOUR VIDEO, I USED YOUR CODE THEN I NOTICED THAT THE YELLOW CURVE SAW NOT SHOWING IS IT CORRECT OR I MISSED SOMETHING? THANK YOU IN ADVANCE.

[muhamedsewidan]

Great video, thank you. But I have a problem running the code because I have all the required packages on my python, but blender can't read it and when I try to install these packages in blender it says the requirements are already satisfied. Can you help me?

[selumi]

Thank you. I tried this code and it was just I needed for graph animation. One question if it's okay to ask: my data has decimal numbers and negative numbers. The graph showed a long decimal numbers when I tried to run the code. for example, 0.5165 becomes on the graph. Is there anyway to fix the code?

[pigcheong]

in the file path: what is "r" stand for, (I am using mac os), ....thank you

[kylebeschler]

For the pdf displaying the errors, where would I place the two pieces of code at? This is where I got stumped cuz I do have some experience with python but not a ton.

[dustonclubs]

I want to change month column to a integer value? In code where I need to change?

[sportsplusph]

Maybe you can help me sir, error appears even if i change the first script based on the installation folder...

[InOppositiontotheNewWorldOrder]

Do you have a script for LibreOffice Writer?

[cognizantcomparisons]

Hey I sent a mail about an issue!
There is no line drawn for me. The dots pop up bet there is no line between them. Do you know how to fix this issue?

[dustonclubs]

Make a tutorial on this how to make 2 graph lines

[alexanderg]

I don't get it.. I want to input my x value not as a "month" but a number.

[preeshanupadhyay]

HOW DO I ADD A LOGO IN THE ANIMATION ?

[dustonclubs]

Can’t animate with 4 digit number? Solution plz?