CSV Import and Export

OpenSheets supports importing and exporting data in CSV (Comma-Separated Values) format through the Import/Export Manager.

Importing CSV

CSV files can be imported using the general Import/Export Manager dialog:

1. Open File > Import/Export and go to the Import tab.
2. Drag and drop a .csv file or click the drop zone to browse.
3. The format auto-detector recognizes CSV/TSV files. You can also manually select TSV (tab-separated) if needed.
4. Configure the target sheet (current or new), starting cell, and header row option.
5. Review the preview and click Import.

OpenSheets parses CSV with proper handling of:

• Quoted fields containing commas, newlines, or double quotes.
• Escaped double quotes ("" within quoted fields).
• Mixed line endings (CRLF and LF).

Exporting CSV

1. Open File > Import/Export and go to the Export tab.
2. Select CSV from the format chips.
3. Choose the scope: current sheet, selected range, or all sheets.
4. Optionally enable Include formulas to export raw formulas instead of computed values.
5. Click Export / Download to save the file.

The exported CSV properly quotes fields that contain the delimiter, double quotes, or newline characters.

Clipboard

You can also paste tab-separated data directly from other spreadsheet applications into the grid. OpenSheets automatically parses pasted TSV content into cells.