Thursday, February 28, 2008

IEEE Bibliography XSL Style Sheet for Word 2007

Please read the updates at the end of this post!

I spent about 4-5 hours this afternoon making an IEEE style bibliography XML / XSL file for Office 2007 for my thesis. That means you can use Word's built in reference tracker and IEEE style references! It looks good for journal and book references but I haven't tried anything else yet. I built it by modifying Word's built-in ISO 690 Numerical format. Also, don't blame me if it shreds your thesis... make a backup first! :)

Just unpack this file to:
C:\Program Files\Microsoft Office\Office12\Bibliography\Style\

Here are the references I used to get started:
Bibliography & Citations 1011
Word 2007 citations, should be simple, but... (solved)

If you have any interest in refining this further, or if you find any bugs / inconsistencies / areas for improvement, please let me know (or even better, fix it and send me the updated version).

Enjoy!

Update: There is another IEEE style sheet available on CodePlex from another developer with some additional formatting support. Good luck!

Update 2: Good news! Office 2007 SP3 now includes an IEEE XSL style sheet built-in! You can download Office 2007 SP3 here or use Windows update, and read the Office 2007 release notes here. Thanks to all of you who downloaded my version over the past few years, it's been fun!

54 comments:

Carson said...

Thanks! You totally made my day and saved me from having to figure this out, myself.

A couple of finer points you might consider for version 2:

1) The biblio references should have a hanging indentation, if they take more than one line.
2) Unlike a lot of other styles, authors in IEEE are usually listed as B. Farnsworth, as opposed to Farnsworth, B. Is it possible to disallow Word from reversing the first and last names?

Bradley Farnsworth said...

Carson- glad you found it helpful. I'll see what I can do about changing the author formatting.

Anonymous said...

You are a good man, you made my day too....

I hope you come up with a version 2 with the mentioned things fixed.

Oleg said...

Great work !

Several improvements for next version that can be VERY useful:
1) The Authors issue that already mentioned
2) Line spacing between different items
3) Alignment - the second line should start exactly under beginning of text at the first line and not under the number of item.
4) The text of items [10]-> should be left-aligned with the text of items [1]-[9]
5) There should be a point instead of comma after the list of authors.
6) The date (month and year) should be the last one in each item (now if number of pages are mentioned - this is the last one)
7) There is no need to add quotation marks for the name of article.

Hope those (or part of those) will be added to next version.

Thank you.

Anonymous said...

Hi!
Thank You alot! It si a very nobel from you to give it for free like this.
You ava me from hours of work!!
Great job!

Jess said...

Thanks!! Saved me a couple hours. Did not feel like scanning through lines of xml to change it. I'm forever greatful!

Javier said...

Very Good. How Can I identify an actualization of this file? .xsl

Anonymous said...

Bradley,

I have problems saving the file.
Could you please send it to juli4n.lin@gmail.com? Thank you.

Lyle Gordon said...

Hey,

I just noticed you made an IEEE xslt for Office 2007. I made one a little while ago (should have made a little site about it. Maybe we can combine our changes to fix problems.

I couldn't find your contact and I don't have webspace so shoot me an e-mail and I can send you my code if you want. (lgordon@gmail.com)

-Lyle

Erwin Ried said...

Great! just what I need for my own tesis.

Eu Fei said...

this is great! thanks alot!

Erwin Ried said...

bradley, how can I re-sort the references by first author lastname?

thanks!

Erwin Ried said...

I found how to sort the list, removing the <xsl:sort select="b:RefOrder" data-type="number"/> line, but "insertion number" keps the same :(

Hardjono said...

Bradley,

All I can say is wow! Thanks so much. This is one of those little things in life that appears unimportant but will in fact help thousands of people in their work. (Amazing that MSFT did not include IEEE in their default styles in Word-2007). Its not only academics that use the IEEE style, but folks writing standards docs (yes in the IEEE too).

Hope you will continue improving this style. Please add a Donations/PayPal button to your blog. I'm sure you'll get lots of people donating.

Thanks again.
[TH]

Anonymous said...

Thanks Bradley...This is GREAT!!

PK said...
This comment has been removed by the author.
Anonymous said...

Hi Bradley,

Thanks so much for sharing.. I quite needed clickable references, and I managed to do it, somewhat..
I edited your style so it adds html anchor and link to bibliography and citations, here is a diff patch

http://pastebin.com/f33e4964e

They will become clickable in Word, but not in a PDF export.
Then, you can use a VBA macro, to convert the 2007 doc to a Word 97 doc, where bibliography turns into static text, but the citations turn into clickable references, which is exportable to PDF - here is the macro:

http://pastebin.com/f6ba3f847

(the macro may need a reference to regex for VBscript, http://www.windowsdevcenter.com/pub/a/windows/excerpt/wdhks_1/index.html?page=4http://www.windowsdevcenter.com/pub/a/windows/excerpt/wdhks_1/index.html?page=4)

Sometimes word crashes in the middle of conversion, but if you ignore it, it can recover and show the recovered 97 doc..

Cheers..

Anonymous said...

This is fantastic. Microsoft should totally repackage this into their service pack or something. If they want more people to adopt Office 2007, they'll have to convince us geeks first!

Anonymous said...

Hi again,

Just made some updates to those "clickable" Bradley XSL and macro,

the XSL diff is here:
http://pastebin.com/f7cc18b23

the VB macro is here:
http://pastebin.com/f517b9c4d

It feels great doing work for Microsoft for free - just when to expect to see the results implemented by default :)

Cheers

Anonymous said...

You are a superstar! ** Thanks, just what I needed.

Anonymous said...

Thanks a million. You are a champion.

Silencio said...

Hi! Thank you very much!
I am working on my Thesis. I just applied your format, and it worked very well. I need the list ordered by Author's last name. Can you help me to identify the lines I need to change?? Thanks a lot ! God bless you!...

Pejman said...

thanks man,

You saved 5 hours of my time!
All the

Anastasia said...

You are wonderful! This is definitely what I needed! Just wondering how you italicize the Title.

Wesley Allen said...

FYI, A full-functioning IEEE Bibliography that gets regular updates and other Word Bibliography stuff can be found at the following site:
http://www.codeplex.com/bibliography/Release/ProjectReleases.aspx?ReleaseId=15365

Enjoy!

Hulk said...

Thanks so much

Anonymous said...

Thank you, you're the best!

BiBi said...

Thank you very much, I am now writing my Master Thesis and this have been really useful! Thanks a lot!

PhD Candidate said...

Wow It works great! Thank you so much!!!

Anonymous said...

downloaded and installed it. Great thanks!
Now, from office 2007 superscript endnotes to IEEE bracket endnotes: how to do it?

Anonymous said...

Thank you very much for helpful IEEE citation link!!! It saves me a lot of time. Thank you again!!!

Justin Gallagher said...

Hi. This is great, thanks so much for making it. Just one question, I don't want to use "Et al" in the bibliography, is there a way not to use it? Many thanks!

Bradley Farnsworth said...

The download link is now working again, my apologies to anyone who tried to download it and got a redirect. Enjoy!

Rj said...

Thanks a lot dude... 3 AM in the morning and I found this solution... You totally made my day and night :-)

Bradley Farnsworth said...

Glad I could help :)

Anonymous said...

Thanks dude .. I'm in EE at the University of Kentucky, I found this very helpful!

- Samir

Anonymous said...

just wanted to say thank you, looks perfect to me

Ahmed said...

Hey, dude thanks alot, it was such a help..

jlNiap said...

Your links definitively save me a lot of time, just spent some time to found the good google search words (xsl + ieee)... thx!

None said...

hi bradley,
u made my day.
I was working on this for last two days , reinventing the wheels, (result of poor googleing :)
good work man..keep it up !

Gantz said...

Is there an easy way to add page numbers for a reference?

Thanks for this style!

xxsumz said...

Thanks a bunch mate. This is a life saver for my Engineering Project.

Umeissmaeel said...

Thanks , I was done with all the revisions of my PhD thesis and thinking of either writing my own style file or convert into text and edit 120 references manually ..
you saved me a week of effort :)

Anonymous said...

Thanks a lot Brad your IEEE stuff rocks man!!

Jerry12 said...

Thanks a lot. It was really helpful.

chand said...

You are great my friend. I have to submit my thesis next morning and i have been fucked up by my supervisor, and you really saved my time alot. Thanx man.

Bradley and Metallica forever

Anonymous said...

I just spent a day and a half trying to mess around with word's ISO690Nmerical.xsl file to no avail, and I'm so happy that you posted this solution! This is fantastic!

Venkata Sudhir B said...

Hey Bradley Farnsworth,

I have no words dude.. on how to thank you.. grt work.. it helps me a lot.. It was able frame out exactly in IEEE format. once again grt work..

From,
Sudhir

Dinesh Wijekoon said...

Thank you very much. Its very useful

Christina said...

Thanks a lot!

Christina said...

Thanks a lot!

Richard Wu Prasojo said...

Dear Bradley,
Would you mind checking the download link? I would like to try the style. Thank you very much. Richard

Bradley Farnsworth said...

Richard- Thanks for catching the broken link. I will fix the link shortly and post again when it's ready.

Bradley Farnsworth said...

Good news! Office 2007 SP3 now includes an IEEE style sheet! You can download it here or use Windows update, and read the release notes here. I wonder if they looked at my version...