: InDesign: Import spreadsheet as single, formatted, column I'm laying out 100+ business listings into a three-column document. The listings are currently in a .csv spreadsheet that looks like so:

Posted in: #AdobeIndesign #Formatting #Import

I'm laying out 100+ business listings into a three-column document.

The listings are currently in a .csv spreadsheet that looks like so:

A | B | C | D

Company name | Location | Blurb | Contact Info

ABC Ltd. | Bristol | Great company, cheap prices. | 0117 9876543

DEF Inc. | London | Great prices, cheap company. | 020 234 5667

GHI GmbH. | Berlin | Grosse Firma, gunstige Preise. | 30 12345 678

I'd like to import, and if possible sync, the spreadsheet into my 4-column layout like so, with applied character formatting (font size, colour etc.) for each imported column:

ABC Ltd.
Bristol
Great company, cheap prices.
0117 9876543

DEF Inc.
London
Great prices, cheap company.
020 234 5667

GHI GmbH.
Berlin
Grosse Firma, gunstige Preise.
30 12345 678

Can anyone suggest how I might do this, if it is in fact possible? All the info I can find suggests that I can only import a sheet as a table, which doesn't suit my requirements.

I'd prefer a solution that can be achieved in InDesign, rather than formatting in the spreadsheet or other programs first, though if that's the only way of doing things that works for me!

If any clarification's needed let me know, I really appreciate any help or pointers anyone can give me on this.

Thank you!

10.01% popularity Vote Up Vote Down

: How to add different colors to multiple segments in a circle I have created a circle and divided it into 4 sections via the pen tool. My problem is that I am unable to completely fill

@Goswami567

Posted in: #AdobeIllustrator #Color #Fill #Path

2 Comments

: What is the correct term of this part on a typeface a quick question. What is the correct term of this (see picture) on a font?

@Goswami567

Posted in: #Fonts #Terminology

2 Comments

: Convert PSD to SVG and add white path to a colored image I have a coloured logo that I have created in photoshop. I would like to export this to SVG, however, I also need to add a white

@Goswami567

Posted in: #Css #Svg

1 Comments

: How to avoid random fill pattern dialog box when using action in photoshop? I want to create a action that fill pattern randomly. I have created an sample pattern but it show me dialog box

@Goswami567

Posted in: #AdobePhotoshop #PhotoshopScripting

1 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Lee3735518

It is possible - but you need some experience in indesigns datamerge and an additional script from Loic called inline merge. With datamerge you can import the content of your csv to indesign. In datamerge options you can set multiple records per page so you can import like 16 records per page. Including Our styling. What datamerge cannot handle is the flowing of content inside one text frame
Therfore you meed the above mentioned script.

edit: for indesign datamerge your csv has to be comma separated and utf 16 encoded

10% popularity Vote Up Vote Down

Feed

: InDesign: Import spreadsheet as single, formatted, column I'm laying out 100+ business listings into a three-column document. The listings are currently in a .csv spreadsheet that looks like so:

More posts by @Goswami567

: How to add different colors to multiple segments in a circle I have created a circle and divided it into 4 sections via the pen tool. My problem is that I am unable to completely fill

: What is the correct term of this part on a typeface a quick question. What is the correct term of this (see picture) on a font?

: Convert PSD to SVG and add white path to a colored image I have a coloured logo that I have created in photoshop. I would like to export this to SVG, however, I also need to add a white

: How to avoid random fill pattern dialog box when using action in photoshop? I want to create a action that fill pattern randomly. I have created an sample pattern but it show me dialog box

Login to post a comment!

1 Comments

Back to top | Use Dark Theme