I have a business card designed in InDesign, and need to create MANY of them with different people's info in each.. (I'm talking like 500+)
The info is being provided in an Excel spreadsheet with each entry in a separate cell/column. What is the best way to automate this process so I don't have to copy and paste each card?
You'll want to use Data Merge. Open the Data Merge panel by going to Window > Utilities > Data Merge. You'll need to save your Excel spreadsheet as a .csv (comma separated) file but this will allow you to generate a card for each user in the spreadsheet.