Tab Delimited text
And place that file
What you can also do is import the Excel file as a Table
Then use Table>Convert Table to Text
And set your own delimmiters for the separtings rows and columns.
Thanks so much! I tried converting the table to text, but that option was not available to me in Indesign. I see it... but it's grayed out. So I tried saving the Excel file as tab deliminated text. This works, but it imports tons of extra tabs. So I have to go in and delete thousands of tabs. Is there a way to just save the data as text (as opposed to the entire spreadsheet... including the blank cells...which is what I think it's doing)?
You need to select all the rows and columns you want to convert in the table for the option to become available.
Insert your text cursor
CTRL ALT A
or on a Mac
CMD OPtion A
My eyes deceived me - I thought the option was there but couldn't see it .. alas it was there all along.