# YAML to INI Data Format Converter Convert YAML to INI in one step. Paste or upload your YAML data and the converter parses it, keeps nested structures where INI can hold them, flattens them into dotted keys where it cannot and returns INI ready to copy or download. Built for developers and analysts who move configuration and tabular data between tools, with no sign-up and nothing stored. ## Frequently asked questions ### Which formats can I convert between? The converter reads and writes JSON, JSON Lines, YAML, TOML, XML, CSV, TSV, INI, Java properties, Excel XLSX and OpenDocument ODS, and any of them can be converted into any other. Pick the source format in From and the target in To. For JSON and YAML, CSV to JSON, JSON to CSV, JSON to XML and XML to JSON the site also has dedicated tools with extra options. ### How do I convert an Excel or ODS spreadsheet? Choose XLSX or ODS as the source format and upload the workbook instead of pasting text. The converter reads the first sheet, or the sheet you name in the Sheet name field, treats its first row as column headers and turns every following row into a record. Formulas are read as their last calculated values and date cells become ISO 8601 strings. ### How does nested data become CSV, TSV, INI or properties? These formats cannot hold nested structures, so nested objects are flattened into dotted keys and array items get their index in brackets. For example {"user": {"name": "Ada", "tags": ["x"]}} becomes the keys user.name and user.tags[0]. Reading properties back nests the dotted keys again when they do not conflict, while CSV and TSV headers are kept exactly as written. ### How does the converter decide what a row is? When the target is CSV, TSV, XLSX or ODS, a top-level array becomes the rows. An object that only wraps one array, such as {"users": [...]} or an XML document of repeated row elements, is unwrapped to that array, and anything else becomes a single row. The columns are the union of all keys in the order they first appear, and missing values stay empty. ### Are numbers and booleans preserved? JSON, JSON Lines, YAML and TOML keep their numbers, booleans and null values, and spreadsheet cells keep numbers and booleans. CSV, TSV, INI, properties and XML have no types, so their values are read as text and stay text in the result. TOML integers too large for a JavaScript number are kept as text so no digits are lost. ### How is XML mapped to other formats? Each element becomes a key, repeated elements become arrays, attributes become keys starting with @ and text beside attributes is stored under #text. When writing XML, an object with a single top-level key uses that key as the root element, everything else is wrapped in a root element and array items are written as row elements. Characters that are not allowed in element names are replaced with underscores, and documents that declare entities are rejected for safety. ### What happens to values TOML cannot store? TOML has no null value, so keys holding null are left out and null items inside arrays become empty strings. TOML also needs a table at the top level, so a top-level array is written as an array of tables named rows and a single value as a key named value. Dates read from TOML are written to other formats as ISO 8601 strings. ### How are INI files and Java properties read? INI sections become objects, key[] lines collect values into a list, lines starting with ; or # are comments and double-quoted values may use escapes such as \n. Properties follow the Java rules: =, : or whitespace separate key and value, lines starting with # or an exclamation mark are comments, a trailing backslash continues the line and \uXXXX escapes are decoded. Written properties are plain UTF-8, which Java 9 and later read in resource bundles. ### How are JSON Lines and multi-document YAML handled? JSON Lines input is read line by line, blank lines are skipped and the values form an array, while JSON Lines output writes each array item as one compact JSON value per line. YAML input with several documents separated by --- becomes an array with one entry per document. Invalid YAML, TOML and XML report the line and column where parsing stopped, and invalid JSON Lines report the line. ### What are the limits, and is my data stored? Text and files can be up to 5 MiB, with at most 100,000 rows, 1,000,000 cells, 64 levels of nesting, 50 MiB of unpacked workbook content and 16 MiB of result. Larger inputs are rejected with a message instead of being cut off. Your data is converted in memory for the request and is not stored. ## Related tools ### [Data Format Converter](https://oneclick.pro/tool/data-format-converter/) Convert structured data between JSON, JSON Lines, YAML, TOML, XML, CSV, TSV, INI, Java properties, Excel XLSX and OpenDocument ODS. Paste text or upload a workbook, pick the source and target format, and the converter keeps nesting where the target supports it and flattens it into dotted keys where it does not. Built for developers, analysts and DevOps engineers moving configuration and tabular data between tools. ### [YAML to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/yaml-to-jsonl/) Convert YAML to JSON Lines in one step. Paste or upload your YAML data and the converter parses it, keeps nested structures where JSON Lines can hold them, flattens them into dotted keys where it cannot and returns JSON Lines ready to copy or download. Built for developers and analysts who move configuration and tabular data between tools, with no sign-up and nothing stored. ### [YAML to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/yaml-to-toml/) Convert YAML to TOML in one step. Paste or upload your YAML data and the converter parses it, keeps nested structures where TOML can hold them, flattens them into dotted keys where it cannot and returns TOML ready to copy or download. Built for developers and analysts who move configuration and tabular data between tools, with no sign-up and nothing stored. ### [YAML to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/yaml-to-xml/) Convert YAML to XML in one step. Paste or upload your YAML data and the converter parses it, keeps nested structures where XML can hold them, flattens them into dotted keys where it cannot and returns XML ready to copy or download. Built for developers and analysts who move configuration and tabular data between tools, with no sign-up and nothing stored. ### [YAML to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/yaml-to-csv/) Convert YAML to CSV in one step. Paste or upload your YAML data and the converter parses it, keeps nested structures where CSV can hold them, flattens them into dotted keys where it cannot and returns CSV ready to copy or download. Built for developers and analysts who move configuration and tabular data between tools, with no sign-up and nothing stored. ### [YAML to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/yaml-to-tsv/) Convert YAML to TSV in one step. Paste or upload your YAML data and the converter parses it, keeps nested structures where TSV can hold them, flattens them into dotted keys where it cannot and returns TSV ready to copy or download. Built for developers and analysts who move configuration and tabular data between tools, with no sign-up and nothing stored. **Show all 104 related tools** - [YAML to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/yaml-to-properties/) - [YAML to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/yaml-to-xlsx/) - [YAML to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/yaml-to-ods/) - [JSON to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/json-to-ini/) - [JSON Lines to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-ini/) - [TOML to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-ini/) - [XML to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-ini/) - [CSV to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-ini/) - [TSV to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-ini/) - [Properties to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-ini/) - [XLSX to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-ini/) - [ODS to INI Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-ini/) - [JSON to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/json-to-jsonl/) - [JSON to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/json-to-toml/) - [JSON to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/json-to-tsv/) - [JSON to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/json-to-properties/) - [JSON to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/json-to-xlsx/) - [JSON to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/json-to-ods/) - [JSON Lines to JSON Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-json/) - [JSON Lines to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-yaml/) - [JSON Lines to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-toml/) - [JSON Lines to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-xml/) - [JSON Lines to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-csv/) - [JSON Lines to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-tsv/) - [JSON Lines to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-properties/) - [JSON Lines to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-xlsx/) - [JSON Lines to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/jsonl-to-ods/) - [TOML to JSON Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-json/) - [TOML to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-jsonl/) - [TOML to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-yaml/) - [TOML to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-xml/) - [TOML to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-csv/) - [TOML to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-tsv/) - [TOML to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-properties/) - [TOML to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-xlsx/) - [TOML to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/toml-to-ods/) - [XML to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-jsonl/) - [XML to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-yaml/) - [XML to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-toml/) - [XML to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-csv/) - [XML to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-tsv/) - [XML to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-properties/) - [XML to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-xlsx/) - [XML to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/xml-to-ods/) - [CSV to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-jsonl/) - [CSV to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-yaml/) - [CSV to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-toml/) - [CSV to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-xml/) - [CSV to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-tsv/) - [CSV to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-properties/) - [CSV to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-xlsx/) - [CSV to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/csv-to-ods/) - [TSV to JSON Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-json/) - [TSV to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-jsonl/) - [TSV to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-yaml/) - [TSV to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-toml/) - [TSV to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-xml/) - [TSV to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-csv/) - [TSV to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-properties/) - [TSV to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-xlsx/) - [TSV to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/tsv-to-ods/) - [INI to JSON Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-json/) - [INI to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-jsonl/) - [INI to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-yaml/) - [INI to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-toml/) - [INI to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-xml/) - [INI to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-csv/) - [INI to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-tsv/) - [INI to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-properties/) - [INI to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-xlsx/) - [INI to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/ini-to-ods/) - [Properties to JSON Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-json/) - [Properties to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-jsonl/) - [Properties to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-yaml/) - [Properties to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-toml/) - [Properties to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-xml/) - [Properties to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-csv/) - [Properties to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-tsv/) - [Properties to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-xlsx/) - [Properties to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/properties-to-ods/) - [XLSX to JSON Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-json/) - [XLSX to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-jsonl/) - [XLSX to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-yaml/) - [XLSX to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-toml/) - [XLSX to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-xml/) - [XLSX to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-csv/) - [XLSX to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-tsv/) - [XLSX to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-properties/) - [XLSX to ODS Data Format Converter](https://oneclick.pro/tool/data-format-converter/xlsx-to-ods/) - [ODS to JSON Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-json/) - [ODS to JSON Lines Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-jsonl/) - [ODS to YAML Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-yaml/) - [ODS to TOML Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-toml/) - [ODS to XML Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-xml/) - [ODS to CSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-csv/) - [ODS to TSV Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-tsv/) - [ODS to Properties Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-properties/) - [ODS to XLSX Data Format Converter](https://oneclick.pro/tool/data-format-converter/ods-to-xlsx/) Your ad here? [Email us](mailto:hi@dennn.is?subject=Advertising%20on%20OneClick%20Pro) [Ad The agent-ready plugin suite for WordPress.](https://sleekwp.com/?ref=oneclickpro)