Copy link to clipboard
Copied
I'm hoping there is a shortcut out there that will save me some time. A couple times a year I created a booklet that lists a bunch of events (name of event, time, place, description) as three columns per page, with each event formatted the same way (name is bold an red, time is italicized, etc). Normally I am given the info for everything in a word document and I copy and paste it into indesign then change the paragraph style for each part of the events, but I have to do that part manually.
Is there a way to import from an excel spreadsheet so that it imports row by row but the content from each column is formatted to a specified paragraph style? That way all I have to do is set the styles then import the spread sheet?
So no, you would need to be working a table.
But your formatting is very consistent, and you can use a combo of the two earlier answers to streamline this workflow.
Copy link to clipboard
Copied
There are any number of ways of doing this but it would help to see a screen shot of what you want to accomplish.
It may well be that the Word file with a combination of styles based on others as well as having a next style applied may be the better solution.
Copy link to clipboard
Copied
Here is a screenshot of what the booklet looks like when completed:
BookletExample.png - Google Drive
Here is a screenshot of the word document I'm given:
WordDoc_Example.png - Google Drive
BarbBinder​ I have not worked with table and cell styles before (I'm pretty new to InDesign) but would this work if my list of events in indesign is not displayed as a table? [example above]
Thanks everyone for your quick responses and help!
Copy link to clipboard
Copied
So no, you would need to be working a table.
But your formatting is very consistent, and you can use a combo of the two earlier answers to streamline this workflow.
Copy link to clipboard
Copied
Have you worked with table and cell styles?
You can set up a table style that will control the table-level settings, and then nest cell styles into the table style for the left column, the right column and the middle column(s). You can nest paragraph styles into the cell styles to format the text. Set up correctly, one can format an entire table with a single click. (Or you can assign the table style on import.)
For details on this workflow, see: Table and cell styles in InDesign
Copy link to clipboard
Copied
As well as a screen shot of what you would want to accomplish, a screen shot in Word of what you are given with the spaces, tabs and returns showing.
That said, I don't know why GREP couldn't be used to apply paragraph and character styles automatically, or Bob's next style suggestion, etc...but without screen shots that is hard to be sure of.