Lemora › Guides

Export spreadsheet data as XLSX, CSV, TSV or ODS on Mac

Start with the receiving system's requirements. XLSX and ODS are workbook formats, while CSV and TSV are single-table text formats. Lemora can create these copies, but the right choice depends on whether you need multiple sheets, formatting or a simple data import.

Choose the action and check the result

  1. Select the spreadsheet in Finder and open Lemora with Shift-Command-E.
  2. Choose XLSX, CSV, TSV or ODS on the Convert page.
  3. For a multi-sheet CSV or TSV export, inspect the output folder containing one file per sheet.
  4. Open a result in the destination app and verify headers, dates, identifiers and row counts.

Results are saved beside the originals when folder access is available, or in Downloads/Lemora otherwise. Source files are never overwritten.

Where to find these actions

What you get

Convert to Excel

An Excel workbook. Every sheet is kept; numbers stay numbers.

Works with: Files recognized by the actions listed below. Availability depends on the source format and the selected files.

Workbooks and delimited text retain different things

Use a workbook format when the recipient needs worksheets and workbook presentation. CSV and TSV carry values in a text table rather than a complete spreadsheet project. They are not a backup for charts, formatting or working formulas.

One worksheet becomes one text file

A CSV or TSV cannot represent a whole multi-sheet workbook as separate tabs. Lemora writes individual files when the source contains several sheets. Check filenames before importing so that you choose the intended table.

Check interpretation in the receiving application

Dates, leading zeroes and long identifiers can be interpreted differently during import. Inspect a few important records before processing the whole dataset. A table that opens without an error can still have values displayed or typed in an unintended way.

Questions

Which delimiter should I choose?

Use the format the receiving importer specifies: CSV for comma-separated data or TSV for tab-separated data.

Will CSV preserve my workbook formatting?

No. Keep the original workbook for formatting and other spreadsheet features.

Try this workflow on your Mac

Download Lemora on the Mac App Store Free to try: every feature for your first 25 actions. macOS 15 or later.

More guides