Lemora › Guides

Turn spreadsheet rows into JSON records on Mac

A spreadsheet export can become a list of JSON records when its first row contains field names. Lemora uses those headings as keys and writes the remaining rows as objects. Review the keys and value types before feeding the result to code or an import service.

Choose the action and check the result

  1. Prepare a table with clear, unique headers in the first row.
  2. Select the spreadsheet, press Shift-Command-E and choose JSON on Convert.
  3. Open the result in a JSON editor and compare sample records with the source rows.
  4. Validate the keys and types against the consuming application's requirements.

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 JSON

A list of records for code and APIs, numbers kept as numbers.

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

Headers become field names

Blank headings receive generated Column names. Duplicate headings can make the output ambiguous for a consumer, so clean them in a source copy first. Conversion does not validate a particular API schema.

Column contents influence numeric output

A column is written numerically when its nonempty values are plain numbers; otherwise its values remain text. Empty cells become null. Inspect identifiers and codes even when they look numeric: their meaning may require strings.

This is a flat table export

The action does not infer nested objects, relationships or a custom schema from column names. A column called address.city does not by itself establish the nested structure an API might expect. Prepare that structure separately if necessary.

Questions

Does this upload records to an API?

No. It writes local JSON files.

Can I recover the entire workbook from the JSON?

Do not treat a record export as a workbook backup. Keep the spreadsheet for its original structure and 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