I want to import data from a table saved as a csv file to my indesign table

[ckernevez7]

Hello all,

I want to import data from a table saved as a csv file to my indesign table.

Pb is that it inputs only one data in all rows? please help

[vinny38]

Hi

What about opening your CSV in Excel (or another spreadsheet software) and resave it in .xls?

[John Mensinger]

ckernevez7  wrote

I want to import data from a table saved as a csv file to my indesign table.

The csv file is no longer a table. To get what you need, you have 2 primary options; vinny38 already gave you option 1: re-open the csv file in a spreadsheet application so it gets re-interpreted to columns and rows, or option 2: do that reinterpretation in InDesign.

For option 2 you'll have to first just paste all the text from the csv file into an ordinary InDesign text frame. Then, with all that text selected, choose Table > Convert Text to Table.

Seeing as it's a CSV (Comma-Separated-Value) file, in the Convert Text to Table dialog, choose Comma from the Column Separator menu:

Leave the Row Separator set to Paragraph and click OK.

This will result in a new table you can format as desired, or from which to copy/paste to a pre-existing table.