Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

csv files integrating indesign

Forum home » Delegate support and help forum » Microsoft Excel Training and help » CSV files integrating to Indesign

CSV files integrating to Indesign

ResolvedVersion 365

Denise has attended:
Excel Intermediate course

CSV files integrating to Indesign

How to set up files to add copy to indesign documents

RE: CSV files integrating to Indesign

Hi Denise,

Thank you for the forum question.

Integrating CSV files into Adobe InDesign is a powerful way to automate the layout of documents like catalogs, business cards, directories, or any content that follows a structured format. This process is typically done using Data Merge in InDesign. Here's how to set up your files and workflow:

Step 1: Prepare Your CSV File
Create a spreadsheet in Excel or Google Sheets.
First row = field names (e.g., FirstName, LastName, Email, ImagePath).
Each row = one record of data.

If you're using images, include the full path or relative path to each image in a column.
Save the file as CSV (Comma Separated Values).

Step 2: Set Up Your InDesign Document
Open your InDesign document or create a new one.
Go to Window > Utilities > Data Merge to open the Data Merge panel.
In the panel menu, choose Select Data Source and load your CSV file.
InDesign will read the headers and list them as fields in the panel.

Step 3: Insert Placeholders
Create a text frame where you want the data to appear.
Click a field name in the Data Merge panel to insert it (e.g., <<FirstName>>).
For images:
Create an empty graphic frame.
Click the image field name to insert it into the frame.

Step 4: Preview and Merge
Check the Preview box in the Data Merge panel to see how your data looks.
Click Create Merged Document to generate a new InDesign file with all records.
Export or print as needed.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 20 Jun 2025: Automatically marked as resolved.

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.