Indesign with Data Merge

New Here ,
Mar 21, 2022 Mar 21, 2022

Copy link to clipboard

Copied

I am trying to do a data merge with an excel list (.txt format) and I have a cell that has a list of items with a hard break/return (see attached).

 

I would like to pull this information into Indesign via Data Merge and have it show up as a bullet list. When I try the Data Merge, it only pulls in the first item. Does anyone know how to make this work?

 

 

Views

75

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Mar 22, 2022 Mar 22, 2022

Copy link to clipboard

Copied

Let me move this to the InDesign forum for you, which is the appropriate forum for your question.

The Using the Community forum is for help in using the Adobe Support Community forums, not for help with specific programs, installation issues, or account issues such as subscription questions or billing problems, or generalized questions about Creative Cloud services.

* Product questions should be posted in the associated product community.
* Installation questions should be posted in the Download & Install community.
* Account issues, including subscription questions or billing problems, should be posted in the Account, Payment, & Plan community.
* Questions about the Creative Cloud desktop app or general questions about apps in the Creative Cloud should be posted to the Creative Cloud Services community.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Mar 22, 2022 Mar 22, 2022

Copy link to clipboard

Copied

There may be third-party plugins that could help with that, but InDesign's Data Merge reads a data sheet in simplest terms; 1 row = 1 record. A return constitutes a new row/record, and there's no way around it.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Mar 22, 2022 Mar 22, 2022

Copy link to clipboard

Copied

LATEST

Hi vcp-countryman,

I would substitute the end-of-paragraph characters in your source Excel file with a unique sequence of characters you do not use elsewhere in the document, like §§§ perhaps. After the merge I'd do a text find/change action to change the sequence to a ^p end of paragraph character.

 

Regards,
Uwe Laubender

( ACP )

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines