I am designing a publication for a small film festival. The publication will include all information related to the 50 or so films the festival will play. For each film, I want to merge in the English-language title, original language title, run time, country of origin, showtimes, synopsis and other fields.
I have all the records in an Excel spreadsheet and would like to merge the info into InDesign so that two films appear per page. Is there a way to do this so I don't have to copy/paste??
Thank you for your help!
Without seeing the file you are merging into it's hard to give a definitive answer. If all the data is to be merged, or all the non-merged text remains the same from film to film, then it's no problem. If you have a multi-page file with varying text on the pages, the only way to get two films per page would be to put two films per record in the data file.
You're probably thinking of InDesign's Data Merge function. Here are two links that may help you decide if this is what you're thinking of doing:
If this is what you're thinking of, you'll need the design laid out in InDesign and a CSV file. The above YouTube video provides a decent instructions on this.
When you save your Excel file as a CSV file, I recommend that you also save it as a XLS (not XLSX) file too. The CSV file will not save any formatting (like column widths and cell formatting), which makes it difficult to read the cell content whenever I have to use the file often.
Hope this helps. Cheers!