Excel to TOML Converter

Excel to TOML Converter Guide

This Excel to TOML converter turns spreadsheet rows into structured TOML configuration format. It is ideal when you manage settings, environments, or content in Excel and want to generate valid .toml files for applications that use TOML.

Key Features

• Excel file support: Upload .xlsx or .xls files from Excel, Google Sheets, or LibreOffice.
• TOML array of tables: Each row becomes a [[data]] table with key–value pairs.
• Header‑based keys: When headers are enabled, column names are transformed into TOML keys.
• Key sanitization: Column names are converted to safe, lower‑case snake_case keys for TOML.
• Type‑aware formatting: Strings, numbers, booleans, and dates are formatted appropriately for TOML.
• Metadata section: Automatically appends a [metadata] table describing the source file, sheet, and counts.
• Copy & download: Copy the TOML configuration or download it as a .toml file.

How to Convert Excel to TOML Configuration

1. Upload your Excel file: Drag and drop a .xlsx / .xls file or click the upload box to choose one.
2. Choose header behavior: Enable “First row is header” if the first row contains column names you want to use as TOML keys.
3. Automatic conversion: The tool reads the first sheet, builds a [[data]] table for every row, and formats each cell as a TOML value.
4. Review the TOML output: Check the generated [[data]] entries and the [metadata] block.
5. Copy or download: Copy the TOML to your clipboard or download it as output.toml for direct use in your application.

Example: Excel to TOML

Consider an Excel sheet with:

• Row 1 (headers): Environment, URL, Enabled
• Row 2: production, https://api.example.com, true
• Row 3: staging, https://staging.example.com, false

The generated TOML might look like:

• [[data]]
• environment = "production"
• url = "https://api.example.com"
• enabled = true
• [[data]]
• environment = "staging"
• url = "https://staging.example.com"
• enabled = false

You can drop this TOML directly into a config file used by Rust, Go, Node.js, or any other TOML‑aware application.

Common Use Cases

• Application configuration: Maintain app settings in Excel and export them to TOML for production or staging.
• Feature flags: Build a spreadsheet of flags and convert it into a TOML config consumed by your app.
• Content configuration: Define site sections, navigation, or metadata in Excel and move them into TOML‑based static site generators.
• Data exchange: Share structured data in a human‑readable TOML format instead of raw spreadsheets.

Benefits of This Excel to TOML Tool

• No manual editing: Avoid hand‑crafting TOML files from spreadsheets.
• Consistent keys: Automatic key sanitization keeps your configuration tidy and predictable.
• Type‑safe formatting: Numbers, booleans, and strings are formatted as valid TOML values.
• Free, instant, and in‑browser: Convert Excel to TOML without installing extra software.

FAQ

Which Excel formats can I upload?

The tool supports both .xlsx and .xls files. Export from Google Sheets or other tools as Excel to convert.

How are TOML keys generated from column names?

Column headers are lower‑cased and converted to snake_case. Special characters are removed or replaced with underscores so the final keys are TOML‑friendly.

How are values formatted in the TOML output?

Strings are wrapped in quotes and escaped, numbers are left as numeric literals, and booleans use true / false. Dates are converted to ISO strings.

Is my spreadsheet data uploaded to a server?

No. All Excel to TOML conversion happens locally in your browser. Nothing is sent to a backend service, which keeps your configuration private.

Can I merge the generated TOML into an existing config file?

Yes. You can copy individual [[data]] tables or move keys into other TOML sections depending on how your application reads configuration.