Convert CSV
Convert CSV Online is a free browser-based hub for converting, editing, and cleaning structured data. Whether you need to turn a JSON API response into a spreadsheet, flatten an HTML pricing table into rows, open a bank OFX export as CSV, or tidy a messy XLSX file before sharing it, the site gives you focused tools that run in your browser — no account, no install, and no upload of your file contents to a conversion server.
The homepage is the starting point for dozens of single-purpose converters and two interactive spreadsheet editors. Each converter page accepts one input format and produces one output format, so you always know what to paste, what you will get, and how to verify the result before you download. The Online CSV Editor and Online XLSX Editor open your file in a grid where you can format cells, filter rows, and fix values by hand before exporting.
This guide explains how the hub is organized, which formats are covered (CSV, JSON, XML, YAML, SQL, HTML, GeoJSON, KML, fixed-width text, Excel, and common finance file types), how client-side processing protects privacy, how to find the right tool quickly, and when to choose an editor instead of a converter. Use it as a map of the product rather than a substitute for the dedicated guide on each converter page.
Key features
- A homepage hub plus searchable tools directory covering spreadsheet editors and format converters in one place.
- Client-side processing: file contents are parsed and transformed in your browser and are not uploaded to a server as part of conversion or editing.
- No account or sign-up required for everyday use — open a page, paste or upload, preview, download.
- Dedicated converters for CSV, JSON, XML, YAML, SQL, HTML tables and links, GeoJSON, KML, fixed-width text, Excel, Markdown, PDF, Word-oriented exports, and finance formats such as OFX and QFX.
- Interactive Online CSV Editor and Online XLSX Editor with formatting, borders, filters, find, and export back to CSV or XLSX.
- Category grouping (Spreadsheet, Data Converter, Finance, Developer) so you can browse by job rather than by alphabet.
- Guide-length articles on each tool page for delimiters, nesting, encoding, and common failure modes.
- Free for typical personal and team conversions, supported by advertising on the site.
About the CSV, JSON, XML, SQL, KML, HTML, Excel and spreadsheet data to CSV and Excel format
Convert CSV Online is built around tabular and structured-text formats that people actually exchange day to day. Spreadsheet formats include CSV and XLSX. Developer and data-interchange formats include JSON, XML, YAML, SQL INSERT statements, GeoJSON, and KML. Document and web formats include HTML tables, HTML link lists, Markdown tables, PDF, and Word-oriented exports. Legacy and niche tabular formats include fixed-width text and delimiter variants. Finance-oriented converters cover OFX, QFX, QIF, IIF, and similar bank or accounting exports that often need to become CSV for reconciliation.
Every converter is a dedicated page rather than one mega-form with dozens of options. That design keeps expectations clear: open JSON to CSV when you have JSON, open CSV to YAML when you need YAML, and so on. The homepage and tools directory group those pages by category — Spreadsheet, Data Converter, Finance, Developer — so you can browse by use case instead of memorizing URLs.
Because processing happens in the browser with JavaScript, the workable file size is limited by your device memory and the browser tab, not by a server quota. The spreadsheet editors explicitly cap uploads around 5 MB. Converter pages often tolerate somewhat larger pastes, but very large files can still slow or crash the tab. For interactive cleanup and everyday conversions, that trade-off is intentional: your data stays on your machine.
How it works
Convert CSV Online is organized as a collection of focused pages rather than one do-everything widget. The homepage introduces the product, highlights the editors, and points you into the tools directory. Each converter page loads a small client-side pipeline: read paste or file bytes in the browser, parse the source format, map records into the target shape, render a preview, and offer copy or download.
The spreadsheet editors follow a different path. After you upload CSV or XLSX (within the size cap), the page builds an in-memory grid, optionally keeps a working copy in browser local storage for the session, and exposes ribbon-style actions for formatting and review. Export writes the current grid back out as CSV or XLSX without sending the sheet to a backend for processing.
Finding a tool is intentionally simple. If you know the transformation, go straight to that URL or search the tools directory by keyword. If you only know the source format, browse the category that matches — for example Finance for OFX, Data Converter for JSON or XML, Spreadsheet for CSV and Excel editors. Related guides and FAQs on each page cover the quirks of that format so the homepage does not have to document every edge case.
Privacy follows from the architecture: conversion and edit logic run as JavaScript in your tab. The network loads the page, scripts, analytics, and ads like any normal website, but your pasted or uploaded file content is not transmitted to a conversion API as part of using the tools. See the Privacy Policy for how the website itself uses cookies and advertising.
Common use cases
- A developer receives a JSON API payload and needs a CSV the product team can open in Excel without writing a script.
- An analyst copies an HTML table from a vendor page and wants clean columns for a comparison sheet.
- A bookkeeper downloads OFX or QFX bank data and needs CSV for reconciliation in a spreadsheet.
- A student gets survey results as XML and needs rows they can sort and chart in Google Sheets.
- An operations engineer needs to convert YAML config inventories into CSV for a stakeholder review.
- A data person opens a messy CSV in the Online CSV Editor to fix headers, remove blank rows, and re-export before another conversion.
- A GIS teammate converts GeoJSON or KML attribute tables into CSV for a non-spatial reporting workflow.
- Someone without desktop Excel installed edits an XLSX file in the browser and downloads the updated workbook.
How to use this tool
- Decide whether you need to edit tabular data by hand (CSV/XLSX editor) or transform one format into another (a converter page).
- From the homepage, open a highlighted tool, or use the tools directory search with keywords like JSON, HTML, OFX, YAML, or SQL.
- Paste source text or upload a file into the tool’s input area. Prefer a small sample first when the file is large or unfamiliar.
- Review the preview: headers, row count, and a few values that contain commas, accents, or nested fields.
- Copy or download the result, then continue in Excel, Sheets, a database import, or another Convert CSV tool if you need a second hop.
- If the output is almost right but still messy, open the Online CSV Editor to clean columns before sharing or converting again.
Example
Example workflow (JSON → CSV → cleanup)
Source: API JSON array of objects
Goal: spreadsheet for a teammate
Path: JSON to CSV converter → Online CSV Editor → Download CSVWhat you get
1) Flattened CSV with one row per object
2) Optional header renames and blank-row removal in the editor
3) A downloadable .csv ready for Excel or Google SheetsTips for best results
- Start on the homepage or tools directory when you are unsure which converter to open — search by format name (JSON, OFX, HTML) rather than guessing the URL.
- Use a dedicated converter page when you already know both the input and output formats; those pages include examples and edge-case guidance for that exact transform.
- Open the Online CSV Editor or Online XLSX Editor when the problem is messy data, not format translation — clean first, convert second.
- Always preview parsed rows before downloading. Row count, headers, and a few sample values catch delimiter and nesting issues early.
- Keep the original source file. Client-side tools do not store a server-side copy for you to recover later.
- For privacy-sensitive data, prefer paste-or-upload workflows on this site over cloud converters that require an account and retain uploads.
- If Excel mangles IDs after download, treat that as a spreadsheet open issue — format columns as text or keep leading zeros as quoted strings in the source.
- Bookmark the three or four tools you use weekly; single-purpose URLs are faster than re-navigating from the homepage every time.
Common errors and how to fix them
- A file will not upload, or the editor shows a file-too-large message.
- Spreadsheet editors cap uploads at about 5 MB because parsing and editing happen in the browser. Split the file, export a subset, or use desktop spreadsheet software for oversized workbooks.
- You cannot find a converter for your format.
- Open the tools directory and search by format name, not only by marketing title. If the exact pair is missing, convert to CSV as an intermediate step, then from CSV to the final format — or clean in the CSV editor first.
- The preview looks right, but Excel or another app breaks the downloaded file.
- That is usually delimiter, encoding, or auto-format behavior in the receiving app. Import as UTF-8 text, check regional list separators, and format ID columns as text. See the CSV encoding and delimiter guides linked from related tool pages.
- Nested JSON or XML produces sparse or unexpected columns.
- Flattening hierarchical data into a table always drops or approximates some structure. Read the dedicated converter guide for that format, convert a small sample, and restructure nested arrays into one-row-per-entity JSON or XML before converting when possible.
- Edits in the spreadsheet editor disappeared after closing the tab.
- Working copies may live in browser local storage, which private mode and cleared site data remove. Download as soon as you finish; do not treat the editor as cloud storage.
- The page feels slow or the browser tab crashes on a large paste.
- Client-side conversion has no server farm behind it. Reduce the payload, convert in batches, or move heavy ETL to a scripted pipeline. Interactive tools are for everyday files, not multi-hundred-megabyte dumps.
Best practices
- Match the tool to the job: converters for format translation, editors for manual cleanup and formatting.
- Validate with a preview and a spot-check of tricky cells before you share the download widely.
- Keep originals and document assumptions (delimiter, encoding, which nested fields were flattened) when conversions feed production imports.
- Use UTF-8 source files whenever you can; re-export from the spreadsheet app if accents look garbled.
- Prefer the smallest useful sample when diagnosing a bad conversion, then scale up once the mapping is correct.
- For finance files, confirm which bank export type you have (OFX vs QFX vs QIF) before opening a converter — names look similar but parsers differ.
- When chaining tools (for example XML → CSV → Markdown), inspect the intermediate CSV so errors do not compound.
- Bookmark high-traffic pages and use the tools directory search instead of relying on memory for rarely used formats.
What Convert CSV Online is (and is not)
Convert CSV Online is a free collection of browser tools for people who need structured data in a different shape quickly — developers, analysts, students, bookkeepers, and anyone holding a file their current app cannot open usefully. The emphasis is speed, clarity, and privacy through local processing, not enterprise ETL or multi-user collaboration.
It is not a cloud drive, not a database, and not a substitute for desktop Excel when you need macros, pivots, or hundred-megabyte workbooks. Each page declares its input and output so you can reason about the transform when a column shifts or a nested field disappears.
If you need scheduled jobs or audited server-side retention of uploads, use a data platform. If you need “paste this JSON and get a CSV in ten seconds without an account,” you are in the right place.
How the homepage hub is organized
The homepage introduces the brand, the privacy posture (client-side processing, no account), and the two product lines: editors and converters. From there, the tools directory and individual converter URLs are the main workflow. Treat the homepage as a map; each tool page is the workshop.
Categories help when you only know the domain: Spreadsheet for CSV/Excel editing, Data Converter for JSON/XML/YAML/SQL/HTML/geospatial interchange, Finance for bank exports, and Developer pages for API and config formats.
Related guides cover delimiters, encodings, and Excel surprises. Tools change bytes; guides explain why spreadsheet apps sometimes reinterpret those bytes after download.
Editors versus converters
Converters are single-purpose transforms: Format A in, Format B out, with little or no cell editing. That fits clean structure that only needs a different serialization — JSON to CSV, CSV to YAML, HTML table to Excel, OFX to CSV, and similar pairs.
Editors open CSV or XLSX in a grid so you can fix typos, rename headers, delete blank rows, format cells, filter and find, then export. Use them when data needs human judgment or when spreadsheet software is not installed.
A strong workflow often combines both: convert nested formats into CSV, clean in the Online CSV Editor, then convert again — or stop at CSV/XLSX for sharing. Converters are not full spreadsheets; deep cleanup belongs in an editor.
- Choose a converter when input and output formats are clear and rows should map mechanically.
- Choose an editor when you need to inspect and change individual cells or formatting.
- Chain convert → edit → convert when hierarchy must flatten before humans can fix values.
Finding the right tool quickly
If you know both formats, open that pair directly (for example JSON to CSV). Dedicated pages are faster than browsing every category and include examples for that transform.
If you only know the source, search the tools directory by format name — it matches keywords like OFX even when you forget the exact title. If you only know the destination is CSV, browse “* to CSV” tools in the matching category.
When no exact pair exists, use CSV as a hub: source → CSV, optional edit, then CSV → target. That two-step pattern covers many combinations without waiting for a new dedicated page.
Privacy and client-side processing
Conversion and editing run in your browser. File contents are read into tab memory, transformed locally, and returned as a download or clipboard copy — not posted to a conversion backend as a required step.
That matters for HR exports, customer lists, invoices, and bank transactions that people should not upload to SaaS converters that retain files. Local processing is also why size limits exist: your device is the compute.
Client-side does not mean zero network activity. Pages, scripts, analytics, and ads still load over HTTPS. Read the Privacy Policy for cookies. Using a converter does not store your spreadsheet rows in our database for later retrieval.
CSV, Excel, and spreadsheet workflows
CSV is the lowest-common-denominator exchange format: plain text, widely supported, easy to diff — but with no types, no multiple sheets, and messy regional delimiter rules. The Online CSV Editor and CSV converters exist to produce and consume that table more safely.
XLSX fits formatting, multiple sheets, or recipients who only open Excel. Browser editors focus on tabular data; macros and embedded charts may not round-trip.
Exchange raw data as CSV when another converter is next; use XLSX when a human must read styled sheets. Convert CSV Online supports both directions.
JSON, XML, YAML, and SQL for developers
JSON is the default API shape. JSON to CSV flattens objects for spreadsheets; CSV to JSON builds arrays of objects for fixtures. Nested structures need care — flat tables cannot represent arbitrary trees without loss or conventions.
XML still appears in enterprise feeds; XML ↔ CSV helps when partners speak XML and analysis lives in Excel. YAML ↔ CSV helps non-engineers review configs and inventories.
SQL INSERT dumps become CSV for inspection; CSV becomes INSERTs for seed data. These sit beside spreadsheet tools because the same person often jumps from API JSON to CSV to SQL in one session.
HTML, documents, and publishing outputs
HTML tables trap data in web pages. HTML table to CSV/Excel extracts those grids; HTML links to CSV builds URL lists from documents.
Leaving CSV, Markdown tables, PDF, Word-oriented exports, and HTML generators target docs and reports. Verify layout on a small sample before converting thousands of rows into a heavy document.
QR codes from CSV rows support inventory labels and link batches. Like other converters, they run in the browser on that dedicated page.
Geospatial and fixed-width formats
GeoJSON and KML carry geometry and attributes. Attribute-focused CSV conversion helps analysts who need columns without a full GIS stack; projection-accurate spatial work still belongs in GIS software.
Fixed-width files remain common in legacy payroll and government extracts. Delimiter parsers fail on them — column widths must match the source spec, so preview carefully.
Tabs, pipes, and semicolons are handled via delimited helpers and the editor. Regional “CSV” that uses semicolons is often misread as corruption until you normalize the delimiter.
Finance file converters
Banks export OFX, QFX, QIF, IIF, and related formats spreadsheets do not open natively. Finance converters turn those into CSV for reconciliation and import.
Confirm the real export type — labels and extensions vary by bank. Convert a short date range first, verify payee and amount columns, then process longer histories.
Local processing helps with sensitive money data, but you still control how the downloaded CSV is stored and shared on your side.
File size, performance, and browser limits
With no conversion server, performance tracks your device. A few thousand rows is usually fine; much larger sets may lag. Multi-megabyte XLSX hits the editor upload cap by design.
Sample first, split by date or ID, and prefer compact uploads over huge pretty-printed pastes. When interactive tools feel uncomfortable, move to a scripted pipeline.
The architectural limit is shared across browsers: the tab is the runtime. That is the trade-off for keeping file contents off a remote conversion service.
Encoding, delimiters, and Excel surprises
Many apparent converter bugs are encoding or delimiter mismatches. Prefer UTF-8. Legacy code pages and regional Excel CSV exports still mojibake accents or split on semicolons.
After download, Excel may scientific-notation long IDs, strip ZIP leading zeros, or reinterpret dates. That happens when Excel opens text — import as UTF-8 text and format sensitive columns as Text.
Isolate the stage that broke: source in a text editor, preview in the tool, then the file after Excel or Sheets opens it. Fix that stage instead of re-converting blindly.
Suggested end-to-end workflows
API to spreadsheet: JSON from a network panel → JSON to CSV → preview → optional CSV Editor cleanup → share CSV or XLSX.
Web table to analysis: HTML table → CSV or Excel → filter in the editor → chart in Sheets.
Bank reconciliation: OFX/QFX → finance converter to CSV → categorize in a spreadsheet → archive the original with the CSV.
Config review: YAML or JSON → CSV → stakeholder review → back to JSON/YAML only if the system needs it again.
Legacy extract: fixed-width or XML → CSV → header cleanup in the editor → SQL INSERTs or JSON fixtures.
When to use another tool instead
Use desktop Excel, Sheets, or LibreOffice for multi-user editing, heavy formulas, pivots, and very large workbooks. Use Convert CSV Online for quick local transforms and light edits.
Use GIS software for geometry accuracy and spatial joins; use database ETL for scheduled, validated, monitored pipelines.
The homepage hub is strongest in the middle: frequent, interactive, privacy-sensitive conversions where installing software or creating another SaaS account is worse than opening a focused browser page.
Frequently asked questions
Is Convert CSV Online free to use?
Yes. The converters and editors are free for everyday use with no account or sign-up required. The site is supported by advertising.
Do you store or see the files I upload or paste?
Conversion and editing run in your browser with JavaScript. File contents are not uploaded to a server as part of those operations. The website still loads normal page assets, analytics, and ads — see the Privacy Policy for cookies and third-party details.
What is the difference between the editors and the converters?
Editors (Online CSV Editor, Online XLSX Editor) open your file in an interactive grid for manual changes and formatting. Converters are single-purpose pages that transform one format into another without a full spreadsheet UI.
Which formats does the site support?
Common formats include CSV, XLSX, JSON, XML, YAML, SQL INSERT text, HTML tables and links, Markdown, PDF and Word-oriented exports, GeoJSON, KML, fixed-width text, delimiter variants, and finance exports such as OFX, QFX, QIF, and IIF. Browse the tools directory for the full current list.
How do I find the right converter from the homepage?
Use the tools directory search with the format name (for example JSON, OFX, or HTML), or browse categories like Spreadsheet, Data Converter, Finance, and Developer. If you know both formats, open that dedicated page directly.
Is there a file size limit?
Spreadsheet editors cap uploads at about 5 MB. Converter pages depend on browser memory rather than a fixed server quota; very large pastes can still fail or feel slow because processing is local.
Do I need to create an account?
No. You can open a tool, paste or upload, preview, and download without registering. There is no cloud folder of past conversions tied to a login.
Can I convert one format to another if there is no exact tool pair?
Often yes, by using CSV as an intermediate hub: convert source to CSV, optionally clean in the Online CSV Editor, then convert CSV to the target format when that second tool exists.
Why does Excel change my data after I download a CSV?
Excel frequently auto-formats numbers, dates, and leading zeros when it opens CSV text. That happens in Excel, not because the converter rewrote those semantics. Import as text/UTF-8 and format sensitive columns as Text.
Is my data safe to convert if it includes personal or financial information?
Local browser processing avoids sending file contents to a conversion server, which is safer than many cloud upload converters. You are still responsible for the copy that remains on your device and for anything you share after download.
What happens if the preview looks wrong?
Check delimiter, encoding, and whether nested structures were flattened unexpectedly. Try a smaller sample, open the dedicated tool guide for that format, or clean the file in the CSV editor before converting again.
Can I use Convert CSV Online offline or as installed software?
It is a website of browser tools, not a desktop installer. You need to load the pages online; once loaded, the conversion logic runs in the tab, but it is not packaged as a standalone offline application.
For more background on data formats and conversion workflows, read our format guides or browse the converter blog for step-by-step walkthroughs linked to each tool.