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.
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.
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.