Staaarter

INI to CSV Converter

Parses INI [section] blocks into CSV rows, with the section name as the first column and the union of every key= name seen across all sections as the remaining columns. A free online tool from Staaarter, right in your browser.

Runs locallyUpdated 2026-07-29
By Staaarter Team
conversionconfigini

Overview

Introduction

INI config files are easy to hand-edit but awkward to analyze in bulk. This tool flattens every [section] block into a CSV row so you can open a config file in a spreadsheet.

It automatically figures out the full set of keys across every section, even if different sections define different keys, so no column is ever silently dropped.

What Is INI to CSV Converter?

An INI-to-CSV converter that reads every [section] block in an INI file and turns it into one CSV row, with the section name as the first column and every key= value found anywhere in the file as the remaining columns.

It's the reverse of CSV to INI Converter, reconstructing the same section-per-row shape that tool produces.

How INI to CSV Converter Works

The input is scanned line by line: a `[section]` line starts a new section, a `key=value` line records that key under the current section, and comment (;, #) and blank lines are skipped.

Once every section is read, the union of every distinct key name seen (in first-seen order) becomes the CSV header after 'section'; each section's row fills in the values it has and leaves the rest blank.

When To Use INI to CSV Converter

Use it when you need to review, filter, or bulk-edit a large INI config file's sections in a spreadsheet instead of a text editor.

It's also useful for spotting which sections are missing a key that most others define, since the union header makes gaps visible as empty cells.

Often used alongside CSV to INI Converter, SQL INSERT to CSV Converter and vCard to CSV Converter.

Features

Advantages

  • Handles sections with inconsistent keys gracefully, filling in blanks rather than misaligning columns.
  • Skips comments and blank lines automatically, so a well-commented config file still parses cleanly.
  • Runs entirely client-side, so config data never leaves your browser.

Limitations

  • Content before the first [section] header is discarded, since it doesn't belong to any section.
  • If the same key appears more than once within a single section, only the last value for that key is kept.

Examples

Converting INI sections to CSV

Input

[web1]
host=10.0.0.1
port=8080

[web2]
host=10.0.0.2
port=8081
region=us-east

Output

section,host,port,region
web1,10.0.0.1,8080,
web2,10.0.0.2,8081,us-east

web1 has no 'region' key, so its cell in that column is left empty in the resulting CSV.

Best Practices & Notes

Best Practices

  • Check for a mostly-empty column in the output; it usually means only one or two sections define that key, which is worth confirming is intentional.
  • Remove or comment out any stray key=value lines before the first section header, since they're silently dropped anyway.
  • Use CSV to INI Converter afterward to confirm a round trip reproduces the same sections and keys.

Developer Notes

Key order in the header is tracked as keys are first encountered while scanning sections top-to-bottom, rather than sorted alphabetically, so the resulting CSV's column order roughly mirrors the original file's structure instead of being rearranged.

INI to CSV Converter Use Cases

  • Reviewing or bulk-editing a large INI config file's sections in a spreadsheet
  • Auditing which sections are missing a key that most others define
  • Migrating settings out of a legacy INI-based config format into a data pipeline that expects CSV

Common Mistakes

  • Expecting key=value lines written before the first [section] header to show up somewhere; they're discarded since they have no section to belong to.
  • Assuming a repeated key within one section keeps all its values; only the last one for that key in that section is kept.

Tips

  • If a column is unexpectedly empty for most rows, double check the key spelling is consistent (case-sensitive) across every section.
  • Pair with CSV to INI Converter to verify the round trip preserves every section and key you expect.

References

Frequently Asked Questions