Skip to main content
ckernevez7
Participant
May 17, 2018
Pregunta

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

  • May 17, 2018
  • 2 respuestas
  • 4555 visualizaciones

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

Este tema ha sido cerrado para respuestas.

2 respuestas

John Mensinger
Community Expert
Community Expert
May 17, 2018

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.

vinny38
Legend
May 17, 2018

Hi

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