Skip to main content
WizTools123
WizTools123
Free Online Tools

Tool Categories

Buy Us A Coffee
CSV Tools 482 Tools Available

Free Online CSV Viewer, Editor, Cleaner, Sorter and Converter Tools

Work with CSV files online for free. View and edit rows, validate and clean messy exports, sort, filter, search and replace, remove duplicates, split and merge columns, transpose, pivot, chart and convert to JSON, XML, HTML or Markdown. Most tools take a whole folder at once and give the results back as a zip, and every file is read inside your own browser.

Free Forever Nothing Uploaded, Ever Many Files At Once No Account, No Row Limit
Free Online CSV Viewer, Editor, Cleaner, Sorter and Converter Tools
Share this tool
Advertisement Slot (Top Banner) Google AdSense Unit • Responsive Banner

Choose a CSV Tool

Ten of them. The table underneath matches the question to the tool.

New

CSV and JSON Converter

Both directions, and honest about the losses

Convert CSV to JSON and JSON back to CSV in your browser. The delimiter is detected, nesting is flattened with dots, and nothing is uploaded.

  • CSV to JSON with the header row as keys, or as plain arrays of arrays
  • Optional real types, so 42 becomes a number and 007 stays a string
  • JSON to CSV flattens address.city into a column of that name
  • Comma, semicolon, tab or pipe, detected for you and overridable
Convert CSV and JSON
New

CSV Viewer and Formatter

Names the delimiter and the broken line

Read a CSV as a sortable table, see which rows have the wrong number of columns, and write it back out with the delimiter and quoting you need.

  • Detects comma, semicolon, tab or pipe, and says which one it found
  • Shows the data as a table you can sort by clicking a column heading
  • Lists rows whose column count does not match the header, by line number
  • Re-emits with a new delimiter, quoting, line ending and trimming
View CSV
New

Bulk CSV Sorter

Three sort keys, the right type for each, many files at once

Sort CSV rows by up to three columns at once, with the right treatment for numbers, dates and text. Many files in one pass, out as a zip.

  • Sort by up to three columns, so "by city, then by date" works in one pass
  • Numbers sort as numbers and dates as dates, with the type picked from your data
  • Blank values stay at the end whichever direction you sort in
  • Drop in a whole folder and take every sorted file away as one zip
Sort my rows
New

Bulk CSV Validator

Every fault with the line number, before the import fails

Check a CSV before it breaks an import. Finds rows with the wrong column count, unclosed quotes, a byte order mark and duplicate headers, by line number.

  • Rows whose column count does not match the header, listed by line number
  • Quotes that are never closed, which otherwise swallow the rest of the file
  • A byte order mark, blank headings and duplicate column names
  • Values starting with an equals sign, which Excel treats as a formula
Check my file
New

Bulk CSV Cleaner

Squares up the rows, and never rewrites your values

Square up ragged rows, trim stray spaces, strip invisible characters and drop empty rows and columns. Leading zeros are never touched.

  • Ragged rows squared up to one width, so an import stops shifting columns
  • Stray spaces and invisible characters removed, which is what breaks matching
  • Empty rows, empty columns and duplicate blank headings all dealt with
  • Leading zeros, currency symbols and date spellings left exactly as they were
Clean my file
New

Bulk CSV Transposer

Rows become columns, and the header goes where it belongs

Flip a CSV so the rows become columns and the columns become rows, with the header handled properly. Several files in one pass.

  • The header row becomes the first column, so nothing loses its label
  • Ragged rows are squared up first, so no value lands in the wrong place
  • Works on a whole folder at once, each file flipped on its own
  • Values are moved, never reformatted, so leading zeros survive
Flip my rows and columns
New

Bulk CSV Filter

Three conditions, real number and date comparison

Keep or drop CSV rows using up to three conditions on named columns, with proper number and date comparison. Many files in one pass.

  • Up to three conditions on named columns, combined with all or any
  • Numbers compare as numbers and dates as dates, not as text
  • Thirteen tests including contains, starts with, between, is empty and matches a pattern
  • Keep the matching rows or drop them, across a whole folder at once
Filter my rows
New

Bulk CSV Search and Replace

Inside the values, in the columns you choose

Find and replace inside CSV values, in chosen columns only, leaving commas, quotes and headings alone. Many files in one pass.

  • Replaces inside values, so the separators and quoting of the file are never damaged
  • Limit it to chosen columns, which a text editor simply cannot do
  • Whole value or part of one, with an option for regular expressions
  • Shows how many cells will change before you download anything
Replace in my file
New

Bulk CSV Duplicate Remover

Judged on the columns that identify a record, not the whole row

Remove duplicate CSV rows, judged on the whole row or on the columns you choose, keeping the first, the last or the most complete copy.

  • Duplicates judged on the whole row, or on the key columns you choose
  • Keep the first copy, the last, or the one with the most fields filled in
  • List the duplicates instead of removing them, when you need a report
  • Add a count column saying how many times each row appeared
Remove the duplicates
New

Bulk CSV Column Picker

Keep, drop, reorder and rename, in one pass

Keep only the columns you want, drop the ones you do not, put them in a new order and rename them. Many files in one pass.

  • The order you type the columns in is the order they come out in
  • Name them by heading, by letter or as a range such as 1-4
  • Rename as you go, so the result is ready for whatever is consuming it
  • Columns matched by name across a whole folder of files at once
Pick my columns
New

Bulk CSV Column Merger and Splitter

No double separators, and nothing lost off the end

Join several CSV columns into one, or split one column into several, without leaving double separators where a value was empty.

  • Join any number of columns with the separator you choose
  • Empty values are skipped, so a missing middle name leaves no double space
  • Split on a character or at a fixed position, into as many pieces as you need
  • The last piece can keep the remainder, so nothing is quietly thrown away
Merge or split my columns
New

Bulk CSV and XML Converter

Valid tag names, proper escaping, and nesting flattened sensibly

Convert CSV to XML with valid tag names and proper escaping, or flatten XML records back into CSV columns. Many files in one pass.

  • Headings become legal tag names, so the XML actually parses
  • Ampersands and angle brackets escaped, which is what breaks hand made XML
  • Values can go in elements or in attributes, whichever the receiver expects
  • Coming back, repeated records are found automatically and nesting becomes column names
Convert my file
New

CSV to HTML and Markdown Table

Escaped properly, aligned sensibly, readable as source

Turn a CSV into an HTML table or a Markdown table, with proper escaping, column alignment and padding that keeps the source readable.

  • HTML with a real header row, and the classes your site already uses
  • Markdown with alignment markers and padding, so the source reads cleanly
  • Ampersands, angle brackets and pipes handled, so nothing breaks the markup
  • Numeric columns detected and aligned right without being asked
Make my table
New

CSV Statistics Analyzer

Every column profiled, with the mean and the median side by side

Profile every column of a CSV: type, blanks, unique values, minimum, maximum, mean, median and standard deviation, with a copyable report.

  • Type, blanks and unique values for every column, which is where data quality shows
  • Minimum, maximum, total, mean, median and standard deviation for numeric columns
  • Mean and median together, because a gap between them means an outlier
  • The whole profile as a plain text report you can paste into a ticket
Analyse my file
New

CSV Pivot Table Generator

Rows, columns and a figure in each cell, with totals

Summarise a CSV by one or two columns with a total, count, average, minimum or maximum, including row and column totals.

  • Group by one column, or cross two columns against each other
  • Count, total, average, minimum, maximum or distinct values in each cell
  • Counting needs no value column, which is the most common thing people want
  • Row and column totals, and the result downloads as an ordinary CSV
Build my pivot table
New

CSV Chart Generator

Eight chart types, a tested palette, PNG or vector out

Turn CSV columns into a bar, line, pie or scatter chart and download it as a PNG or a vector SVG. No library is fetched.

  • Bar, grouped, stacked, horizontal, line, area, pie and scatter
  • A colourblind safe palette that was run through a contrast checker, not picked by eye
  • Download as a PNG for a document, or an SVG that stays sharp at any size
  • No charting library is fetched, so the page works with the network off
Chart my data
New

CSV Editor

Edit the cells without Excel rewriting your values

Edit CSV cells, add and remove rows and columns, rename headings and undo mistakes, without a spreadsheet rewriting your values.

  • Click any cell and type, with full undo and redo
  • Insert, delete, duplicate and move rows and columns
  • Leading zeros and long numbers survive, which they do not in a spreadsheet
  • Large files are paged, so the whole file is saved even though you see a screenful
Edit my file
Buy Us A Coffee

Enjoying WizTools123? Help keep our server infrastructure 100% free and open for everyone.

Buy Us A Coffee
Sponsored Content (Below Tool) Google AdSense Placement

Which Tool Do I Need?

Find the sentence that sounds like you.

What you are trying to do Tool Why that one
I have a CSV export and the API I am feeding wants JSON CSV and JSON Converter Converts either way, detects the delimiter, and says where the conversion loses something.
This CSV opens as one long column and I cannot see what is wrong CSV Viewer and Formatter Finds the real delimiter, shows it as a table, and names the bad lines.
I need these rows in order, and the file will not open in Excel Bulk CSV Sorter Sorts by up to three columns with real number and date ordering, on any number of files.
My import keeps failing and the error message tells me nothing Bulk CSV Validator Names every structural fault with its line number, including the ones no error message mentions.
This export is a mess and the import keeps shifting my columns Bulk CSV Cleaner Squares up the rows, trims the spaces, strips the invisible characters, and leaves values alone.
My data is the wrong way round, I need the rows as columns Bulk CSV Transposer Flips the grid and puts the header where it belongs instead of rotating it as data.
I only want the rows where one column says a particular thing Bulk CSV Filter Three conditions on named columns with real number and date comparison, on any number of files.
I need to change a value everywhere, but only in one column Bulk CSV Search and Replace Replaces inside the values of chosen columns, leaving the file structure untouched.
The same customer appears several times and the rows are not identical Bulk CSV Duplicate Remover Judges duplicates on the columns you name and can keep the most complete copy.
This export has forty columns and I need six of them in a set order Bulk CSV Column Picker Keeps the columns you name, in the order you name them, and can rename them on the way.
I need one column out of three, or three out of one Bulk CSV Column Merger and Splitter Joins without leaving double separators, and splits without losing the remainder.
The system I am feeding wants XML and all I have is a CSV Bulk CSV and XML Converter Makes legal tag names and escapes properly, and flattens XML records back into columns.
I need this data as a table in a page, a README or a wiki CSV to HTML and Markdown Table Escapes properly, aligns numeric columns, and pads Markdown so the source stays readable.
I was sent a CSV and I need to know what is actually in it CSV Statistics Analyzer Profiles every column: type, blanks, uniques, and the full numeric summary.
I need totals per category, or a grid of one thing against another CSV Pivot Table Generator Groups by one or two columns with six calculations and proper totals.
I need a chart from these columns, as an image I can paste CSV Chart Generator Eight chart types from chosen columns, out as a PNG or a vector SVG.
I need to fix a few cells without Excel mangling the rest CSV Editor Edits cells in place with undo, and never reformats a value you did not touch.
I want a spreadsheet file, not a CSV Neither Nothing here writes .xlsx. Open the cleaned CSV in your spreadsheet program and save it as a workbook from there.
What I have is an HTML table on a web page HTML Table to CSV and JSON That one handles merged cells, which a plain CSV reader cannot see at all.

How These CSV Tools Work

The same four steps, whichever one you pick.

1
Drop the file in, or paste the rows Both work, and both are there for a reason. A real export is a file; a handful of rows out of a spreadsheet is quicker pasted. Several files at once on the tools that support it.
2
Check how it was read The separator is detected and the first row is treated as a header. Both are one control away if the guess was wrong, and the table on the left shows you immediately whether it was.
3
Set what the tool should do Columns are picked by name, by letter or by number, and ranges such as 1-3 are understood. The result updates as you change the settings rather than waiting for a button.
4
Take the result away Copy it, download one file, or download every file as a zip. The Windows line endings and byte order mark switches are there for Excel, and they are labelled as such.

Why These Rather Than the Usual Calculator Sites

The things that are actually different, not a list of adjectives.

Your data never leaves the tab CSV files are where the awkward data lives: customer lists, payroll, order histories, exports from systems nobody is supposed to email. Every tool here reads the file inside your own browser, so none of that is uploaded, stored or seen by anyone. Load a page once and it keeps working with the network switched off.
Many files in one pass, with a zip at the end Most of these tools take a folder full of files rather than one. Clean, sort, filter or convert all of them with the same settings and take the results away as a single zip. The work is done one file at a time so the page keeps responding, with a progress bar that means something.
The delimiter and the quotes are taken seriously A semicolon file read as commas gives one long column. A quoted value containing a comma read carelessly becomes two fields and shifts every column after it. The separator is worked out from how consistent the row widths come out, not from counting characters, and quoted values spanning several lines are read properly.
Nothing is silently converted A product code of 007 is not the number seven, and a tool that decides otherwise has destroyed your data. Values are left exactly as they were found unless you ask for a change, column types are reported rather than applied, and anything a tool could not understand is counted and shown instead of being quietly dropped.

About WizTools CSV Tools

CSV has outlasted every format meant to replace it, because it is the only one every system can read and write. That is also its problem: there is no version, no schema and no agreed dialect, so a file that opens perfectly in one program arrives mangled in the next. Almost every CSV problem is one of four things, and all four are quiet rather than loud.

The separator is the first. Comma is the name of the format and not always the character in the file, because a country that writes decimals with a comma cannot use commas between fields, so half of Europe exports semicolons. The second is quoting: a value containing the separator has to be wrapped in quotes, and a parser that splits on commas without understanding quotes turns one address into two fields and shifts every column after it, with no error message.

The third is encoding. Excel writes a byte order mark at the start of a UTF-8 CSV, and a program that does not expect it finds the first column named with three invisible characters stuck to the front. Leave the mark out and Excel reads the file in its own legacy encoding instead, which is why accented names arrive broken. The fourth is type guessing: a tool that decides 007 is a number has deleted two characters from a product code, and a tool that reads 05/01/2026 as the fifth of January in one country and the first of May in another has changed a date.

Every tool in this hub is built around those four. The separator is detected by consistency rather than frequency. Quoted values are parsed character by character so a value can contain commas and line breaks. The byte order mark is stripped on the way in and offered as a switch on the way out. Column types are reported and never applied without being asked. None of it is clever work, and leaving it out is what makes most CSV tools frustrating.

Frequently Asked Questions

About the set as a whole. Each tool has its own answers too.

Up to 25 megabytes per file, which is roughly two hundred thousand rows of ordinary data. The limit is about keeping your browser responsive rather than about the parsing. Above it, split the file first or use a desktop tool.

No. Every tool reads the file with your browser own file reader and does the work in the page. There is no server step, no account and no logging, which is why these are safe to use on customer lists and payroll exports.

Yes, and it is detected automatically. Semicolon files are standard across much of Europe because a comma is the decimal separator there. Comma, semicolon, tab and pipe are all read, and you can override the detection if a file is unusual.

Because Excel assumes its own legacy encoding unless a UTF-8 CSV begins with a byte order mark. Switch on the byte order mark option when you download and the file opens correctly. It is labelled on every tool that writes a CSV.

On most of these tools, yes. Drop in as many files as you like, set the options once, and download every result in a single zip. The files are handled one at a time so the page keeps responding on large batches.

Not unless you ask. Values are passed through exactly as they were read, so a leading zero stays and a date keeps its original spelling. Tools that need to understand a value as a number or a date, such as the sorter and the statistics page, do that for the comparison only and leave the text alone.

No, these tools read and write CSV and a few text formats. Once your CSV is clean, open it in your spreadsheet program and save it as a workbook there, which also lets you keep the formatting and formulas you add.

Every Other Category

19 more sets of tools on the site. All free, all in your browser.

47 tools

PDF Tools

Split, merge, reorder, crop and compress PDF files online for free. Add watermarks, page numbers or passwords with simple, easy-to-use tools.
41 tools

Image Tools

Compress, resize, crop and convert images online for free. Change JPG, PNG, WebP and HEIC files in your browser with nothing uploaded.
77 tools

Video Tools

Seventy seven free video tools that run in your browser. Trim, convert, compress, caption, watermark, analyse and edit GIFs. No upload, no watermark.
33 tools

Audio Tools

Thirty three free audio tools that run in your browser. Cut, convert, normalise, analyse, record and generate. No upload, no account, no watermark.
25 tools

Text Tools

Count words, change case, compare two texts, sort or dedupe lines, find and replace, and make slugs. Free text tools, nothing uploaded.
92 tools

Developer Tools

Format JSON, hash text, encode Base64, decode JWT, test regex, convert colours and more. Free developer tools, nothing uploaded.
8 tools

Health & Fitness Tools

BMI, BMR and TDEE, body fat, macros, ideal weight, calorie, water and heart rate calculators. Metric or imperial, nothing uploaded.
10 tools

Finance & Loan Tools

Loan EMI, mortgage, SIP, discount, GST, tip, savings, zakat and ROI calculators. Free, and nothing you type is uploaded.
2 tools

QR Code Tools

Create QR codes with your own logo and colours, or scan one from your camera or a picture. Free online QR code generator and reader.
2 tools

Barcode Tools

Generate Code 128, EAN-13 and UPC-A barcodes for labels, or scan one back from a photo. Free online barcode generator and reader.
1 tool

Typing Tools

Test your typing speed and accuracy online. Timed WPM tests with live results and practice passages, free and without an account.
5 tools

Utility Tools

Generate strong passwords, spin a random picker wheel, roll dice, flip a coin or time laps with a stopwatch. Free everyday online tools.
36 tools

Math Tools

Free online calculators for percentages, fractions, averages, algebra, matrices, geometry and number bases. Every answer shows the working.
19 tools

Date & Time Tools

Count days and business hours, convert time zones, timestamps and ISO 8601, plan meetings across zones and print calendars. Free date and time tools.
12 tools

Crypto Tools

Calculate crypto profit and loss, average entry, DCA, position size, leverage and liquidation price. Free calculators, no live prices used.
22 tools

Forex Tools

Calculate forex pip value, lot size, margin, leverage, spread, swap and risk in your own account currency. Free trading calculators.
20 tools

Unit Tools

Convert cm to inches, kg to lbs, Celsius to Fahrenheit, MB to GB and more. Twenty unit categories with answers as you type, free online.
11 tools

JSON Tools

Validate, view, compare, flatten and analyze JSON online for free. Line and column on every error, many files at once, nothing uploaded.
2 tools

Data & Creative Tools

Turn data into something worth watching. Chart animation videos today, more creative tools to come. All in your browser, no upload, no watermark.
Advertisement Slot (Bottom Banner) Google AdSense Unit • Responsive Banner