TurboTax Desktop program allows for the import of TXF files, but not excel or CSV. Because you have a 1099 that shows the sum of all of the data listed in your spreadsheet, you can use that to enter your 1099-DIV information instead of entering each 1099-DIV separately.

Thanks. That would be ideal if it will work. What should I use as the name and FEIN on this aggregate 1099? (Remember this is not a consolidated statement like you would get from Vangard e.g.)

I was able to put in this total info as a 1099 in forms. I  left FEIN blank, but step-by-step flags that as an error. Maybe use all zeros or will that freak out IRS computers?

Should I attach the spreadsheet showing a line for each individual 1099 as an attachment, if there is a way to do that in TT? 

You do not have to input the FEIN for your combined 1099-DIV entry and can leave it blank. If you do get a review message, you should be able to bypass it and e-file your return. 

Lastly, you cannot attach a PDF or any type of document to your return. I would suggest keeping it in your records in case the IRS asks for backup documentation. 

@alexy0211