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

Use Indesign data merge to insert calendar dates from CSV document

New Here ,
Jul 11, 2021 Jul 11, 2021

Copy link to clipboard

Copied

I am trying to create a planner that has dates that are going to be inserted using the data merge feature.

I saved an excel file as a csv and it contains all the information thats needed. It has hebrew dates and english dates (each is saved as a separate column).

I'm a bit confused how to go about this merge?

Does Indesign have a feature that's similar to the microsoft word "next record" idea?

If not, how do I tell Indesign to insert 5 different dates (which will be coming from 5 consecutive rows in my excel document)?

Any help on this topic would be extremely helpful.

Thank you.

TOPICS
How to

Views

2.0K

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

Community Expert , May 10, 2024 May 10, 2024

I [probably] would use one of two methods:

 

Votes

Translate

Translate
Community Expert ,
Jul 13, 2021 Jul 13, 2021

Copy link to clipboard

Copied

Votes

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 ,
May 09, 2024 May 09, 2024

Copy link to clipboard

Copied

Hi RS, Were you able to figure this out? I am trying to do the same thing but can't figure out the merge with multiple records and a few pages...

Votes

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 ,
May 09, 2024 May 09, 2024

Copy link to clipboard

Copied

Unfortunately not, sorry

Votes

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
Community Expert ,
May 09, 2024 May 09, 2024

Copy link to clipboard

Copied

@Tziporah0101, @RS Circle

 

The best way for calendars is to create InDesign Tagged Text from Excel.

 

Depends on your layout - you can either create a table or contents for linked TextFrames. 

 

Votes

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 ,
May 09, 2024 May 09, 2024

Copy link to clipboard

Copied

Thank you. Do you have any tutorials or instructions on how to do that?

Votes

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
Community Expert ,
May 09, 2024 May 09, 2024

Copy link to clipboard

Copied

Can you post a screen shot of your layout? I'm wondering if a table layout might work.

 

David Creamer: Community Expert (ACI and ACE 1995-2023)

Votes

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 ,
May 09, 2024 May 09, 2024

Copy link to clipboard

Copied

Here is a sample from another calendar that is similar to what I want to do. See how there are the dates, the Hebrew dates, sunrise and sunset times, and more. I would need a few things in every box, and this is for a full year calendar.

Thank you for your help!

Votes

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
Community Expert ,
May 10, 2024 May 10, 2024

Copy link to clipboard

Copied

LATEST

I [probably] would use one of two methods:

 

David Creamer: Community Expert (ACI and ACE 1995-2023)

Votes

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