--- title: How to Export and Analyze 13F Holdings Data Outside the Platform type: learn slug: how-to-export-and-analyze-13f-holdings-data-outside-the-platform canonical_url: https://13finsight.com/learn/how-to-export-and-analyze-13f-holdings-data-outside-the-platform published_at: 2026-03-29T01:22:14.067Z updated_at: 2026-03-29T01:22:16.025Z author: Sarah Mitchell author_title: Education Editor author_url: https://13finsight.com/authors/sarah-mitchell word_count: 604 locale: en source: 13F Insight --- # How to Export and Analyze 13F Holdings Data Outside the Platform > A practical walkthrough for using 13F Insight exports in spreadsheets and Python, with tier-specific guidance for CSV and JSON workflows. Why export data if the platform already has charts and tables? 13F Insight is built for fast signal discovery, but offline analysis is still useful when you want to build your own scoring model, keep an audit trail, or combine holdings data with other datasets. Export gives you that flexibility without losing the context you found on-platform. For example, you can start from a filer page like Berkshire Hathaway’s filer profile, then export holdings into your own workbook to rank position changes with custom thresholds. Export access by plan Free: no export access Standard: CSV export Pro: CSV + JSON export If you are building anything repeatable (quarterly trackers, model portfolios, internal dashboards), Pro’s JSON export is usually worth it because it maps cleanly into Python and API-style pipelines. Where export is available in 13F Insight Holdings tables on filer detail pages Stock holder lists on stock pages like AAPL and MSFT Filer comparison views when you compare managers side by side A simple rule: export from the exact view you are using for decisions. That keeps your offline file aligned with what you actually saw in the UI. Step-by-step walkthrough Open the view you want to analyze. Start on a filer holdings table, a stock’s holder list, or a filer comparison view. Set your filters first. Quarter, sorting, and scope should be finalized before export so your file matches your on-screen thesis. Click Export and choose format. Standard users select CSV. Pro users can choose CSV or JSON depending on toolchain. Name the file with context. Include entity and quarter, for example berkshire-2026Q1-holdings.csv or aapl-holders-2026Q1.json. Validate totals after download. Before analysis, verify row count and top positions against the page to avoid downstream mistakes. Analyze with your preferred tool. Spreadsheet for quick slicing; Python for repeatable scoring and quarter-over-quarter diffs. Spreadsheet workflow that works for most investors Use CSV when you want speed and visibility: Create a pivot table for exposure by sector, issuer, or filer Add conditional formatting for large percentage changes Track your own watchlist threshold, such as weight change above 1.5 percentage points Best practice from retail data workflows: keep one tab as raw export and do all calculations in separate tabs. Never overwrite the raw file. That makes your process easier to audit and update next quarter. Python workflow for Pro users (JSON + CSV) JSON is useful when you want structured fields without spreadsheet cleanup. A practical setup is: Load JSON into pandas Normalize column names once Run a reusable script to compare current quarter vs prior quarter Export your final signal table back to CSV for review Data hygiene matters more than model complexity. Add basic checks at load time: null counts, duplicate rows, and outlier flags on value and weight changes. Real use cases you can run this week Conviction monitor: export two quarters of one filer and rank the biggest weight increases Crowding check: export a stock holder list and compare holder overlap with your watchlist Manager style map: export filer comparison data to separate concentrated managers from diversified allocators Common mistakes to avoid Exporting before filters are finalized Mixing files from different quarters without clear naming Treating every large position as active conviction without cross-checking context Skipping validation between UI totals and downloaded rows If you want a stronger interpretation framework before exporting, read more explainers in the Learn hub. Bottom line On-platform views help you find signals quickly. Export helps you turn those signals into a repeatable process. Start with CSV if you want fast analysis, move to JSON when you need automation, and keep a clean naming and validation routine every quarter. ## FAQ ### Who can export data on 13F Insight? Free users cannot export. Standard users can export CSV. Pro users can export both CSV and JSON. ### Where can I export data from inside the platform? Export is available on filer holdings tables, stock holder lists, and filer comparison views. Choose the view first, then export from that exact context. ### Should I use CSV or JSON for analysis? Use CSV for spreadsheet workflows and quick manual analysis. Use JSON when you want structured data for repeatable scripts in Python or other tools. ### What is the safest way to avoid analysis errors after export? Keep raw exports unchanged, use clear file names with quarter tags, and verify row counts and top holdings against the original on-platform table before running calculations. ### Can I combine exported files with my own watchlist data? Yes. Many users merge exported holdings or holder lists with custom watchlists in spreadsheets or pandas to build their own ranking and alert rules. --- Source: 13F Insight — https://13finsight.com/learn/how-to-export-and-analyze-13f-holdings-data-outside-the-platform Author: Sarah Mitchell — https://13finsight.com/authors/sarah-mitchell Last updated: 2026-03-29T01:22:16.025Z