Skip to main content

Clean and export LinkedIn CSV data exports to Excel

Project description

LinkedIn Analyzer

Clean and analyze your LinkedIn data exports.
Web app or Python CLI. File contents stay local in the web app; optional diagnostics are opt-in.

CI PyPI MIT License


What it does

LinkedIn's data exports are messy. This tool fixes that.

  • Shares.csv has weird nested quote escaping
  • Comments.csv has backslash-escaped quotes
  • messages.csv has mixed participant/profile fields that need normalization
  • Connections.csv often includes preamble rows and noisy identity fields

Upload your files, get clean Excel outputs. Plus analytics dashboards, relationship views from messages/connections, and rule-based insights.


Quick start

Development: Install locked Python and Node dependencies:

# Requires Python 3.11+, uv, and Node.js 22.13.x or 24+
make setup

Web: Run the Vite dev server and open the local URL:

cp .env.example .env  # optional; set VITE_SENTRY_DSN + VITE_APP_RELEASE for opt-in diagnostics
make web

CLI: For automation:

pip install linkedin-analyzer
linkedin-analyzer shares
linkedin-analyzer comments
linkedin-analyzer messages
linkedin-analyzer connections
linkedin-analyzer all

Container: Run the published CLI image:

docker run --rm -v "$PWD/data:/app/data" ghcr.io/hermione-granger-1176/linkedin-analyzer:latest --version

Tech stack

HTML5 CSS3 JavaScript Python

Web app

Rough.js Canvas API IndexedDB Web Workers write-excel-file

Python CLI

openpyxl argparse mypy strict

Dev & CI

pytest Ruff ESLint GitHub Actions


Features

Feature Detail
100% client-side File contents stay local in your browser
Local restore Raw CSV data may be saved in browser storage until cleared
Light/dark theme Hand-drawn sketch aesthetic
Guided tutorials Per-page tutorials
Analytics Timeline, topics, heatmap
Messages view Top contacts, silent connections, fading chats
SPA routing Hash routes with URL-synced filters
Excel export Formatted .xlsx with proper columns
Connections Network growth, top companies, top positions
Chart export Download any chart as PNG
PWA-ready Installable with auto-refreshing service worker caching
Session cleanup Stale uploads and cached analytics cleared asynchronously
Social previews Open Graph and Twitter Card meta tags
Type-safe CLI Strict mypy, high test coverage (100% threshold)

Documentation

See the docs/ folder for:

Architecture Decision Records: docs/adr/

Contributor guide: .github/CONTRIBUTING.md

Changelog (Python package): CHANGELOG.md

Security reporting guidelines: .github/SECURITY.md


License

MIT


Created by Aditya Kumar Darak

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

linkedin_analyzer-0.6.0.tar.gz (58.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

linkedin_analyzer-0.6.0-py3-none-any.whl (24.1 kB view details)

Uploaded Python 3

File details

Details for the file linkedin_analyzer-0.6.0.tar.gz.

File metadata

  • Download URL: linkedin_analyzer-0.6.0.tar.gz
  • Upload date:
  • Size: 58.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.13

File hashes

Hashes for linkedin_analyzer-0.6.0.tar.gz
Algorithm Hash digest
SHA256 51e6ae9a80a00dfc7751c988b1fe79a6030ef957ff363d35a74cb8fa1c538ba0
MD5 998e29091376ab95dcf4b61f8bd02b47
BLAKE2b-256 3a217aa80557d1b6476ac32047c39128f892def2d3b2e32ad65a6d9df986eb79

See more details on using hashes here.

Provenance

The following attestation bundles were made for linkedin_analyzer-0.6.0.tar.gz:

Publisher: publish.yml on Hermione-Granger-1176/linkedin-analyzer

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file linkedin_analyzer-0.6.0-py3-none-any.whl.

File metadata

File hashes

Hashes for linkedin_analyzer-0.6.0-py3-none-any.whl
Algorithm Hash digest
SHA256 f9b42845094c513320ba8a536960792939549abf3948219906a24d69e2405715
MD5 141fa2619378b9d87649559d1ba7c5de
BLAKE2b-256 250b211f2e4df2229f9d3165d0b06aec072676b2ce48c1816c9b187ad40b030b

See more details on using hashes here.

Provenance

The following attestation bundles were made for linkedin_analyzer-0.6.0-py3-none-any.whl:

Publisher: publish.yml on Hermione-Granger-1176/linkedin-analyzer

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page