This Is How I Organized Large Interview Transcript Files with Hashtags

My new book Skateboarding Is Not A Fashion took eight years to finish, more than double the time that went into its predecessor. It was the most challenging project I ever worked on, mainly because of its size. The final book clocks in at 632 pages and a bit over 130,000 words – and that’s just the finished product.

Behind the scenes, we conducted close to 100 interviews with skateboard personalities from several decades of skate history. Some of these interviews – including talks with iconic skateboarders such as Lance Mountain, Tony Alva, Christian Hosoi, Steve Caballero, Steve Olson, Brad Bowman, Steve Rocco, and Mike Vallely – extended over the course of several hours.

Interviewing Todd Huber at SKATELAB skatepark and museum for Skateboarding Is Not a Fashion.

As a result, transcribing these interviews created Word files that ran anywhere between 5,000 and 15,000 words in length. And needless to say, these first-hand stories and eyewitness accounts – including tons of previously untold stories – were the backbone for our history of skateboard fashion. They were our storytelling gold and I was grateful for every single skate legend we had a chance to sit down with.

“We need to organize all this stuff”

But as the interview transcripts folder on my iMac grew in size, one major fear began gnawing at me: What if I collected this golden quote that would be perfect for a chapter in the book, this magic storytelling moment that ties it all together – but forgot that I even had it because I lost track of the transcripts on my hard drive?

Considering that this project would draw out over eight years, the fear was quite real. Because even if you have Truman Capote-level word memory, the perfect quote may not readily spring to mind when you sit down three years after recording your interview to put a finished book chapter together.

I needed some kind of technique to organize these massive Word files and make them searchable by keywords from a desktop level. That’s when I came up with using #hashtags to do the trick.

Here’s how it works:

Step 1

We had already planned a rough chapter structure for the final book, so I knew what kind of topics and angles we would talk about. With this in mind, I inserted search terms with hashtags into my interview transcripts whenever I thought a quote would work for a certain chapter or topic.

Sometimes I used multiple hashtags to mark a juicy quote. Some of the hashtags used for the book include #alva, #1970s, #baggypants, #surfstyle, #hairstyles and many more.

Step 2

Now, when the time came to write a book chapter – for example the style icon profile on Tony Alva – all I needed was a desktop search on my Apple Macintosh for the search term and the hashtag (in this case #alva) in the folder holding my interview transcripts.

This desktop search revealed all the text files that contain the hashtag.

Step 3

In the next step, I could open these text files and perform a keyword search in Microsoft Word by pressing Command + F.

This would quickly show all quotes in the Word doc marked with the hashtag.

That was it. I had successfully transformed a folder holding hundreds of thousands of words worth of sprawling interview transcripts into an organized, fully searchable repository of original quotes.

This technique proved really helpful in writing Skateboarding Is Not A Fashion and I have used it on other large-scale projects since. It made me less afraid of missing that golden quote and leaving it unused in a folder.

The one problem it didn’t solve – another consequence of working on this thing for eight years – was using the same quote multiple times in several chapters. But that’s what editors are for, right?

Skateboarding Is Not A Fashion is available now for pre-order on Amazon and will release in February 2018.