File - drag in a Google Sheet or .csv asset from the Assets Window.
Column Title - select a column from your spreadsheet. The first row of your spreadsheet is reserved and used to populate this list.
A Spreadsheet node can only output data from a single column. In order to use several columns from the same .csv you need to create a Spreadsheet node for each column you want to output.
Factorize - when checked, a column of text can be converted into values. For example, a column of data containing the text Summer, Spring, Summer, Summer can be converted to a list of values 1, 0, 1, 1. The resulting list is ordered alphabetically.
For performance reasons the asset (.csv or Google Sheet) must also be 'factorized'. Right click on the asset in the Asses Window and check Factorize.
Remapping - remap numerical values relative to the lowest and highest number in your data. For example, if you want to create a bar chart and need a value of 1 to be represented by a rectangle with a height of 300px, you can.
If you have a minimum value of 0 and a maximum of 10 within your data and a simple black to white gradient, a value of 0 will be Black, a value of 10 will output White and a value of 5 will be remapped to 50% grey.
Fixed Row - When checked it will output the contents of the row specified in Row Index (not including the title row). Useful for Dynamic Rendering.
Row Index - specify the row to output. A value of 0 outputs row 1 of your spreadsheet (row 0 is reserved for Column Title).
Row Offset - add or subtract a value to Row Index.
Use Every Nth Row - only sample the first and then every Nth row where N = the value.
Row Count - a read only attribute that outputs the number of rows in the selected column.
Set Source Maximum to 2500. These to values roughly contain the range of your data.
Set Minimum to 0.
Set Maximum to 500.
A value of 0 in your data will now output as 0 while a value of 2500 will be output at 500. In this example we are effectively dividing all values by 2500/500 = 5 so a value of 1000 would be remapped to 200.