Skip to content

Spreadsheet Import

by smonbrogg·Workflow

Images © smonbrogg. Used for product review; image policy.

Why we like it

Spreadsheet Import earns its spot in the blender_extensions library by connecting external CSV and JSON data to Blender's geometry nodes workflow. Version 0.4.0 targets Blender 4.2 LTS and newer and is distributed under the GNU GPL v3.

What is Spreadsheet Import?

Spreadsheet Import is a Blender add-on from smonbrogg that brings CSV or JSON data into Blender's spreadsheet, where it can be processed with geometry nodes and visualized. You open it through File / Import / Spreadsheet Importer, choose a .csv or .json file, then add each field name with the + icon and set its data type before importing.

Pressing Import Spreadsheet creates a new object named after the file, with mesh data called csv_data or json_data. For CSV files, the field names must sit in the header row, and options let you set the delimiter and discard leading lines above the header. JSON imports read field names from objects inside a data array, whose name you specify in the root JSON object. The Spreadsheet viewer confirms the data came in correctly.

To use the data, add an Object Info node in a geometry nodes tree and select the imported object. You can replace the dataset later by linking a different mesh data block in the object's data properties, and the values update as long as the referenced column names still exist. Version 0.4.0 supports Blender 4.2 LTS and newer and is released under the GPL v3.

Who is Spreadsheet Import best for?

Spreadsheet Import is best for blender users bringing tabular CSV or JSON data into geometry nodes for visualization.

How much does Spreadsheet Import cost?

Spreadsheet Import is completely free to download and use.

Key features

  • Imports CSV and JSON files into Blender's spreadsheet
  • Field names and data types are defined manually before import via the + icon
  • Creates a new object named after the file, with mesh data called csv_data or json_data
  • CSV options for setting the delimiter and discarding leading lines above the header row
  • JSON import reads field names from objects inside a specified data array
  • Imported data feeds a geometry nodes tree through an Object Info node
  • Data can be swapped by linking a different mesh data block, updating the values

Tags

#CSV import#JSON import#geometry nodes#data visualization#spreadsheet#data import#Blender add-on

Frequently asked questions

Does Spreadsheet Import work with Blender 4.2?

Spreadsheet Import lists compatibility with Blender 4.2 LTS and newer, so current 4.x releases are covered. The add-on adds an entry under File / Import / Spreadsheet Importer, where you pick a .csv or .json file and define the field names to bring in. Version 0.4.0 was last updated on 2024-10-10. For behaviour on other Blender versions, the developer's GitHub page is the place to check, since the stated support starts at 4.2 LTS.

How do I import a JSON file with Spreadsheet Import?

Spreadsheet Import reads two file types, CSV and JSON. For JSON, the field names you import must exist in the objects inside a data array, and you specify that array's name, which has to live in the root JSON object and contain an array. For CSV, the field names must appear in the header row, and you can set the delimiter and discard any leading lines above the header. In both cases you add each field name and choose its data type before importing.

How do I use imported data in geometry nodes?

Spreadsheet Import stores the imported values as mesh data on a new object named after your file, called csv_data or json_data depending on the format. To use it in a geometry nodes tree, add an Object Info node and select that object in the object field. From there the data can be sampled and processed, for example scaling geometry per row using values from a named column. Checking Blender's Spreadsheet viewer confirms the data imported correctly before you build the node setup.

How do I replace the data after importing with Spreadsheet Import?

Spreadsheet Import lets you swap the data after an import without rebuilding your setup. In the object data properties of the imported object, link a different mesh data block, and the values update. As long as the column names you rely on still exist in the newly linked data block, the geometry nodes reading them should update as expected. This keeps an existing node tree pointed at the same object while the underlying dataset changes.

Is Spreadsheet Import free?

Spreadsheet Import is listed as free here and is distributed under the GNU General Public License v3.0 or later. The add-on requests a single permission, to load CSV and JSON files from disk. For the current licensing terms, source code and any updates, the developer's GitHub page is the best reference. The project is developed by smonbrogg, with version 0.4.0 last updated on 2024-10-10.

Alternatives to Spreadsheet Import

Also in Workflow for Blender.

Similar plugins