Extensions
  • Home
  • Add-ons
  • Themes
  • Approval Queue
  • About
  • Upload Extension
  • Sign in
  • BLENDER.ORG

    • Download

      Get the latest Blender, older versions, or experimental builds.

    • What's New

      Stay up-to-date with the new features in the latest Blender releases.

    LEARNING & RESOURCES

    • Blender Studio

      Access production assets and knowledge from the open movies.

    • Manual

      Documentation on the usage and features in Blender.

    DEVELOPMENT

    • Developers Blog

      Latest development updates, by Blender developers.

    • Documentation

      Guidelines, release notes and development docs.

    • Benchmark

      A platform to collect and share results of the Blender Benchmark.

    • Blender Conference

      The yearly event that brings the community together.

    DONATE

    • Development Fund

      Support core development with a monthly contribution.

    • One-time Donations

      Perform a single donation with more payment options available.

All Add-ons

Add-on Spreadsheet Import
Spreadsheet Import

Import data to spreadsheet for use with geometry nodes.
Add-on by smonbrogg
About Permissions Reviews Version History
imported data in blender spreadsheet
imported data in blender spreadsheet

New CSV Importer by Jan-Hendrik Müller

There's a new and improved CSV Importer: https://extensions.blender.org/add-ons/csv-importer/

Blender Spreadsheet Import

Import CSV or JSON data into blender spreadsheet.
The data can then be processed with geometry nodes to be visualized.

Usage

  1. Open the importer in Blender via File / Import / Spreadsheet Importer
  2. Use the filebrowser to choose a .csv or .json file
  3. Add the field names to be imported by clicking the + icon to the right of the list
  4. Type in the field names and choose their data types
    • When importing CSV, the field names must be present in the header row of the csv. The header row is a line that names the columns
    • When importing JSON, the field names must be present in the objects within the data array.
  5. When importing JSON, specify the array name where the data is in your JSON File. It must be in the root JSON object, and it must contain an array.
  6. When importing CSV, check if the delimiter is correct
  7. When importing CSV with lines before the header row, discard these by setting the Discard leading lines value
  8. Press the Import Spreadsheet button in the bottom right. The Importer will create a new Object named after the imported file. The Object wil have Mesh Data attached to it called csv_data or json_data depending on the imported file type.
  9. Check the Spreadsheet viewer in Blender to see if the data has been imported correctly.

Example Node Setup

To use the imported data in any geometry nodes tree, add an Object Info node and select the object containing the imported data in the object field.

If later you want to replace the data, you can do this in the object data properties of the selected object: Link another mesh data block to the object, and the values will update. If used column names still exist in the newly linked data block, everything should update as expected.

Sample a single value

Node setup to sample a value

Bar chart

A single float value named "field_name" is used to scale some cubes.
The Domain Size node is used to find the amounts of bars needed (the size of the imported dataset), and a duplicate of the bar geometry is created for each row of data. The duplicates are then ofset along the X axis according to the duplicate index, and scaled along the Z axis according to the data sampled from the "field_name" comumn where the row matches the duplicate index.

Node setup for a bar chart

Bar chart

Example import settings

Sample CSV Import settings

Example import options for a CSV file

Sample CSV Data:

"T 08.02.01.01.01";;;;;;;;
"Endenergieverbrauch nach Energieträger";;;;;;;;
"Tausend Terajoules";;;;;;;;
;;;;;;;;
;"Total";"Brennstoffe";"Treibstoffe";"Elektrizität";"Gas";"Kohle";"Holz und Holzkohle";"Übrige Energieträger"
"2010";"905.17";"190.41";"295.08";"215.23";"115.94";"6.21";"40.93";"41.37"
"2011";"844.34";"150.85";"296.59";"210.96";"104.21";"5.74";"35.62";"40.37"
"2012";"875.82";"161.13";"299.85";"212.3";"114.32";"5.17";"39.44";"43.61"
"2013";"897.88";"168.46";"299.77";"213.56";"120.79";"5.57";"43.46";"46.27"
"2014";"827.99";"127.55";"298.26";"206.88";"107.13";"5.7";"36.73";"45.74"
"2015";"840.71";"133.89";"290.53";"209.69";"112.93";"5.21";"39.15";"49.31"
"2016";"856.43";"136.35";"291.82";"209.66";"117.24";"4.79";"42.32";"54.25"
"2017";"852.26";"127.93";"290.1";"210.54";"118.91";"4.61";"42.72";"57.45"
"2018";"833.25";"115.63";"294.3";"207.53";"112.31";"4.29";"40.45";"58.74"
"2019";"836.23";"112.31";"294.36";"205.91";"115.21";"3.81";"41.08";"63.55"
"2020";"747.9";"101.11";"226.72";"200.57";"112.9";"3.66";"39.86";"63.08"
"2021";"794.72";"111.71";"233.21";"209.21";"122.28";"3.7";"46.39";"68.22"
;;;;;;;;
"Letzte Änderung:  27.07.2022";;;;;;;;
"Quelle: BFE � Gesamtenergiestatistik";;;;;;;;
"� BFS 2022";;;;;;;;

The imported Data viewed in the spreadsheet editor:

Imported data viewed in blender spreadsheet


What's New

No changelog for this release.


Permissions

This extension requests the following permission:

  • Files

    Load CSV and JSON files from disk

Developer
smonbrogg
Rating
(1)
Version
0.4.0
Updated
7 mo
Published
Oct. 10th, 2024
Downloads
5420
Size
16.2 KB
Compatibility
Blender 4.2  and newer
Report Issues
github.com/simonbroggi/blender_spreadsheet_import/issues
License
GNU General Public License v3.0 or later
Import-Export Geometry Nodes
...or download and Install from Disk
  • 16.2 KB

Reviews

See all
  • Louis_v_a
  • v0.4.0
  • 3 mo

Fantastic add-on! For me an efficient way to import cad data (objects) into blender. Thanks for the good work!

5.0

1 review
5
4
3
2
1
Rate this Add-on
  • About
  • Privacy Policy
  • Terms of Service
Download
  • Latest Blender
  • Blender LTS
  • Blender Benchmark
  • Previous Versions
  • Experimental Builds
  • Source Code
  • Release Notes
  • Requirements
Organization
  • People
  • Jobs
About
  • Blender Foundation
  • Blender Institute
  • Blender Studio
  • License
  • Logo & Trademark
  • Credits
  • Privacy Policy
Articles
  • News
  • Press Releases
  • User Stories
Get Involved
  • Dashboard
  • Development
  • Documentation
  • Education
Blender Studio
  • Films
  • Training
Support
  • Manual
  • Community
  • FAQ
Developers
  • Get Started
  • Projects
  • Docs
  • Blog
  • Forum
  • YouTube
  • Python API
Blender Conference
Follow Blender
Support Blender
  • Donate
  • One-time Donation
Artistic freedom starts with Blender The Free and Open Source 3D Creation Suite