Hi everyone, first post here. Been searching around for some tips but can't really find exactly what I'm looking for so wanted to see if anyone had any advice. It's for a print magazine, created in Indesign CS4.
I'm a novice designer but edit the publication and do some of the design side myself, all just self-taught through Indesign guides. One fairly arduous task is creating the monthly gig guide. It's a listing section by day, with BANDS, Venue, City as the basic format, currently in a four column text boxes, linked to overflow onto the following pages, and wrapping around pictures and other graphics.
I've basically been formatting manually, copying and pasting from our online listings, and then applying styles to each line, which is a ridiculously long-winded way of doing it I'm sure.
I've been trying to find a decent way of doing it in excel (which I do to a degree) by putting the bands, venues and locations in different columns. However, copying and pasting into a text box ends up copying hidden columns from the excel file and also copies over lots of spaces into the text which I end up having to delete manually. Importing as an actual table, I can't work out how to make it flow as if it was part of a four column text box.
The closest I have come to what I'm after is import from excel and in import options setting import as unformatted tabbed text. This is the neatest layout and keeps it to the text frame presets, but loses the formatting such as bold text.
Is there a way of importing as formatted tabbed text or setting styles for each of the three 'tabs'?
I'm sure there's probably a very obvious way of achieving what I want, but as I say, I'm a novice with ID so any suggestions very welcome!
.
