skills.rest
susantosanto
susantosantoCOMMUNITY
Explore all skills by this author →
GitHub

dapodik-scraper

Download all peserta didik data from the Dapodik Web Service into an Excel file.

Updated Apr 4, 2026
Search Tags:#python#excel#pagination#data-extraction#web-service#pd#dapodik
One-click install
npx skills add https://github.com/susantosanto/config-opencode --skill dapodik-scraper
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dapodik-scraper
Source: https://github.com/susantosanto/config-opencode/tree/main/skills/dapodik-scraper
Command: npx skills add https://github.com/susantosanto/config-opencode --skill dapodik-scraper

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires requests, pandas, openpyxl.

What problem does it solve?

This skill automates the extraction of all peserta didik data from the Dapodik Web Service and saves it to an Excel file for easy reporting and archival.

Core Features & Use Cases

  • Automated data export across all pages using pagination to a single Excel file.
  • Local deployment optimized for SD operators who run Dapodik on a workstation and need ready-to-use exports.
  • Use Case: generate a complete student roster in Excel for reporting to school authorities.

Quick Start

Run the script to fetch all student records from Dapodik and save them to an Excel file.

Frequently Asked Questions about dapodik-scraper

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

FAQPage Schema
How do I export peserta didik data from Dapodik Web Service to Excel?▼

To export peserta didik data to Excel, run a script that fetches all student records from the Dapodik Web Service using pagination and saves them into a single Excel file. It handles HTTP requests, structures the data with pandas, and writes the output using openpyxl.

What do I need to access Dapodik student data for local extraction?▼

You need the Dapodik desktop application running locally at http://localhost:5774, along with a valid token and NPSN for API access. These prerequisites allow the script to authenticate and extract peserta didik data successfully.

Does the Dapodik data extraction tool handle large datasets across multiple pages?▼

Yes, the Dapodik data extraction tool handles large datasets by using pagination to fetch all student records across all available pages. It consolidates the complete peserta didik dataset into one Excel file without manual intervention.

How does Python retrieve student roster data from the Dapodik local web service?▼

Python retrieves student roster data by sending HTTP requests to the local Dapodik Web Service API. It uses the requests library for fetching data, pandas for structuring the retrieved records, and openpyxl to generate the final Excel output file.

Why does my Dapodik Web Service data extraction fail when running locally?▼

Dapodik Web Service data extraction fails if the Dapodik desktop application is not running locally at http://localhost:5774, or if the provided token and NPSN are invalid. The script includes error handling, but correct API credentials are mandatory.

Related Skills

Explore More Data & Analytics Skills→
susantosantosusantosanto

surat-pindah

Generate school transfer letters as DOCX from Dapodik student data.

Community
Intermediate
lazygopherslazygophers
4

office-xlsx-skills

Read, write, analyze, and convert Excel, CSV, and JSON files.

Official
Advanced
bloknayrbbloknayrb
2

Excel Analysis

Analyzes and transforms data in .xlsx files using Python libraries.

Community
Intermediate
susantosantosusantosanto

dapodik-student-lookup

Locates student records from the Dapodik Web Service by name and class.

Community
Intermediate