개념 및 지식 허브
Excel/CSV 스프레드시트에서 JSON, HTML 및 PDF 변환기
Excel/CSV 스프레드시트에서 JSON, HTML 및 PDF 변환기
본 도구는 100% 클라이언트 환경(브라우저)에서 작동합니다. 소스 코드, 토큰, 기밀 데이터가 외부 서버로 절대 전송되지 않습니다.
핵심 아키텍처 및 수학 공식
File Buffer (.xlsx) ➔ Binary Parsing ➔ Worksheet Extraction ➔ JSON Array Matrix
The parser unzips the XLSX archive, reads the internal XML mapping relationships, extracts the specific worksheet grid, and maps the top row as the structural keys for the JSON objects.
모범 사례 및 필수 지침
- Clean Your Top Row Headers: The converter uses row 1 as the JSON keys. Ensure row 1 does not contain merged cells, empty gaps, or duplicate names. Use strict camelCase (e.g., `firstName`) for developer friendly output.
- Remove Hidden Metadata: Excel files often contain hidden sheets, massive blank columns, and macro metadata. Highlight and delete all unused columns to dramatically reduce the JSON output payload size.
- Format Dates as Text Before Export: Excel handles dates bizarrely (as the number of days since Jan 1, 1900). To prevent the JSON from outputting raw integers like `44197`, explicitly format your date columns as 'Text' (YYYY-MM-DD) inside Excel before converting.
자주 묻는 질문 (FAQ)
Why is the converter outputting an empty file?
You likely have the wrong worksheet selected. An Excel workbook can contain dozens of tabs. Ensure you specify exactly which sheet (e.g., 'Sheet1') you want to extract.
Are my formulas preserved in the JSON?
No. The converter extracts the final computed *value* of the cell (e.g., '150'), not the mathematical formula (e.g., '=SUM(A1:A5)'). All Excel logic is permanently lost during the conversion to flat JSON.
Is it safe to convert payroll data here?
Absolutely. Because the binary parsing engine runs locally via WebAssembly/JavaScript, your spreadsheet never leaves your computer. The conversion happens instantly in your RAM.