CSV to 금융 JSON 변환기

브로커 CSV 내보내기를 JSON 배열로 정규화하세요.

CSV Input

결과

[
  {
    "date": "2024-01-01",
    "symbol": "AAPL",
    "type": "BUY",
    "quantity": 10,
    "price": 150
  }
]

이 도구가 마음에 드시나요? portfolios.tools를 영원히 무료로 유지하는 데 도움을 주세요.

$1$50

작동 방식

Paste broker CSV export data into the text area. The tool detects delimiters, identifies financial columns, and converts to a structured JSON array. Each row becomes a normalized transaction record with standardized field names ready for further analysis. Export transactions from Schwab, Fidelity, Interactive Brokers, or Robinhood as CSV. Paste into the text area and the tool maps columns like Date, Symbol, Action, Quantity, and Amount to a clean JSON array. Download CSV from broker activity page covering full tax year. Paste up to several thousand rows: parsing runs locally without row limits. Strip summary footer rows from broker CSV before paste because footers can confuse row detection. Export transactions from Schwab, Fidelity, Interactive Brokers, or Robinhood as CSV. Paste into the text area and the tool maps columns like Date, Symbol, Action, Quantity, and Amount to a clean JSON array. Upload broker CSV exports: tool maps columns to normalized transaction JSON with ticker, date, quantity, price, and fees. Export transactions from Schwab, Fidelity, Interactive Brokers, or Robinhood as CSV. Paste into the text area and the tool maps columns like Date, Symbol, Action, Quantity, and Amount to a clean JSON array. Upload broker CSV exports: tool maps columns to normalized transaction JSON with ticker, date, quantity, price, and fees. Export transactions from Schwab, Fidelity, Interactive Brokers, or Robinhood as CSV. Paste into the text area and the tool maps columns like Date, Symbol, Action, Quantity, and Amount to a clean JSON array.

Review the parsed JSON output with standardized field names (date, symbol, type, quantity, price, amount) and type information for each column. Export the clean JSON data for use in other portfolio analysis tools. Use the JSON output to feed portfolio trackers, tax lot analyzers, or custom dashboards. Standardized field names reduce manual cleanup before import. Download JSON for import into custom scripts using date, symbol, type, quantity, price, and amount fields consistently. Validate row count in JSON matches CSV data rows minus header before importing to downstream tools. Use the JSON output to feed portfolio trackers, tax lot analyzers, or custom dashboards. Standardized field names reduce manual cleanup before import. Preset maps cover common US brokers; custom column mapping handles international CSV with semicolon delimiters. Use the JSON output to feed portfolio trackers, tax lot analyzers, or custom dashboards. Standardized field names reduce manual cleanup before import. Preset maps cover common US brokers; custom column mapping handles international CSV with semicolon delimiters. Use the JSON output to feed portfolio trackers, tax lot analyzers, or custom dashboards. Standardized field names reduce manual cleanup before import.

tax lot analyzers, or custom dashboards. Standardized field names reduce manual cleanup before import. Preset maps cover common US brokers; custom column mapping handles international CSV with semicolon delimiters. Use the JSON output to feed portfolio trackers, tax lot analyzers, or custom dashboards. Standardized field names reduce manual cleanup before import. Preset maps cover common US brokers; custom column mapping handles international CSV with semicolon delimiters. Use the JSON output to feed portfolio trackers, tax lot analyzers, or custom dashboards. Standardized field names reduce manual cleanup before import.

입력값이 변경될 때마다 CSV to 금융 JSON 변환기을(를) 사용하세요: 시장 변동, 새로운 기여금 또는 수정된 개인 가정 후. 소프트웨어 설치 없이 빠른 재실행을 위해 페이지를 북마크하세요.

단계별 안내

CSV to 금융 JSON 변환기을(를) 열고 현재 입력값을 입력하세요.
계산된 출력과 요약 테이블을 검토하세요.
가정을 조정하고 시나리오를 나란히 비교하세요.

실전 예제

Paste broker CSV export data into the text area. Enter the sample inputs described in How it works to reproduce the scenario step by step.

한 번에 하나의 입력을 조정하여 민감도를 확인하세요. CSV to 금융 JSON 변환기은(는) 즉시 업데이트되므로 행동하기 전에 낙관적 및 보수적 가정을 스트레스 테스트할 수 있습니다.

이 계산기를 사용할 때

Reach for CSV to Financial JSON Converter when normalize broker csv exports into json arrays.. It suits quick what if analysis before trades, allocation changes, or plan updates.

결정이 세금, 유동성 또는 하나의 공식이 포착하는 것 이상의 다년 전망을 포괄할 때 관련 도구와 함께 사용하세요.

흔한 실수

입력 단위나 오래된 시장 가격을 확인하지 않고 출력을 복사하는 것은 CSV to 금융 JSON 변환기에서 흔한 오류입니다. 행동하기 전에 티커, 백분율 및 날짜를 확인하세요.

단일 기준 시나리오만 실행하면 꼬리 위험을 무시합니다. 보수적 입력으로 스트레스 테스트하고 결정이 중요할 때 아래 나열된 관련 도구와 비교하세요.

공식

Delimiter detection: max split count on first line. Header normalization to lowercase alphanumeric. Column mapping via alias lookup table. Type inference by regex: date = /^\d{4}-\d{2}-\d{2}/, number = /^-?\d+(\.\d+)?$/.

Financial column aliases map common broker column names to standardized field names. Alias table covers common US broker headers. Add manual column rename in your spreadsheet for exotic export formats. Re-parse after editing CSV headers in spreadsheet for one time broker format fixes. Alias table covers common US broker headers. Add manual column rename in your spreadsheet for exotic export formats. Prices not validated against market data: typos in CSV propagate to JSON without automatic correction. Alias table covers common US broker headers. Add manual column rename in your spreadsheet for exotic export formats. Prices not validated against market data: typos in CSV propagate to JSON without automatic correction. Alias table covers common US broker headers. Add manual column rename in your spreadsheet for exotic export formats.

제한 사항 및 가정

주요 용어

How does delimiter and column detection work: The tool detects delimiters (comma, semicolon, tab, pipe) by counting which character produces the most columns in the first line.
What column types are auto detected: Date: YYYY-MM-DD or MM/DD/YYYY patterns.
모델 가정: Known aliases include: date (Date, Trade Date), symbol (Ticker, Instrument), type (Action, Transaction Type), quantity (Qty, Shares), price (Unit Price, Rate), amount (Total, Value, Proceeds).

대안 비교

Explore more free calculators on portfolios. Use those calculators when csv to financial json converter alone does not capture the full decision.

portfolios.tools의 내부 링크는 계산기 체인을 도와줍니다: 먼저 CSV to 금융 JSON 변환기을(를) 실행한 다음, 아래 관련 섹션의 전문 도구로 엣지 케이스를 검증하세요.

FAQ

How does delimiter and column detection work?

The tool detects delimiters (comma, semicolon, tab, pipe) by counting which character produces the most columns in the first line. Headers are normalized and matched against known financial column aliases. Tab separated exports from European brokers and comma separated US exports both work. The detector picks the delimiter with the most consistent column count. UTF-8 encoding preserves international symbols. Re-export with UTF-8 if accented characters garble. Tab separated exports from European brokers and comma separated US exports both work. The detector picks the delimiter with the most consistent column count. Split corporate actions may need manual adjustment: parser flags suspicious quantity jumps for review. Tab separated exports from European brokers and comma separated US exports both work. The detector picks the delimiter with the most consistent column count. Split corporate actions may need manual adjustment: parser flags suspicious quantity jumps for review. Tab separated exports from European brokers and comma separated US exports both work. The detector picks the delimiter with the most consistent column count.

What column types are auto detected?

Date: YYYY-MM-DD or MM/DD/YYYY patterns. Number: matches numeric patterns with optional decimal. String: everything else. Type inference uses the first data row as a sample. Mixed columns like Description with embedded symbols may map as strings. Review the type column and adjust source CSV headers if needed. Currency columns with dollar signs strip to numbers automatically when formatted as 1,234.56. Mixed columns like Description with embedded symbols may map as strings. Review the type column and adjust source CSV headers if needed.

Which column names are automatically mapped?

Known aliases include: date (Date, Trade Date), symbol (Ticker, Instrument), type (Action, Transaction Type), quantity (Qty, Shares), price (Unit Price, Rate), amount (Total, Value, Proceeds). Dividend, buy, sell, transfer, and fee actions map when headers match common aliases. Rename nonstandard headers before paste for best results. Reverse chronological exports parse correctly because detection uses header row not sort order. Dividend, buy, sell, transfer, and fee actions map when headers match common aliases. Rename nonstandard headers before paste for best results.

Does it work with any broker CSV export?

Broker specific export formats with quoted fields and mixed delimiters are supported by the quote stripping and delimiter auto detection. Not all formats guaranteed. Multi account exports with account ID columns are supported as extra fields. Split files by account if you need separate JSON per portfolio. Options assignment rows map when Action column includes Assigned or Expired keywords. Multi account exports with account ID columns are supported as extra fields. Split files by account if you need separate JSON per portfolio. UTF8 with BOM from Excel is handled: save as CSV UTF8 if accented broker names break parsing. Multi account exports with account ID columns are supported as extra fields. Split files by account if you need separate JSON per portfolio. UTF8 with BOM from Excel is handled: save as CSV UTF8 if accented broker names break parsing. Multi account exports with account ID columns are supported as extra fields. Split files by account if you need separate JSON per portfolio.

Is my CSV data private?

All processing runs in your browser. Your CSV data is never sent to a server. The parsed JSON result stays on your device. Your sensitive transaction data remains under your control at all times. Processing is local only. Sensitive transaction history never uploads to a server, suitable for confidential account data. Copy JSON directly into developer tools or Jupyter notebook for immediate analysis without saving files. Processing is local only. Sensitive transaction history never uploads to a server, suitable for confidential account data. Output JSON feeds portfolio trackers and tax lot importers: validate against schema before production import. Processing is local only. Sensitive transaction history never uploads to a server, suitable for confidential account data. Output JSON feeds portfolio trackers and tax lot importers: validate against schema before production import. Processing is local only. Sensitive transaction history never uploads to a server, suitable for confidential account data.

휴대폰이나 태블릿에서 CSV to 금융 JSON 변환기을(를) 사용할 수 있나요?

예. 이 도구는 데스크톱과 동일한 공식으로 모바일 브라우저에서 완전히 실행됩니다. 선택적 localStorage는 브라우저 설정에서 활성화된 경우 기기에 입력값을 기억할 수 있습니다.

CSV to 금융 JSON 변환기을(를) 사용할 때 내 데이터는 어디에 저장되나요?

당사 서버 어디에도 없습니다. 계산은 브라우저에서 로컬로 실행됩니다. 선택적 localStorage는 기기에서만 양식 필드를 저장하며 네트워크를 통해 포트폴리오 번호를 전송하지 않습니다.

세금 또는 법적 결정에 CSV to 금융 JSON 변환기에 의존해야 하나요?

아니요. 이 도구는 교육용 수학만 제공합니다. 세법, 계좌 규칙 및 개인 상황은 다양합니다. 중대한 결과를 초래하는 거래 전에 자격을 갖춘 세무 또는 법률 전문가와 상담하세요.