Export Skyrim Strings to Excel ?

Post » Sat Nov 17, 2012 4:52 am

Hello)

Do there are a way to export Skyrim Strings to Excel ? (with column)
Which tools i have to use ? or any existing mod that offer all strings/editor IDs to Excel ?

Thanks
User avatar
Sammie LM
 
Posts: 3424
Joined: Thu Nov 30, 2006 1:59 pm

Post » Sat Nov 17, 2012 4:12 am

Not really sure what you are trying to do but the Creation Kit will allow you to export the Dialogue strings and they look in a format suitable for import into Excel

e.g. a small sample from the 19MB export it generated (Notice the header line one is 'tab' separated columns)
Spoiler
LINE ID SPEAKER NPCID GetIsID RACE VOICE TYPE QUEST BRANCH CATEGORY TYPE SUBTYPE TOPIC TOPICINFO RESPONSE INDEX FILENAME FULL PATH FILE FOUND MODIFIED SINCE FILE CREATION TOPIC TEXT PROMPT RESPONSE TEXT EMOTION POSTPROCESS SCRIPT NOTESFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfHelpBranch Topic PlayerDialogue Custom TG00BrynjolfHelpBranchTopic FormID 00020ACD 2 TG00_TG00BrynjolfHelpBranc_00020ACD_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfHelpBranc_00020ACD_2.xwm File Not Found How am I supposed to do all of this? You have the ring. All you have to do is pick Brand-Shei's pocket and plant it there. Disgust 25 Brand-Shei = "Brand-Shay"FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfHelpBranch Topic PlayerDialogue Custom TG00BrynjolfHelpBranchTopic FormID 0005169C 1 TG00_TG00BrynjolfHelpBranc_0005169C_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfHelpBranc_0005169C_1.xwm File Not Found How am I supposed to do all of this? Do you want me to hold your hand as well? Disgust 50 very annoyedFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfHelpBranch Topic PlayerDialogue Custom TG00BrynjolfHelpBranchTopic FormID 0005169C 2 TG00_TG00BrynjolfHelpBranc_0005169C_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfHelpBranc_0005169C_2.xwm File Not Found How am I supposed to do all of this? You're going to have to sneak over to Madesi's stall and use your lockpick on the strongbox. Disgust 25FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfHelpBranch Topic PlayerDialogue Custom TG00BrynjolfHelpBranchTopic FormID 0005169C 3 TG00_TG00BrynjolfHelpBranc_0005169C_3 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfHelpBranc_0005169C_3.xwm File Not Found How am I supposed to do all of this? Then when you have the ring, you pickpocket Brand-Shei and leave it behind. Disgust 25 Brand-Shei = "Brand-Shay"FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfLostRingBranch Topic PlayerDialogue Custom TG00BrynjolfLostRingBranchTopic FormID 0008DC20 1 TG00_TG00BrynjolfLostRingB_0008DC20_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfLostRingB_0008DC20_2.xwm File Not Found I lost Madesi's ring. Lost it? Well, at least you showed signs of initiative by telling me. Disgust 15 "Lost it?" is annoyed, the rest is like "oh well"FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfLostRingBranch Topic PlayerDialogue Custom TG00BrynjolfLostRingBranchTopic FormID 0008DC20 2 TG00_TG00BrynjolfLostRingB_0008DC20_3 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfLostRingB_0008DC20_3.xwm File Not Found I lost Madesi's ring. I guess I shouldn't be surprised with the way things are going around here. Disgust 25 "it figures" attitudeFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch02a FormID 000E66D8 1 TG00_TG00BrynjolfIntroBran_000E66D8_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000E66D8_1.xwm File Not Found What do you mean? Look how you sniffed out my little scheme at the North Gate. You knew it was a shakedown and you called him on it. That's what I'm talking about. Happy 25 somewhat congratulatoryFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfWalkAwayTopic FormID 000C99E8 1 TG00_TG00BrynjolfWalkAwayT_000C99E8_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfWalkAwayT_000C99E8_1.xwm File Not Found I can take a hint, lad. You want to make some coin, come find me. Disgust 50 you've just been ignoredFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfWalkAwayTopic FormID 000C99E9 1 TG00_TG00BrynjolfWalkAwayT_000C99E9_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfWalkAwayT_000C99E9_1.xwm File Not Found I can take a hint, lass. You want to make some coin, come find me. Disgust 25 you've just been ignoredFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch03a FormID 000C44A2 1 TG00_TG00BrynjolfIntroBran_000C44A2_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000C44A2_1.xwm File Not Found You seem to be well acquainted with wealth. Wealth is my business. Help me out and I can add to yours. Would you like a taste? Happy 25 dangling the baitFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroMQ203C1 FormID 00097FCC 1 TG00_TG00BrynjolfIntroMQ20_00097FCC_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroMQ20_00097FCC_1.xwm File Not Found Let me find him first. Dragons are bad for business. (Persuade) Aye, you've got a point there. Happy 25 impressed with the Player's intuitionFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroMQ203C1 FormID 00097FCD 1 TG00_TG00BrynjolfIntroMQ20_00097FCD_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroMQ20_00097FCD_1.xwm File Not Found Let me find him first. Dragons are bad for business. (Persuade) Passing on a golden opportunity is worse. Disgust 25FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroMQ203D1 FormID 00097FCB 1 TG00_TG00BrynjolfIntroMQ20_00097FCB_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroMQ20_00097FCB_1.xwm File Not Found Your guy's hiding out in the Ratway Warrens and paying us good coin for nobody to know about it. Well, until now that is. Disgust 50FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroMQ203D1 FormID 00097FCB 2 TG00_TG00BrynjolfIntroMQ20_00097FCB_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroMQ20_00097FCB_2.xwm File Not Found Tell you what. Go ahead and deal with your business for now. When you're done, find me and we'll deal with mine. Happy 25FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch09 FormID 00038AB3 1 TG00_TG00BrynjolfIntroBran_00038AB3_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_00038AB3_1.xwm File Not Found Why plant the ring on Brand-Shei? There's someone that wants to see him put out of business permanently. That's all you need to know. Disgust 25 all businessFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch09 FormID 00038AB3 2 TG00_TG00BrynjolfIntroBran_00038AB3_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_00038AB3_2.xwm File Not Found Why plant the ring on Brand-Shei? Now, you tell me when you're ready and we'll get started. Neutral 50FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch09 FormID 00020BD9 1 TG00_TG00BrynjolfIntroBran_00020BD9_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_00020BD9_1.xwm File Not Found Why plant the ring on Brand-Shei? There's someone that wants to see him put out of business permanently. That's all you need to know. Disgust 25 All businessFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch09 FormID 00020BD9 2 TG00_TG00BrynjolfIntroBran_00020BD9_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_00020BD9_2.xwm File Not Found Why plant the ring on Brand-Shei? I'll be out in the market all day, from eight in the morning until eight in the evening. Neutral 50FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch09 FormID 00020BD9 3 TG00_TG00BrynjolfIntroBran_00020BD9_3 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_00020BD9_3.xwm File Not Found Why plant the ring on Brand-Shei? Meet me then if you've still got the stomach for it. Happy 10 with a hint of mysteryFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranchTopic FormID 000352DF 1 TG00_TG00BrynjolfIntroBran_000352DF_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352DF_1.xwm File Not Found Glad to see you finally came to to your senses. Ready to make some coin? Disgust 25FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranchTopic FormID 0004FCDA 1 TG00_TG00BrynjolfIntroBran_0004FCDA_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_0004FCDA_1.xwm File Not Found Never done an honest day's work in your life for all that coin you're carrying, eh lad? Happy 25 scolding yet jovialFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranchTopic FormID 000352E0 1 TG00_TG00BrynjolfIntroBran_000352E0_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352E0_1.xwm File Not Found Running a little light in the pockets, lad? Happy 25 sort of with a wink and a nodFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranchTopic FormID 000352E1 1 TG00_TG00BrynjolfIntroBran_000352E1_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352E1_1.xwm File Not Found Never done an honest day's work in your life for all that coin you're carrying, eh lass? Happy 25 scolding yet jovialFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranchTopic FormID 0004FCDB 1 TG00_TG00BrynjolfIntroBran_0004FCDB_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_0004FCDB_1.xwm File Not Found Running a little light in the pockets, lass? Happy 25 sort of with a wink and a nodFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch01 FormID 000352DB 1 TG00_TG00BrynjolfIntroBran_000352DB_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352DB_1.xwm File Not Found I'm sorry, what? I'm saying you've got the coin but you didn't earn a septim of it honestly. I can tell. Happy 25 with a hint of mysteryFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch01 FormID 0004FCDC 1 TG00_TG00BrynjolfIntroBran_0004FCDC_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_0004FCDC_1.xwm File Not Found I'm sorry, what? Your pockets... they're a little low on coin. I can tell. Happy 25 with a hint of mysteryFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch02 FormID 000352E2 1 TG00_TG00BrynjolfIntroBran_000352E2_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352E2_1.xwm File Not Found How could you possibly know that? It's all about sizing up your mark, lad. Happy 50 matter of factlyFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch02 FormID 000352E2 2 TG00_TG00BrynjolfIntroBran_000352E2_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352E2_2.xwm File Not Found How could you possibly know that? The way they walk, what they're wearing. It's a dead giveaway. Happy 25 matter of factlyFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch02 FormID 00020ADA 1 TG00_TG00BrynjolfIntroBran_00020ADA_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_00020ADA_1.xwm File Not Found How could you possibly know that? It's all about sizing up your mark, lass. Happy 50 matter of factlyFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch02 FormID 00020ADA 2 TG00_TG00BrynjolfIntroBran_00020ADA_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_00020ADA_2.xwm File Not Found How could you possibly know that? The way they walk, what they're wearing. It's a dead giveaway. Happy 25 matter of factlyFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch03 FormID 000352D8 1 TG00_TG00BrynjolfIntroBran_000352D8_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352D8_1.xwm File Not Found My wealth is none of your business. Oh, but that's where you're wrong, lad. Wealth is my business. Surprise 25 mock surprise/accentuate the "is"FFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch03 FormID 000352D8 2 TG00_TG00BrynjolfIntroBran_000352D8_2 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352D8_2.xwm File Not Found My wealth is none of your business. Maybe you'd like a taste? Happy 25 dangling the baitFFFFFFFF -- -- GetIsID == 1 -- MaleUniqueBrynjolf TG00 TG00BrynjolfIntroBranch Topic PlayerDialogue Custom TG00BrynjolfIntroBranch03 FormID 000352D9 1 TG00_TG00BrynjolfIntroBran_000352D9_1 Data\Sound\Voice\Skyrim.esm\MaleUniqueBrynjolf\TG00_TG00BrynjolfIntroBran_000352D9_1.xwm File Not Found My wealth is none of your business. Oh, but that's where you're wrong, lass. Wealth is my business. Surprise 25 mock surprise/accentuate the "is"

I couldn't see any import options so not sure how useful it will be. Hope it helps.

Just out of interest, what are you trying to do?
User avatar
Lizzie
 
Posts: 3476
Joined: Sun Nov 19, 2006 5:51 am

Post » Fri Nov 16, 2012 8:13 pm

Oh i feel so sorry to not replying this thread i am sorry again.
I am planning to create a mod to fix some french strings. and i need editorID with text/dialogue.
User avatar
Enny Labinjo
 
Posts: 3480
Joined: Tue Aug 01, 2006 3:04 pm


Return to V - Skyrim