Help Getting Excel Spreadsheets Into Table DAT

General TouchDesigner Discussion
1

Hi,

I’m trying to find a way of getting an Excel spreadsheet (8899 rows, 13 columns) into a Table DAT so that the data can be used in more creative ways in Touch Designer. I’ve tried exporting the spreadsheet as a tab delimitated txt file but, when I open it in the Table DAT, I just get one row with all the other rows formatted as columns.

Any ideas or known techniques that work? Thanks

PJ

2

Save as a CSV.
Change the file extension to .txt.
It touch, use a table DAT to open the txt file, then use a convert DAT to split at commas.

I think that’ll do the trick.

1 Like
3

That worked perfectly.

Thank you!!

4

Or use TSV (tab separated values), and you can just use the file parameter in a Table DAT, without having to do the conversion.

1 Like