You will need Rama’s plugin:
The node you are interested in: Load String Array From File
A. This is my Excel file. Vertical bar (|) is used a separator. Since I need commas in the sentences, I use ‘|’ instead of handling comma-separated values.
B. Once copied to a text file, it looks messy.
C. And the blueprint:
D. What happens here.
- Loop through the array and explode each line into 7 elements using ‘|’ as a delimiter.
- Limit will prevent reading further down the road, 8th element will be skipped in this instance.
- You can get one of the 7 strings directly from the array outputted by the explode node.
Let me know if it works as intended! :>