How to merge Scopus and Web of Science (WoS) databases to use on Bibliometrix or Mendeley 

Hi Rafael Thanks for a wonderful tutorial. It was really awesome. The best part of this post is the two tips. Two thumbs up!!! I would suggest an alternate way to remove duplicates from excel sheet. 1. Select the column in which you want to find duplicates. 2. Go to the "Data" tab in the Excel ribbon. 3. Click on the "Remove Duplicates" button in the "Data Tools" group. 4. A dialog box will appear with the column(s) selected for duplicate removal. Make sure the correct column is selected. Also make sure you expand the selection to select all columns in the excel sheet. 5. Click the "OK" button. Excel will remove any duplicate values from the selected column, and you will be left with only unique values. In my case, I was able to remove 20 duplicates from an initial 3439 rows!! After that Biblioshiny worked without the "duplicate row.names are not allowed" error. So again a big big thanks for your guidance. Keep up the good work!!!

Thanks! Because WoS only generates a maximum of 500 entries per datafile if you export full record and references, sometimes you end with more than one exported file from WoS. The convert2df code you kindly shared here seems to work for one file at a time and I had two, so I first used an editor (BibDesk) to merge the two .bib files into one, and then used your convert2df code. Everything worked just fine, thanks!

thanks rafael! i tried many other tutorials, but this was the only that worked

Thank you Rafael!!! super helpful

Crystally clear! You saved my life, my friend.

Thank you so much for providing such a clear solution

Very clear and straigth to the point. Muito obrigado pela grande ajuda, Rafael!

Thank you so much, Rafael Queiroz. It's very obvious and helpful for me in carrying on MSc dissertation.

Hi Rafael, Many thanks for the wonderful video. I want to add some more records (not identified by Scopus or WoS) to the final merged Excel file. Is there an easy way of adding them?

thank you , Rafael, however, the combined excel file had an "na" error and so I was unable to use it in rstudio or vosviewer.

thank you, when i try to use bibtex-tidy, i got: There's a problem with the bibtex Syntax Error on line 31606 column 14 The entry key cannot contain whitespace. how could I correct this?

I am trying to merge the Scopus and Dimensions databases, is this the same procedure? Thank you very much.

the coding part is confusing. can you simplify the process more?

Sir After merging i get the data in capital letters only and also space between them also disturbed. Please help.

Thank you!

Thanks for this video! After successfully merging a WOS and SCOPUS database and removing a large number of duplicates, I still receive the error message "double row names". Any ideas?

Thank you very much. I'll try

perfact🤩🤩

Hello Thank you very much for the video. I am getting the following error. I wonder what I should do? I would really appreciate if you can help Error in mergeDbSources(wos, scopus_1, scopus_2, remove.duplicated = T): could not find function "mergeDbSources"

Could we read IEEE bib file. I used convert2df with dbsource = "scopus", and I got an error: Missing fields: AU DE ID C1 CR Error in data.frame(..., check.names = FALSE) : arguments imply differing number of rows: 0, 55

Good morning, first of all thank you very much because thanks to your video I was able to merge and generate a single database in wos and scopus. The only thing is that I am getting an error in Biblioshin and the graphic "Countries' Collaboration World Map" is this normal? I have followed your advice to manually remove duplicates that were left in excel generated but that graph still does not work for me, thanks in advance.

Hello, can help me to get publications from WoS?

I am receiving this error despite selecting all fields in Scopus_ Missing fields: AU DE ID C1 CR Error in data.frame(..., check.names = FALSE) : arguments imply differing number of rows: 0, 2583 How to resolve it?

thank you so much

Hi @Rafael, The method you tell work well, but i need information, I have downloaded file from scopus and WOS by clicking contain all information. when i have merged file and opened it with bibliometrix then i am getting error "Number of cited references" and Cited references completely missing. Can you help me in this

What If I want to merge it to a bib file instead of a xlsx file ?

Is it possible to download high-resolution or vectorial images from the Biblioshiny interface?

thanks! it is possible to merge a Wos, Scopus and Science direct databases to upload it to bibliometrix?

How to merge PubMed and WoS data?

Is there a way to get a list of the removed duplicates? thank you for the video!

Is it possible to share this code?

Hi Can I use it in vosviewer?

Hi Am getting error while running the code

Thanks man