• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

Import Data from Excel to InDesign for Formatting

New Here ,
Oct 27, 2022 Oct 27, 2022

Copy link to clipboard

Copied

Hello!

I have an excel file with the details of a directory for printing in a magazine, business name, address, phone, website. I am looking for a way to import that data into InDesign and format it using paragraph styles. I have defined a paragraph style for each field, I want the web address, business name, phone number each formatted to a specific paragraph style. 

I am familiar with a data merge, where you can assign each field a format, but I don't want to create separate files for each entry, I want the text to run continuously in one text field. I have also tried placing the excel file, but I can't find a wat to assign formatting.

Any tips would be greatly appreciated!

TOPICS
How to

Views

38

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

correct answers 1 Correct answer

Advisor , Oct 27, 2022 Oct 27, 2022

Import data as a table, format columns - then if you don't want a table look - convert table to text with Paragraph as a field separator.

 

AdobeScripts_1-1666899336605.png

 

 

Likes

Translate

Translate
Advisor ,
Oct 27, 2022 Oct 27, 2022

Copy link to clipboard

Copied

Import data as a table, format columns - then if you don't want a table look - convert table to text with Paragraph as a field separator.

 

AdobeScripts_1-1666899336605.png

 

 

Can automate anything - as long as it doesn't require A.I.

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
New Here ,
Oct 27, 2022 Oct 27, 2022

Copy link to clipboard

Copied

LATEST

This did the trick! Thanks very much!

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