- Maps & Floorplans
- Libraries A-Z
- Ellis Library (main)
- Engineering Library
- Geological Sciences
- Journalism Library
- Law Library
- Mathematical Sciences
- MU Digital Collections
- Veterinary Medical
- More Libraries...
- Instructional Services
- Course Reserves
- Course Guides
- Schedule a Library Class
- Class Assessment Forms
- Recordings & Tutorials
- Research & Writing Help
- More class resources
- Places to Study
- Borrow, Request & Renew
- Call Numbers
- Computers, Printers, Scanners & Software
- Digital Media Lab
- Equipment Lending: Laptops, cameras, etc.
- Subject Librarians
- Writing Tutors
- More In the Library...
- Undergraduate Students
- Graduate Students
- Faculty & Staff
- Researcher Support
- Distance Learners
- International Students
- More Services for...
- View my MU Libraries Account (login & click on My Library Account)
- View my MOBIUS Checkouts
- Renew my Books (login & click on My Loans)
- Place a Hold on a Book
- Request Books from Depository
- View my ILL@MU Account
- Set Up Alerts in Databases
- More Account Information...
EndNote for Windows
- Classes and Help
- Get EndNote
- Configure EndNote -- IMPORTANT
- Ebsco Databases (Articles tab search)
- Ovid Databases (Medline)
- Google Scholar
- Web of Science
- Add citations by hand
- Direct Searching Within EndNote
- Have EndNote download PDFs
- Endnote did not download PDF
- Manually attach PDFs
- Import PDFs (if they have DOI numbers)
- Get citation for PDF in EndNote
- Read and annotate PDFs in EndNote
- Search your EndNote Library
- Back up your library
- Update Your References
- Know Where Everything is Saved
- Create Groups
- Edit and view reference records
- Delete Duplicates
- Citation Style -change, get new
- Corporate Authors
- Get additional styles from web
- Journal Abbreviation
- Edit a citation
- Format your bibliography
- Stand Alone Bibliography
- Convert to Plain Text (break the Word/EndNote link)
- Extracting EndNote Citations (travelling libraries)
- Export Sort by Year into Word
Put Bibliography into Excel
- Sync with EndNote Web
- Sharing with EndNote Web
- Import / Export citations to / from another Citation Manager
- Icon translator for Windows Endnote X7, 8, Mac
- EndNote Class
- EndNote for Mac pages
- Get citations from a document into EndNote
On the off chance you want to put an EndNote bibliography into Excel, McGill University has created an nifty output style for Excel.
How can I export from my Endnote library to an Excel Spreadsheet?
If you are using Mendeley or Zotero, you can import your citations into EndNote and use EndNote to export the citations to Excel.
- << Previous: Export Sort by Year into Word
- Next: EndNote Web >>
- Last Updated: Jul 14, 2023 8:12 AM
- URL: https://libraryguides.missouri.edu/endnote
- More Referencing guides Blog Automated transliteration Relevant bibliographies by topics
- Automated transliteration
- Relevant bibliographies by topics
- Referencing guides
Academic literature on the topic 'MS Excel'
Create a spot-on reference in apa, mla, chicago, harvard, and other styles.
Select a source type:
- Journal article
- Video (online)
- All types...
- Archival document
- Book chapter
- Complete reference
- Conference paper
- Copyright certificate
- Dictionary entry
- Dissertation / Thesis
- Encyclopedia article
- Extended abstract of dissertation
- Newspaper article
- Press release
- Religious text
- Social media post
Consult the lists of relevant articles, books, theses, conference reports, and other scholarly sources on the topic 'MS Excel.'
Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.
You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.
- Journal articles
- Dissertations / Theses
- Book chapters
- Conference papers
Book chapters on the topic "MS Excel":
Hossain, Eklas. "MS Excel VBA." In Excel Crash Course for Engineers , 143–67. Cham: Springer International Publishing, 2021. http://dx.doi.org/10.1007/978-3-030-71036-1_4.
Jaros-Sturhahn, Anke, Konrad Schachtner, Edward Bernroider, Michael Burger, Robert Krimmer, and Nikolai Neumayer. "Tabellenkalkulation mit Excel." In Business Computing mit MS-Office 2003 und Internet , 205–76. Berlin, Heidelberg: Springer Berlin Heidelberg, 2004. http://dx.doi.org/10.1007/978-3-642-17014-0_6.
Hossain, Eklas. "MS Excel Functions and Formulae." In Excel Crash Course for Engineers , 117–41. Cham: Springer International Publishing, 2021. http://dx.doi.org/10.1007/978-3-030-71036-1_3.
Hossain, Eklas. "MS Excel in Engineering Data." In Excel Crash Course for Engineers , 169–242. Cham: Springer International Publishing, 2021. http://dx.doi.org/10.1007/978-3-030-71036-1_5.
Peters, Dieter, and Gertrud Vogel. "Funktionenverzeichnis Die Tabellenfunktionen von MS-EXCEL." In Programmierleitfaden Microsoft EXCEL , 85–105. Wiesbaden: Vieweg+Teubner Verlag, 1990. http://dx.doi.org/10.1007/978-3-322-86162-7_3.
Kellner, Florian, and Christian Brabänder. "Datenbank-Anbindung am Beispiel von MS Access." In VBA mit Excel , 125–37. Berlin, Heidelberg: Springer Berlin Heidelberg, 2019. http://dx.doi.org/10.1007/978-3-662-59740-8_8.
Mishra, Pradeep, R. B. Singh, G. K. Vani, G. F. Ahmed, and Supriya. "Overview of MS Excel, SPSS, Minitab, and R." In Essentials of Statistics in Agricultural Sciences , 333–434. Includes bibliographical references and index.: Apple Academic Press, 2019. http://dx.doi.org/10.1201/9780429425769-6.
Musilek, Michal, Stepan Hubalovsky, and Marie Hubalovska. "Mathematical Modeling and Computer Simulation of Simple Permutation Brainteaser in MS Excel." In Lecture Notes in Electrical Engineering , 175–81. Cham: Springer International Publishing, 2017. http://dx.doi.org/10.1007/978-3-319-53934-8_21.
Man, Pascal P., and Jacques Fraissard. "Determination of Silicon Coordination Spheres in SAPO-37 Molecular Sieve with MS-Excel." In Acidity and Basicity of Solids , 391–402. Dordrecht: Springer Netherlands, 1994. http://dx.doi.org/10.1007/978-94-011-0986-4_18.
Sana, Ahmad. "Enhancing Water Resources and Coastal Engineering Curricula Using Visual Basic Programs in MS-Excel." In InCIEC 2013 , 323–30. Singapore: Springer Singapore, 2014. http://dx.doi.org/10.1007/978-981-4585-02-6_28.
Conference papers on the topic "MS Excel":
Arifin, Borhannuddin, Hanim Ismail, and Umiatun P. Yeop. "The mole concept using MS Excel." In 2012 IEEE Symposium on Computer Applications and Industrial Electronics (ISCAIE) . IEEE, 2012. http://dx.doi.org/10.1109/iscaie.2012.6482113.
Arifin, Borhannuddin, and Umiatun P. Yeop. "Using MS Excel to Learn general Chemistry." In 2012 IEEE Symposium on Business, Engineering and Industrial Applications (ISBEIA) . IEEE, 2012. http://dx.doi.org/10.1109/isbeia.2012.6422994.
Tarasova, Irina Olegovna. "Razrabotka programmy distantsionnogo obucheniia po MS Excel." In International Research-to-practice Conference . TSNS Interaktiv Plus, 2020. http://dx.doi.org/10.21661/r-469872.
Bhatti, M. Asghar. "Retaining Wall Design Optimization with MS Excel Solver." In 17th Analysis and Computation Specialty Conferenc at Structures 2006 . Reston, VA: American Society of Civil Engineers, 2006. http://dx.doi.org/10.1061/40878(202)34.
Kuneva, Velika, Marian Milev, and Margarita Gocheva. "Modeling the transportation assesment with MS excel solver." In THERMOPHYSICAL BASIS OF ENERGY TECHNOLOGIES (TBET 2020) . AIP Publishing, 2021. http://dx.doi.org/10.1063/5.0042520.
Alsaadi, Husam Ibrahiem, Maad Kamal Al-Anni, Rafah M. Almuttairi, Oguz Bayat, and Osman Nuri Ucan. "Text steganography in font color of MS excel sheet." In DATA '18: International Conference on Data Science, E-learning and Information Systems 2018 . New York, NY, USA: ACM, 2018. http://dx.doi.org/10.1145/3279996.3280006.
Arifin, Borhannuddin. "GChem: Learning basic concepts in chemistry using MS Excel VBA." In 2012 IEEE Business Engineering and Industrial Applications Colloquium (BEIAC) . IEEE, 2012. http://dx.doi.org/10.1109/beiac.2012.6226105.
Hrehová, Stella, and Alena Vagaská. "ANALYSIS OF MS EXCEL AS TOOL FOR PROCESSING LARGE DATA." In 11th annual International Conference of Education, Research and Innovation . IATED, 2018. http://dx.doi.org/10.21125/iceri.2018.2660.
Pastor, Karel, Květoslav Bártek, and David Nocar. "CHESS CAN ENCOURAGE INTEREST IN MS EXCEL AND VICE VERSA." In 12th annual International Conference of Education, Research and Innovation . IATED, 2019. http://dx.doi.org/10.21125/iceri.2019.1799.
Balakin, Aleksey, Natal'ya Balakina, and M. Mezina. "USING MS EXCEL VARIABLES IN AUTODESK INVENTOR WHEN DESIGNING PRODUCTS OF VARYING COMPLEXITY." In CAD/EDA/SIMULATION IN MODERN ELECTRONICS 2019 . Bryansk State Technical University, 2019. http://dx.doi.org/10.30987/conferencearticle_5e02820f85f118.90343643.
Reports on the topic "MS Excel":
Qi, Yan, Ryan Fries, Shambhu Saran Baral, and Pranesh Biswas. Evaluating the Costs and Benefits of Snow Fences in Illinois: Phase 2 . Illinois Center for Transportation, November 2020. http://dx.doi.org/10.36501/0197-9191/20-020.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Create Custom Bibliography Styles
- 10 contributors
Create a custom bibliography style in Word by learning the steps (and XML code) you need to construct a simple custom style. Also, learn to make a more complex style file. Before we start, there is some information that you need to know:
The bibliography sources you create are all listed in the following local file: %AppData%\Microsoft\Bibliography\Sources.xml.
The Sources.xml file won't exist until you create your first bibliography source in Word. All bibliography styles are stored in the user's profile here: %AppData%\Microsoft\Bibliography\Style.
Building a basic bibliography style
First, create a basic bibliography style that the custom style will follow.
Set up the bibliography style
To create a bibliography style, we will create an XML style sheet; that is, an .xsl file called MyBookStyle.xsl, using your favorite XML editor. Notepad will do fine. As the name suggests, our example is going to be a style for a "book" source type.
At the top of the file, add the following code:
As the comments indicate, Word uses HTML to represent a bibliography or citation within a document. Most of the preceding XML code is just preparation for the more interesting parts of the style. For example, you can give your style a version number to track the changes you make, as shown in the following example.
More importantly, you can give your style a name. Add this tag: <xsl:when test="b:StyleNameLocalized">; and then give your style a name, in the language of your choice, by using the following code.
This section contains the locale name of your style. In the case of our example file, we want our custom bibliography style name, "Simple Book Style," to appear in the Style drop-down list on the References tab. To do so, add the following XML code to specify that the style name be in the English locale (Lcid determines the language).
Your style will now appear under its own name in the Bibliography Style dropdown list-box in the application.
Now, examine the style details. Each source type in Word (for example, book, film, article in a periodical, and so forth) has a built-in list of fields that you can use for the bibliography. To see all the fields available for a given source type, on the References tab, choose Manage Sources , and then in the Source Manager dialog box, choose New to open the Create Source dialog box. Then select Show All Bibliography Fields .
A book source type has the following fields available:
Number of Volumes
In the code, you can specify the fields that are important for your bibliography style. Even when Show All Bibliography Fields is cleared, these fields will appear and have a red asterisk next to them. For our book example, I want to ensure that the author, title, year, city, and publisher are entered, so I want a red asterisk to appear next to these fields to alert the user that these are recommended fields that should be filled out.
The text in the <xsl:text> tags are references to the Sources.xml file. These references pull out the data that will populate each of the fields. Examine Sources.xml in \Microsoft\Bibliography\Sources.xml) to get a better idea about how these references match up to what is in the XML file.
Design the layout
Output for bibliographies and citations is represented in a Word document as HTML, so to define how our custom bibliography and citation styles should look in Word, we'll have to add some HTML to our style sheet.
Suppose you want to format each entry in your bibliography in this manner:
Last Name, First Name. (Year). Title. City: Publisher
The HTML required to do this would be embedded in your style sheet as follows.
When you reference a book source in your Word document, Word needs to access this HTML so that it can use the custom style to display the source, so you'll have to add code to your custom style sheet to enable Word to do this.
In a similar fashion, you'll need to do the same thing for the citation output. Follow the pattern (Author, Year) for a single citation in the document.
Close up the file with the following lines.
Save the file as MyBookStyle.XSL and drop it into the Styles directory (\Microsoft\Bibliography\Style). Restart Word, and your style is now under the style dropdown list. You can start using your new style.
Create a complex style
One of the issues that complicate bibliography styles is that they often need to have a significant amount of conditional logic. For example, if the date is specified, you need to show the date, whereas if the date is not specified, you may need to use an abbreviation to indicate that there is no date for that source.
For a more specific example, in the APA style, if a date is not specified for a website source, the abbreviation "n.d." is used to denote no date, and the style should do this automatically. Here's an example:
APA website source with no date entered: Kwan, Y. (n.d.). Retrieved from https://www.microsoft.com APA website source with date entered: Kwan, Y. (2006, Jan 18). Retrieved from https://www.microsoft.com
As you can see, what is displayed is dependent upon on the data entered.
The output of virtually every style needs to change depending on whether you have a "Corporate Author" or a "Normal Author." You'll see how to use one of the most common rules for implementing such logic into your style, allowing you to display a corporate author if the corporate author is specified, and a normal author if the corporate author is not specified.
To display a corporate author only if appropriate, use the following procedure.
To display a corporate author
Add a variable to count the number of corporate authors in the citation section of the code.
Display the corporate author in the citation if the corporate author is filled in. Display the normal author in the citation if the corporate author is not filled in.
Add a variable to count the number of corporate authors in the bibliography section of the code.
Display the corporate author in the bibliography if the corporate author is filled in. Display the normal author in the bibliography if the corporate author is not filled in.
Let's start by changing the citation. Here is the code for citations from last time.
Step 1: Define a new variable in the citation section to count the number of corporate authors
Declare a new variable to help determine whether a corporate author is available. This variable is a count of the number of times the corporate author field exists in the source.
Step 2: Verify that the corporate author has been filled in
Verify that the corporate author has been filled in. You can do this by determining if the count of corporate authors is non-zero. If a corporate author exists, display it. If it does not exist, display the normal author.
Now that you've made the change for citations, make the change for the bibliography. Here's the bibliography section from earlier in this article.
Step 3: Define a new variable in the bibliography section
Once again, let's start by adding a counting variable.
Step 4: Verify that the corporate author has been filled in
Verify that a corporate author exists.
Here's the complete final code.
This article showed how to create a custom bibliography style in Word, first by creating a simple style, and then by using conditional statements to create a more complex style.
- What's new for Word 2013 developers
- Office 365 Developer Blog
- Word for developers website
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Was this page helpful?
Submit and view feedback for
Writer: how to use a spreadsheet as bibliographic database?
LO 22.214.171.124, Fedora 38 (linux), KDE Plasma desktop (Qt widgets)
I want to use a spreadsheet as bibliography source instead of the built-in DB.
What I did with success:
- change data source to the spreadsheet with Edit > Exchange Database
- switch to the spreadsheet with Data Source button
- associate bibligraphy fields with spreadsheet columns through Column Arrangement button
At this point, the bibliography is correctly displayed and I can also edit the rows.
Back to the Writer document, I want to insert a bibliography entry Insert > TOC & Index > Bibliography Entry , but in the dialog the Short name menu is empty. Apparently the link between Writer and this spreadsheet bibliography is not effective though Base (if it is this application in charge of management) correctly displays everything.
Is there a limitation in the Bibliography feature? Have I missed a step?
When I open Tools>Bibliography with the original dBase table in charge and click button [Column Arrangement], I see that the “Short name” property is mapped to the table column “Identifier” with values like ARJ00, AVV00, DUD00, … Your spreadsheet should have some column like this, and you should take care that the values are unique, e.g. by means of conditional formatting. Then you can add a bibliographic reference by picking some book by its unique short name.
The same window has a button [Data Source] which lets me choose any registered data source name as a bibliography.
It’s a rather long chain of links and mappings: [Anything tabular] → [Database.odb] → [Registered Name] → [Table or Query] —> [Bibliography columns]
You changed the link between the first 2 elements. [my_bibliography.ods] → [biblio.odb] → [Bibliography] → [Sheet or DBRange “biblio”] → [Identifier->Short Name etc.] A spreadsheet linked to a new Base doc, registered as “Sheet Biblio” with the right mappings between column labels and Bibliography columns would look like this: [my_bibliography.ods] → [sheet_biblio.odb] → [Sheet Biblio] → [“Sheet1” or “DBRange”] → [Identifier->Short Name etc.]
- You can switch the first link in the database menu:Edit>Database>Connection
- You can switch the second link (the registered name) via Tools>Options>Databases or right-click in data source window.
- You can switch the 3rd link in Writers bibliographic window by choosing another table from the list box on top.
- You can switch the bibliographic mappings (which column means what) by pushing the button [Column Arrangement]
One thing I did not notice until now is that I can not choose a query as a bibliographic source which makes the whole thing unusable with a relational database where I store details on authors, publishers, fields of knowledge in separated but related tables. Work-around: Use a view instead of a table. Views appear in the list of tables. If LO were “my program”, I would drop the entire column mapping and allow for queries with alias names instead. SELECT "Identifier" AS "Short Name", "Name" AS "Book Title", ... FROM "anywhere" . This would be similar to the mail merge feature where you redefine differing column names in switched connections by means of query aliases.
Thanks @Villeroy but I already did nearly all this. I have already used Column Arrangement to map spreadsheet column to bibliography fields Short Name, Author, Publisher, … This works well because Bibliography Database displays everything as expected.
I don’t understand your second paragraph about DB connection. IMHO, this is unnecessary. The connection would effectively create a “mirror” .odb from the spreadsheet. Since I can interact with the spreadsheet from the *Bibliography Database, the bibliography engine seems to have taken notice of the data source.
What doesn’t work is tha application to a Writer document. With the standard bibliography DB, when you Insert > TOC & Indexes > Bibliography Entry , the dialog has a Short name menu with all the known identifiers. With the bibliography spreadsheet, this menu is empty, making impossible to reference an entry.
So, why is the spreadsheet recognised as a valid source by Tools > Bibliography Database but returns nothing from Insert >…
Do you really think I should connect to the spreadsheet, thus create a new .odb ? My goal is to have a unique source. I’m not sure that a “connection” will forward all updates. In addition when I connect, I must define a full schema, which I try to avoid, relying on column headings as proxy TABLE name.
Second bug: The form controls are writable although you can not edit the underlying spreadsheet through this form. Storing the modified record fails silently.
I went through the whole connection procedure, switching to the resulting .odb database but this does not change the insertion menu: it remains empty. Apart from the insertion failure, everything works the same as previously with direct access to spreadsheet. Any clue to what I overlooked?
This changes the source of mail merge fields (existing and the default source of new ones).
After clicking the [Data Source] button, the list of available data sources is a list of Base documents. There is no direct connection to spreadsheets. Tools>Options>Base>Databases is a list of database documents (*.odb). You can not add anything else to that list. Spreadsheet connections are read-only. The database component can not edit spreadsheet documents which is the reason why dBase a much better choice. dBase is the most common and most simple database format.
Indeed you can. I was not aware of the limitation, so I tried it and it worked. I first added the spreadsheet with Edit > Exchange Database (yes, I know its primary role is for mail merge record but bibliography entries are very similar to mail merge records). It then becomes visible in Tools > Bibliography Database Data Source . The remaining problem is retrieval of “Short name” field to build the menu. The reason why I insist on spreadsheet is a solution attempt for a question asked by another user who prepared a long bibliography with Calc and does not want to transfer it to dBase (because he – and I – doesn’t know how to convert a spreadsheet to dBase; and it is too long to proceed manually).
Have a look at the registered databases. They all refer to some Base document. You can easily convert a spreadsheet to dBase via menu:File>Save As… Save to a dedicated directory and connect a Base document to the dBase directory. The database will be editable and you do not have to restart the entire office suite in order to update any changes to the database.
Just try to open the existing .dbf directly in Calc. Edit and save. . Conversions would be done via SaveAs. . There is a second file in the biblio-folder. I didn’t check details, but IMHO it contains the contents for Memo-Type in some columns. . Then all you’d have to do is re-ordering your columns to the existing ones. It should also be possible to use the existing Column-Heads, copy them accordingly to your spreadsheet and save. Type of the database-columns is deducted from the appeded codes like ,C, 70 . If you like upload a shortened .ods, so we can try. 5 lines should be sufficient to see, if the basics work.
Top Contributors in Word: Stefan Blom - Charles Kenyon - Suzanne S. Barnhill - Jim_ Gordon - Bob Jones AKA: CyberTaz 👏
November 13, 2023
Top Contributors in Word:
Stefan Blom - Charles Kenyon - Suzanne S. Barnhill - Jim_ Gordon - Bob Jones AKA: CyberTaz 👏
- Search the community and support articles
- Microsoft 365 and Office
- Search Community member
Ask a new question
how to import my old bibliography .xls file in the 2016 word version?
I have a question. Is it possible to import the oldest complete bibliography file in the new 2016 word version?
Can you help me? If it does not work, I will not buy the program.
No, you're going into the Package Contents for the Microsoft Word.app program -- that's not where you need to be :-) Everything there is best left as it is.
Starting with OS X 10.7 Apple deemed it necessary to protect us from ourselves by making the User Library folders Hidden . To access it, hold the Option key while you open the Go menu in Finder. The Library folder for your User Account will appear directly below the Home listing. Once in the Library folder for your User Account follow the remainder of the path I gave you before:
~: Containers:com.microsoft.Word:Data:Library:Application Support:Microsoft:Office
Was this reply helpful? Yes No
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
Thanks for your feedback.
- Norsk Bokmål
An official website of the United States government
The .gov means it’s official. Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you’re on a federal government site.
The site is secure. The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.
- Account settings
- Advanced Search
- Journal List
- J Med Libr Assoc
- v.104(1); 2016 Jan
Simple export of journal citation data to Excel using any reference manager
Working with citation data from literature searches for systematic reviews can be problematic. The quantity of citations can be quite large. Export functions to the various citation managers (e.g., RefWorks, Zotero, Mendeley, EndNote) are not always sufficient to the task [ 1 ]. While some citation management software such as EndNote 6 offers an export to tab-delimited format [ 2 ], this is not always a routine process. Any data mismatch or nonstandard formatting in the input can throw off the export. Export options will differ for each reference manager, and not all supported users will have the same versions.
A number of solutions are available. For example, Evidence Partners offers their DistillerSR and DistillerSER line of products that support systematic reviews [ 3 ]. On the academic side, the University of Texas has a LibGuide with a set of preconfigured Excel workbooks for working with these citations [ 4 ]. While these tools are quite robust, they require an investment in funds or time to learn and then to customize reference managers to produce the appropriate output. Depending on the environment, there may not be funds or development resources available to take advantage of these options.
Is there a method to reliably convert citation data that does not rely on a specific version of a citation manager and does not need any third-party software or scripting that requires additional training or tools?
CONVERT CITATION DATA TO A SPREADSHEET
This brief overview outlines a method to convert citation data to a form that is easily manipulated. This method relies only on a standard output and functions that are in any spreadsheet application, thus it is easily done by any librarian, researcher, or administrative staff.
The key to this method is to transfer citation data from the citation manager as a defined citation format (e.g., Modern Language Association [MLA] style), rather than a defined file format (e.g., RIS or BibTex), and to use that definition to create the spreadsheet file. Using a test file of 770 citations, this method took less than 5 minutes to convert data from EndNote to a workable Excel file.
To convert data from the citation manager to a spreadsheet file, you need delimiters to separate textual elements. In the MLA style for a journal citation, this delimiter can be found in the separation between the author/title and title/source, as quotes ["]:
Author(s). “Title of Article.” Title of Periodical Day Month Year: pages. Medium of publication.
Note that depending on the source file format, the text may have “smart” quotes (i.e., opening and closing quotes instead of straight quotes). These will have to be replaced for Excel to delimit properly [ 5 ].
To import a dataset into a spreadsheet, export it from the citation manager to a bibliography file in MLA style. Open that file in Excel, and choose “delimited text” and the quotation character as the delimiter. Figures 1 and and2 2 show these two steps. An example of citations in Zotero shown in Figure 3 would appear in Excel as shown in Figure 4 .
Text Import Wizard, step 1
Text Import Wizard, step 2
Citations in Zotero
Citations transferred to Excel
The spreadsheet can then be set up to include the coding scheme appropriate to the review process (i.e., standards such as PRISMA or MECIR). For example, flags for records excluded, and reasons or rankings for strength of evidence can be added as spreadsheet columns.
Additional separation of data is also possible. Citations from PubMed have parentheses around the year data. You can use these as delimiters to separate out year data into a separate column. This will make it easy to analyze the average age of the citations or to group them into historical clusters.
This export method is not completely foolproof. If citations have additional quotes embedded in the title, they will have to be manually adjusted. However, these are a small minority in any output set and can be found by sorting on the journal citation data column. Any that were not imported cleanly will be immediately visible.
Based on feedback the author has received about this method, additional data are preferred in the output, particularly the PubMed ID (PMID). Direct output from PubMed will already have the PMID appended to the end of the citation, from which a uniform resource locator (URL) can be created to allow for one-click access to the abstract (e.g., =HYPERLINK(" www.ncbi.nlm.nih.gov/pubmed/ "&B1)). For citations already in a reference manager, this can be accomplished by adjusting the output style of the bibliograpy. Michigan State University has outlined this process in Zotero [ 6 ], and other reference managers should have similar capabilities.
While the process outlined here is not as robust as some other available solutions, it is sufficient for many tasks and well within the reach of any enviroment.
David Brennan, MLS, ude.usp.cmh@nannerbd , Assistant Librarian, Collection Development/Digital Resources Management, George T. Harrell Health Sciences Library, Penn State Hershey-Milton S. Hershey Medical Center, Penn State College of Medicine, Hershey, PA
Explore the Possibilities
We have the right solution to fit your unique travel needs.
We appreciate your interest in NetJets. A member of our team will be in touch very shortly to discuss your needs.
Call today for a personal consultation with one of our private aviation experts.
Other NetJets Companies
© 2023 NetJets IP, LLC
The Excel/XLS is the staple of the fleet, providing ample cabin and storage space combined with excellent range. Ideal for business meetings while in the air, and leisure travel to the mountains or islands. The Excel/XLS meets the majority of most private jet travel needs and can fly 8 passengers nonstop* between destinations like White Plains to Nassau, travel from east coast to island paradise in comfort and style. *Range is subject to actual passenger and luggage load, weather conditions, and other factors.