if the table isn't big, the cells could simply be copied and pasted into indesign.
if the tables are huge, i'd recommend this write-up by David Blatner of indesignsecrets.com about a script which does exactly what you want: http://indesignsecrets.com/using-data-merge-to-create-a-table-for-a-directory.php
Thank you verrrrrry much! This is exactly what we need.
I want to ask you all for more information about my earlier question (see above). Now I've heard that Indesign CS6 has a built-in option for merging a CSV table into Indesign tables without using a plug in or script. Can anyone tell me more about this feature or is this still not possible to do without plug ins or scripts?
Are you able to quote a source of this merging CSV tables into indesign cs6? I've not heard of that.
It is important to note that InDesign has, for quite some time now, had the ability to import excel spreadsheets into indesign. The file can also be "linked" but I use that term loosely as if the table is manipulated in InDesign and then the excel file changes, any InDesign alts will be lost. A plug-in is in development at the moment (for word at least) that may assist with this though: http://indesignsecrets.com/import-word-documents-edit-in-word-and-indesign-and-keep-linked -for-updating.php
However, what are you expecting to do? If it is bringing a spreadsheet into indesign to maintain most of its original appearance, the import option is the way to go. If it is bringing in the components of a spreadsheet but changing their position, format, etc so the items can be repeated in blocks such as a business card, letter, or product catalogue item, then i'd say data merge/XML/third party plug-in would do.
Somehow, I think using data merge for this task is barking up the wrong tree.
For anyone landing on this old post, things have changed in the last InDesign versions. It’s now possible to link a spreadsheet into InDesign so that, if you edit it, the content of the table in InDesign can be updated (more or less as with images edited in Illustrator or Photoshop). My colleague Stefano wrote a tutorial about it: https://redokun.com/blog/link-indesign-tables-to-excel-spreadsheets