CSVSwap

Free CSV, Excel and JSON converters

Convert and clean spreadsheet data in your browser. No sign-up, no upload: your files never leave your computer.

CSV to JSONTurn a CSV file into a JSON array of objects, one object per row, using the header row as keys.JSON to CSVConvert a JSON array of objects into a CSV file you can open in Excel or Google Sheets. Nested objects are flattened into dotted column names.CSV to ExcelConvert a CSV file to an Excel .xlsx workbook in one click, keeping every column and row.Excel to CSVConvert the first sheet of an Excel workbook (.xlsx, .xls or .ods) into a clean CSV file.JSON to ExcelTurn JSON data into an Excel spreadsheet, with nested fields flattened into their own columns.Excel to JSONConvert an Excel sheet into a JSON array, using the first row as property names.CSV to Markdown TableTurn CSV data into a Markdown table for GitHub, README files, Notion, Obsidian and documentation.CSV to SQLGenerate a CREATE TABLE statement and INSERT statements from a CSV file.CSV to XMLConvert CSV rows into a simple, well-formed XML document.CSV to HTML TableMake an HTML table from CSV data, ready to paste into a web page or email template.JSON to YAMLConvert a JSON list of records into YAML for config files, Kubernetes and Ansible.YAML to JSONConvert a YAML list of records into a JSON array.CSV CleanerTrim stray spaces, remove empty rows and delete duplicate rows from a CSV file.Split CSVSplit a large CSV file into smaller files with a set number of rows each. Every file keeps the header row.Merge CSV FilesCombine several CSV files into one, matching columns by header name.TSV to CSVConvert tab-separated values into a comma-separated CSV file, or pick another delimiter.XML to CSVConvert repeating XML records into a CSV table. Child elements and attributes become columns.XML to JSONTurn repeating XML records into a JSON array of objects.HTML Table to CSVExtract a table from HTML and save it as CSV. Paste the page source or just the table markup.HTML Table to ExcelCopy a table out of a web page into an Excel spreadsheet without retyping it.Markdown Table to CSVConvert a Markdown table from a README, wiki or chat into CSV for a spreadsheet.Transpose CSVSwap rows and columns in a CSV file, so each column becomes a row.Sort CSVSort the rows of a CSV file by any column, A to Z or largest to smallest.CSV Column ExtractorKeep only the columns you need from a CSV file, or remove the ones you do not.Remove Duplicates by ColumnRemove rows that repeat a value in one column, such as duplicate email addresses, keeping the first one.

Free data

US private foundations by stateEvery US private foundation in IRS data, with the largest funders in each stateUS churches by stateEvery organization the IRS lists as a church, with denominations and citiesUS nonprofits with $1M+ revenue by statePublic charities with $1 million or more in revenue, with the largest in each stateUS nursing homes by stateEvery Medicare and Medicaid certified nursing home, with phone numbers, beds and star ratingsUS hospitals by stateEvery hospital in Medicare data, with phone numbers, type and star ratingUS home health agencies by stateEvery Medicare-certified home health agency, with phone numbers and servicesUS public schools by stateEvery open public school, with phone numbers, district and enrollmentUS private schools by stateEvery private school in the federal survey, with phone numbers, religious orientation and enrollmentUS banks and credit unions by stateEvery insured bank and credit union, with assets, websites and credit union phone numbersUS hospices by stateEvery Medicare-certified hospice, with phone numbers and ownership