# Spreadsheet tools

- Human page: https://happytails.ai/en/spreadsheet-tools/
- Markdown: https://happytails.ai/en/spreadsheet-tools.md
- Structured JSON: https://happytails.ai/agents/en/spreadsheet-tools/index.json
- Visibility: public

## Page guide

Find the tool you need, then open it to get started.

## All spreadsheet tools

- [Compare CSV](https://happytails.ai/en/spreadsheet-tools/compare-csv/): Keyed row diff versus position diff. ([Markdown](https://happytails.ai/en/spreadsheet-tools/compare-csv.md))

- [CSV join](https://happytails.ai/en/spreadsheet-tools/csv-join/): Inner/left/full joins on explicit keys. ([Markdown](https://happytails.ai/en/spreadsheet-tools/csv-join.md))

- [CSV pivot](https://happytails.ai/en/spreadsheet-tools/csv-pivot/): Row/column groups, counts/sums, blank handling and export. ([Markdown](https://happytails.ai/en/spreadsheet-tools/csv-pivot.md))

- [Excel to HTML](https://happytails.ai/en/spreadsheet-tools/excel-to-html/): Sheet and range choice. ([Markdown](https://happytails.ai/en/spreadsheet-tools/excel-to-html.md))

- [Merge CSV](https://happytails.ai/en/spreadsheet-tools/merge-csv/): Append with header alignment. ([Markdown](https://happytails.ai/en/spreadsheet-tools/merge-csv.md))

- [Ods to XLSX](https://happytails.ai/en/spreadsheet-tools/ods-to-xlsx/): Test formulas, dates and styles. ([Markdown](https://happytails.ai/en/spreadsheet-tools/ods-to-xlsx.md))

- [Split excel](https://happytails.ai/en/spreadsheet-tools/split-excel/): Split sheets or rows. ([Markdown](https://happytails.ai/en/spreadsheet-tools/split-excel.md))

- [XLSX viewer](https://happytails.ai/en/spreadsheet-tools/xlsx-viewer/): Open an Excel or OpenDocument worksheet as a readable table. ([Markdown](https://happytails.ai/en/spreadsheet-tools/xlsx-viewer.md))

## Protect values as well as visible cell formatting

Spreadsheet tasks involve values, formulas, data types and presentation. A conversion may preserve the displayed value without preserving the formula that produced it. Identifiers, dates and locale-specific decimal separators deserve special attention.

## How to choose your next step

Choose the intended sheet and inspect headers, blank rows and a sample of formulas. State which columns should remain text before importing into another spreadsheet.

## Common questions about spreadsheet tools

### Why do identifiers lose leading zeros?

A spreadsheet can interpret a text identifier as a number. Once 00123 is treated as 123, formatting may be needed to display zeros again. Preserve the original value as text when its exact representation matters.

### Does CSV keep formulas and multiple sheets?

CSV represents one flat table. It does not retain a workbook’s sheets, formatting or full formula behavior. Treat it as an exchange format for values and review how the receiving application interprets them.