How do you export dialogue into an Excel spreadsheet?

Post » Wed Jun 20, 2012 12:28 am

So, I know that the developers export their dialogue into an Excel spreadsheet for their voice actors, and it's a great system and is really helpful. However, I haven't done this since I made Project Genesis like two years ago, and I cannot for the life of me figure out how I did it.

Does anyone know how to export dialogue into an Excel file? I can click 'Export Dialogue' but it wants to export every single line of dialogue, from both my mod, and Skyrim.esm. And it wants to export it into a txt document.

Or I can click 'Dialogue' in my NPC's actor window, and export just his into a txt sheet. How do I export just his into an Excel spreadsheet? I know it can be done. I have done it in previous games. I know they still do it because in the Behind The Scenes video they're reading from a printed Excel layout.

Thanks for any help!
Alexander J. Velicky
User avatar
ZANEY82
 
Posts: 3314
Joined: Mon Dec 18, 2006 3:10 am

Post » Tue Jun 19, 2012 9:53 pm

Does the export to text file turn them into Comma Separated Value format? If so, you can usually just paste the text into the spreadsheet and it should pop up a dialog asking you what character separates cells, defines text, and so on...
User avatar
christelle047
 
Posts: 3407
Joined: Mon Apr 09, 2007 12:50 pm

Post » Wed Jun 20, 2012 2:55 am

I've tested this with Google Docs and it works. Just import the txt File.
The Lines in the File are tab seperated, Excel can handle this.
User avatar
Nymph
 
Posts: 3487
Joined: Thu Sep 21, 2006 1:17 pm

Post » Wed Jun 20, 2012 7:40 am

Derp. Import the text file, I knew it was simple... :facepalm:

Haha, thanks guys! That was all I was missing. :P

AJV

EDIT: Though once I import, what format should I save it as so people can open it with Excel, or just any spreadsheet viewer?
User avatar
Hayley O'Gara
 
Posts: 3465
Joined: Wed Nov 22, 2006 2:53 am

Post » Wed Jun 20, 2012 11:13 am

I think .xls is common. But I suggest to use Google Docs and share the spreadsheet with them.
User avatar
FABIAN RUIZ
 
Posts: 3495
Joined: Mon Oct 15, 2007 11:13 am

Post » Tue Jun 19, 2012 8:02 pm

I think .xls is common. But I suggest to use Google Docs and share the spreadsheet with them.
I would but that would require setting all that up, and I'm sending each spreadsheet to just one person.

.xls appears to work across several platforms, I'll try that.

Thanks for all your help! :D
User avatar
Louise Lowe
 
Posts: 3262
Joined: Fri Jul 28, 2006 9:08 am


Return to V - Skyrim