Introducing biblioMagika® - Your One-Stop Solution for Comprehensive Bibliometric Analysis

Welcome to biblioMagika®, the ultimate tool designed to revolutionize bibliometric analysis for researchers of all levels. By harnessing the power of biblioMagika®, you can effortlessly transform your Scopus data into an array of meaningful metrics, including citation counts, h-index, g-index, and many more. Moreover, biblioMagika® simplifies the process of cleaning and harmonizing author, affiliation, and country data, ensuring accuracy and reliability before uploading your data to VOSviewer or Biblioshiny. Say goodbye to manual data cleaning and complex calculations - biblioMagika® is here to make bibliometric analysis easier and more accessible than ever before.

With a wide range of features, biblioMagika® provides unmatched compatibility with the Scopus database, generating essential citation metrics and offering flexible, in-depth analysis based on various parameters. In addition, the app facilitates the identification of highly cited documents and author productivity assessment while comparing single and multi-author publications. Furthermore, biblioMagika® excels in processing author and affiliation data, identifying missing information, automatically recognizing institutions and countries, and integrating with popular data cleaning and visualization tools like OpenRefine, VOSviewer, and Biblioshiny.

Key Features

1. Overall Citation Impact

biblioMagika® provides a wealth of citation metrics for your entire dataset. These metrics include information on publication years, total publications, author contributions, citations per paper, and many more. It's your comprehensive tool for assessing the overall impact of your research.

2. Publication by Year - Tracking Growth and Trends

Keep up with the ever-evolving landscape of research by examining publication trends over time. With biblioMagika®, you can easily analyze data based on publication years. This feature allows you to spot growth patterns, track trends, and identify critical moments in your research field.

3. Publication by Source Titles - Journal Insights Unveiled

Journals play a central role in academic research. biblioMagika® lets you delve deep into the world of source titles, unveiling the most productive and influential journals. Identify the top players in your field and make well-informed decisions.

4. Production by Publishers - Know Your Publishing Partners

Collaborations with publishers are essential for researchers. biblioMagika® empowers you to assess your production based on publishers. This feature helps you understand which publishers are driving innovation in your specific domain, facilitating valuable partnerships.

5. Journal Categories - Benchmarking with Precision

For a thorough evaluation, biblioMagika® allows you to categorize journals based on authoritative metrics such as AJG2021 Rating, ABDC Rating, or Bradfords Law. You can benchmark journals against each other to determine their impact and relevance.

6. Publication by Authors - Spotlight on Productivity

Recognize and acknowledge the contributions of authors in your field. biblioMagika® streamlines the evaluation of author productivity. Discover the most prolific authors and distinguish them by various categories of impact.

7. Author Productivity at a Glance

biblioMagika® provides you with detailed insights into author productivity, allowing you to gauge the impact and contribution of individual authors accurately.

8. Collaboration Insights with Single vs. Multiple Author Comparison

Explore the dynamics of scholarly collaboration effortlessly. biblioMagika® empowers you to compare single-author and multi-author publications, providing valuable insights into the world of collaborative research.

9. Institutions Analysis - Recognize Productive and Influential Institutions

biblioMagika® assists in identifying the most productive and influential institutions in your field. This knowledge helps you form collaborations with high-impact partners and gain insights into the academic landscape.

10. Country Insights - Discover Global Influence

Analyze publications by country to determine the most productive authors and influential nations. Gain a global perspective and make informed decisions in an international context.

11. Map Integration with - Visualize Data like Never Before

biblioMagika® seamlessly integrates with, enabling you to create interactive maps based on your data. Visualize research hotspots and international collaborations effortlessly.

12. Effortless Identification of Highly Cited Works

biblioMagika® automatically highlights highly cited documents, saving you time and helping you delve into the most impactful research effortlessly.

13. Impeccable Data Quality and Standardization

This feature expertly harmonizes author names, affiliations, and country data, eliminating discrepancies and ensuring the highest level of data accuracy.

14. Missing Data No More

biblioMagika® helps you identify and correct missing information within your dataset, guaranteeing comprehensive and reliable analysis results.

15. Automatic Institution and Country Recognition

Automatically recognize institutions and countries associated with authors, simplifying the data standardization process. Additionally, you can easily access this information through generated links using EID or AUTH-ID from biblioMagika.

16. Seamless Integration with OpenRefine - Advanced Data Cleaning and Harmonization

Unlock the power of advanced data cleaning and harmonization by seamlessly integrating biblioMagika® with OpenRefine. This dynamic partnership empowers you to refine and standardize your datasets to perfection, ensuring the highest level of accuracy and consistency in your research data.

17. Combine Refined Data with VOSviewer - Visualize Your Insights with Precision

Your journey to visualizing complex bibliometric data begins with biblioMagika®. When data downloaded from Scopus is often messy and in need of careful preparation, our software steps in as the solution. biblioMagika® serves as the platform to clean and harmonize your data, transforming it into a refined masterpiece.

Once your data is polished to perfection, seamlessly combine it with VOSviewer. This renowned tool is specifically designed to help you visualize complex bibliometric data with precision. Gain invaluable insights and explore intricate connections within your research network effortlessly.

18. Leverage Biblioshiny - Enhance Your Analysis with User-Friendly Interactivity

Elevate your research analysis to new heights by integrating biblioMagika® with Biblioshiny. This user-friendly tool enhances your research experience with interactive and intuitive features. Effortlessly navigate through your data, uncover meaningful patterns, and gain deeper insights into your research landscape.

With biblioMagika®, you have the flexibility to choose the integration that suits your specific research needs, whether it's advanced data cleaning with OpenRefine, in-depth visualization with VOSviewer, or enhanced interactivity with Biblioshiny. Elevate your research to new horizons with these seamless integrations.


Flowchart for Bibliometric Analysis Dataset Preparation using biblioMagika®


Sample Analysis from biblioMagika®




biblioMagika® now can be downloaded at

Just so you know, while this app is available for download, it is best utilized during my guided sessions, such as the training sessions I regularly conduct, or by following the step-by-step process outlined in my book. You should also follow the flowchart that has been provided above.

How to Cite biblioMagika®

If you are using the biblioMagika® in one of your research articles, please use the following format:

Ahmi, A. (2023) biblioMagika, available from

Version History

biblioMagika® - v2.5.1
Fixed the formula of countries data for
Added column NCA for affiliation and countries

biblioMagika® - v2.5
Incorporate the country data with
Improved the Scopus link to associate with user's account
Update Scopus List as at December 2023
Added column for AU-ID Link for easy finding the current affiliation and country of the authors in the Author worksheet.
Added column for Author Full Name (Last Name, First Name) in the Author Worksheet.
Added column for Current Affiliation and Country in the Author Worksheet.
Added column for Google Search Link for easy finding the country of the affiliation in the Affiliation worksheet.
Added column for Country in the Affiliation Worksheet.

biblioMagika® - v2.4
Incorporated cumulative TP calculation data within the section on Publications by Source Titles.
Included Bradford's Law Zone information within the Publications by Source Titles section.
[Just make sure the TP and second layer of sorting has been sorted accordingly]
Appended a dedicated worksheet containing the Australian Business Deans Council (ABDC) listings from the 2019 Journal Quality List (JQL).
Integrated a worksheet housing the Chartered Association of Business Schools (CABS) listings from the 2021 Academic Journal Guide (AJG).
Incorporated a worksheet containing the comprehensive list of journals indexed by Scopus for the year 2023.
Supplemented the Publication by Source Titles section with the AJG 2021 ratings.
Augmented the Publication by Source Titles section with the ABDC ratings.
Incorporated the publisher names within the Publication by Source Titles section.
Provided accessible hyperlinks for each journal listed in the Publication by Source Titles section.
Included the "Top 20 Most Productive Source Titles" chart within the "Publication by Source Title" worksheet.

biblioMagika® - v2.3
Fixed the calculation of g-index for Authors, Affiliations and Countries.

biblioMagika® - v2.2
Added DOI for Highly Cited Documents.
Minor cell formatting.

biblioMagika® - v2.1
Increase the limitation of analysis from 10000 to the limit that Excel or your computer can works Increase from 20 to 50 highly cited documents.
Add refresh button to recalculate all the measurements related to h-index, g-index and m-index based on the total number of documents. So, your computer will not use the resources all the times
Fixed the calculation of C/CP for source titles.
Convert from normal Excel file (.xlsx) to Macro-enabled file (.xslm)
Format all the buttons in the Home sheet into bevel

biblioMagika® - v2.0
Convert the Basic Info Pivot Table from Horizontal to Vertical.
All of the measurements in the Basic Info. have been renamed in full.
Added productivity patterns of authors and Lotka's Law (still in Beta version)
Added data label and axis titles to column chart for single author vs multi-authors
New color scheme for the main menu and all the worksheets
Fixed "0" data for authors
Some "tips" from the callout boxes have been added and improved

biblioMagika® - v1.9.0
Updated formula to read column "Cited by" due to the changes made by Scopus (New Version)

biblioMagika® - v1.8.1
Reorganised the menu button

biblioMagika® - v1.8
Added column Citable Year and Pub. Year Start for Source, Author, Affiliation and Country Analysis
Added column Citable Year for Year
Fixed m-index calculation.
Remove POP worksheet. All calculation in now will be based on Scopus New Version .csv file
Added calculation for C/Y
Added calculation for C/A
Added more calculation in Data(Year) to calculate the citation metrics for ALL the data.
Added citation metrics in basic info.
Removed Join workheet. All splitting and joining process will be focused on the biblioMagika®Split.xlsm file.

biblioMagika® - v1.7
Fixed the issue with sum of h-index, g-index, m-index and citation sum with h-core. These values cannot be summed up.
Change the name from Joining Splitted Data into Joined Data. Data joined process should be done in the other biblioMagika®Split.xlsm file since the macros from this file have been removed.
Fixed the reading TP of affiliation from POP

biblioMagika® - v1.60
Support for reading POP file
Added Top-20 Highly Cited Documents
Added Authorship Analysis: Number of Author(s) per Document and analysis of Single-author vs. Multi-authors
Added additional fields for Publication by Source Titles
Added Top 25 Most Productive Authors (Read from POP Worksheet)
Added Top 25 Most Productive Institutions (Read from POP Worksheet)
Added Total Documents by Country (Read from POP Worksheet)
Added Map by Continent
Re-arranged the columns in Split(Author) worksheet
Re-arranged the columns in Split(Affiliation) worksheet
Re-arranged the columns in Split(Country) worksheet
Re-arranged Home worksheet
Removed all macros
Changed the format from .xlsm to xlsx

04/03/2023 |
biblioMagika® - v1.50
Fixed the code due to higher resource usage error in Excel
Update the speed for joining the splitted file

biblioMagika® - v1.30
Limit the row reading from 20000 to 10000 data only.
Fixed the some of the formula.

biblioMagika® - v1.10
Main menu is created and released for public view.
Fixed the issue of slowingly splitting the author and affiliation field.

biblioMagika® - v1.00
The first version is released. This version include the splitting and joining the author and affiliation field.


Assoc. Prof. Ts. Dr. Aidi Ahmi
Tunku Puteri Intan Safinaz School of Accountancy
Universiti Utara Malaysia
06010 UUM Sintok
P: +604 928-7222
[email protected]

QUOTEof the Day

"Be faithful to that which exists within yourself."
Andre Gide