skills.rest
yipng05-max
yipng05-maxCOMMUNITY
Explore all skills by this author →
GitHub

foreign-literature-search

Automate foreign academic literature searches via OpenAlex and export deduplicated Excel files.

265|23|Updated Feb 7, 2026
Search Tags:#literature search#openalex#excel export#keyword strategy#wos boolean#english papers#ssci
One-click install
npx skills add https://github.com/yipng05-max/-skills --skill foreign-literature-search-yipng05-max
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: foreign-literature-search
Source: https://github.com/yipng05-max/-skills/tree/main/foreign-literature-search
Command: npx skills add https://github.com/yipng05-max/-skills --skill foreign-literature-search-yipng05-max

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

This Skill helps researchers systematically search for relevant foreign-language academic literature and quickly turn the results into a structured, deduplicated Excel file, including optional WoS/Scopus Boolean search strings for later database use.

Core Features & Use Cases

  • OpenAlex-based three-stage search: subject/joint search, independent background/theory补充检索, then汇总去重分类。
  • AND/semantic-style keyword grouping: builds query groups where synonyms are OR-ed within a group and groups are intersected, with post-filtering using title/abstract.
  • Research-ready outputs: exports categorized Excel with journal ranking fields (JCR/CA Tiers and a 2-year impact estimate where needed) plus DOI/OA links and abstracts.

Quick Start

Run the foreign-literature-search Skill and provide your study topic keywords so it generates a categorized Excel of English/foreign papers using the OpenAlex API.

Frequently Asked Questions about foreign-literature-search

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I find relevant English papers for a literature review without institutional access?▼

Foreign literature search uses the OpenAlex API to automate academic paper retrieval without institutional access. It applies multi-group AND logic with keyword strategies to find English and SSCI papers, exporting categorized results to Excel.

Can I export OpenAlex search results to Excel with DOI and OA links?▼

Yes, OpenAlex search results can be exported to a structured Excel file containing DOIs, OA links, abstracts, and journal ranking fields. The output is deduplicated and categorized to support literature review workflows.

How to build a WoS Boolean search string for SSCI papers using OpenAlex?▼

OpenAlex retrieval applies AND/semantic-style keyword grouping where synonyms are OR-ed within a group and groups are intersected. It generates optional WoS/Scopus Boolean search strings for later database use alongside the Excel export.

Does OpenAlex literature search support title and abstract post-filtering?▼

OpenAlex literature search supports title and abstract post-filtering to refine topic-focused results. It performs stage-based retrieval including subject search, independent background search, and final deduplication classification.

What is the best way to search for foreign academic literature and enrich it with journal rankings?▼

Automated foreign literature search via OpenAlex enriches results with journal ranking fields like JCR/CA Tiers and impact estimates. It deduplicates and categorizes papers into an Excel file for research-ready literature framing.

Do I need an API key to search English papers through OpenAlex?▼

OpenAlex API requests for English paper searching do not require institutional access or an API key for basic retrieval. The Skill automates multi-group AND logic queries and post-filtering to produce structured Excel outputs.

Related Skills

Explore More Education & Research Skills→
jaechang-hitsjaechang-hits
298

openalex-database

Query the OpenAlex REST API for scholarly works, authors, and institutions.

Community
Intermediate
nahisahonahisaho
3

scientific-preprint-archive

Aggregate open-access preprints and papers from multiple archives into structured results.

Community
Advanced
RenJW418RenJW418

foreign-literature-search

Search OpenAlex for social-science papers and generate Excel outputs with boolean query strings.

Community
Intermediate
botlearn-aibotlearn-ai
9

google-search

Construct advanced search queries with Boolean operators and credibility-based ranking.

Official
Intermediate