executive-obsidian

Extract finance executive data from Excel into structured knowledge graphs and Obsidian vaults.

Updated May 25, 2026
One-click install
npx skills add https://github.com/tonybaoaxe/executive-obsidian-skill --skill executive-obsidian
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: executive-obsidian
Source: https://github.com/tonybaoaxe/executive-obsidian-skill/tree/main
Command: npx skills add https://github.com/tonybaoaxe/executive-obsidian-skill --skill executive-obsidian

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

将证券公司高管人员的 Excel 数据自动转换为结构化知识网络,提取教育背景、职业履历与关系,并输出可在 Obsidian 中跳转的知识库。

Core Features & Use Cases

  • LLM 实体抽取 — 从非结构化个人简介中自动提取教育经历、职业履历、专业资格等结构化信息
  • 三级业缘关系与校友网络 — 自动构建现任同事/前同事/校友网络,确保双向连接与跨公司追溯
  • Obsidian 原生输出 — 生成标准 Vault,支持 Graph View 可视化关系网络
  • 增量处理与缓存 — 支持断点续跑,缓存未抽取公司以加速重复执行
  • 多 LLM 提供商支持 — 兼容 OpenAI、Anthropic、DeepSeek、智谱、通义千问等 API

Quick Start

Provide the Excel file path and run the pipeline to start the end-to-end extraction and Obsidian vault export.

Frequently Asked Questions about executive-obsidian

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

FAQPage Schema
How do I convert Excel executive data into an Obsidian knowledge graph?

To convert Excel executive data into an Obsidian knowledge graph, this Skill uses pandas and openpyxl to extract entities like education and career timelines via LLM, then exports a fully linked Obsidian vault with bidirectional relationship mapping.

Can I use OpenAI or Anthropic APIs for entity extraction from executive profiles?

Yes, you can use OpenAI, Anthropic, DeepSeek, Zhipu, and Qwen APIs for entity extraction from executive profiles, enabling the pipeline to automatically parse unstructured bios into structured education and career data.

How to build alumni and workplace networks from finance Excel data?

You can build alumni and workplace networks from finance Excel data by running the extraction pipeline, which automatically constructs three-tier professional relationships including current colleagues, former colleagues, and alumni with cross-company traceability.

Does the Excel to Obsidian pipeline support incremental processing?

Yes, the Excel to Obsidian pipeline supports incremental processing and caching, allowing you to resume interrupted runs and cache previously extracted companies to accelerate repeated executions.

What Excel formats are supported for extracting executive career timelines?

The pipeline requires the pandas and openpyxl dependencies to process standard Excel files, extracting structured executive career timelines and qualifications from unstructured personal bios.

What are the limitations of using LLM to extract education history from Excel bios?

A key limitation of using LLM to extract education history from Excel bios is the dependency on external API providers for accurate unstructured data parsing, requiring valid API keys and incurring processing costs for each extraction.