All tools
Tools grouped by the job you do with a table. Every tool processes your files only inside this browser.
Compare
- Compare
Compare two Excel or CSV files and list added, removed and changed rows. Free, no sign-up, and your files never leave your browser.
- Compare cell by cell
Compare two Excel sheets cell by cell without an ID column. Rows are matched in order, inserted and deleted rows are found, and changed cells are highlighted.
- Compare workbooks
Compare every sheet of two Excel workbooks at once and see how many differences each sheet has. Formulas can be compared too.
- Compare formulas
Compare the values and formulas of two Excel files and catch cells where a formula was replaced by a fixed value. Nothing is uploaded.
- Compare lists
Compare two lists and list the values they share and the values found in only one. Paste columns from Excel or use files. Nothing is uploaded.
- Find duplicates
Find rows that repeat a key or a whole row in an Excel or CSV file, grouped and counted. Download the table without duplicates. Nothing is uploaded.
- Lookup
Match two Excel or CSV tables by a key and bring columns from one into the other without writing VLOOKUP. Missing and repeated keys are flagged.
- Compare totals
Total two periods of Excel or CSV data by store, product or any column and see the difference and % change for each group. Nothing is uploaded.
Check
- Hidden characters
Free tool that lists Excel and CSV cells with non-breaking spaces, zero-width characters, line breaks and stray spaces that TRIM can't remove. Files are not uploaded.
- Spelling variants
Free tool that finds values in a column that differ only by case, width or spacing, and gives you the table with each written the same way.
- Character count
Free tool that counts characters or bytes in every Excel or CSV cell, shows the longest value per column and lists cells over a limit.
- Missing numbers
Free tool that finds missing, repeated and out-of-order numbers in an Excel or CSV column, including numbers with a prefix like INV-0001.
- Validate data
Free online CSV and Excel validator: set rules per column and list every cell that is blank, the wrong type, too long or not allowed. Nothing is uploaded.
- Check digits
Free check digit calculator for a whole column: validates EAN, UPC, ISBN and IBAN numbers from Excel or CSV and lists the invalid ones.
- Find personal data
Free tool that finds cells with email addresses, phone numbers, card numbers and national IDs in Excel or CSV before you share it.
- Column profile
Free tool that summarizes every column of an Excel or CSV file: value types, blanks, distinct values, min, max and the most common values.
Clean
- Remove spaces
Free tool that removes leading, trailing and extra spaces, non-breaking spaces and zero-width characters from Excel and CSV files in bulk.
- Remove line breaks
Free tool that removes line breaks inside Excel and CSV cells, or replaces them with a space or other text, across many files at once.
- Remove blank rows
Free online tool that deletes empty rows and empty columns from Excel and CSV files in one go. No sign-up and no upload.
- Unmerge and fill
Free tool that unmerges merged cells in Excel and fills every cell with the same value, without VBA.
- Fill blanks from above
Free tool that fills empty cells in Excel or CSV with the value just above them, until the next value.
- Change case
Free tool that changes text in Excel and CSV to UPPER CASE, lower case or Proper Case for a whole column or sheet, without formulas.
- Fix garbled text
Free online tool that repairs garbled text (mojibake) such as “Müller” in Excel and CSV cells, restoring the original characters.
- Split a column
Free tool that splits one Excel or CSV column into several by a comma, space or other delimiter, by character counts, or where digits meet letters.
- Split names
Free tool that splits full names in Excel into first, middle and last name columns, including “Last, First”.
- Standardize dates
Free tool that converts dates stored as text in Excel or CSV — 20240401, 4/1/2024, 2024-04-01 — into one format you choose.
- Text to numbers
Free tool that converts numbers stored as text in Excel or CSV — with currency signs, commas, brackets or full-width digits — into real numbers.
- Find and replace
Free tool that finds and replaces many values at once with a list of rules, across several Excel and CSV files.
- Mask data
Free tool that masks sensitive columns in Excel and CSV: hide part with *, replace with a hash or consistent alias, or remove the column.
Reshape
- Merge files
Combine several CSV or Excel files into one table with the columns lined up by header. Free, in your browser, and nothing is uploaded.
- Split
Split an Excel table into sheets or separate files by the value of a column, without macros. Free, and nothing is uploaded.
- Choose and reorder columns
Free tool that keeps the columns you need, reorders and renames them, for one or many Excel and CSV files. Files are not uploaded.
- Filter rows
Free tool that keeps the Excel or CSV rows meeting several conditions — text, numbers, dates, blanks or a list — and downloads them. Files are not uploaded.
- Random sample and picker
Free tool that picks random rows from an Excel or CSV file without duplicates, by count or percentage, or from each group. Files are not uploaded.
- Unpivot and pivot
Free tool that unpivots Excel or CSV tables from wide to long, or pivots them back, without Power Query — on Mac too. Files are not uploaded.
- Transpose
Free online tool that swaps the rows and columns of a CSV or Excel table, even large ones. Download as Excel or CSV. Files are not uploaded.
- Split by row count
Free online CSV splitter: split a large CSV or Excel file into files of N rows or N equal parts, header on each. Files are not uploaded.
- Combine all sheets into one
Free online tool that stacks every sheet of one or more Excel workbooks into one sheet, lining up columns by header. Files are not uploaded.
Summarize
- Crosstab
Free online crosstab: choose rows, columns and a value to sum, count or average from an Excel or CSV file, with totals. Files are not uploaded.
- Totals by group
Free tool that totals Excel or CSV data by group: count, sum, average, max and min, with a grand total. Files are not uploaded.
- Unique values and counts
Free tool that lists the unique values of an Excel or CSV column with how often each appears, most frequent first. Files are not uploaded.
- Frequency table and histogram
Free tool that makes a frequency table with relative and cumulative frequency from a column of numbers, plus a histogram. Files are not uploaded.
- ABC analysis
Free ABC analysis: total items from Excel or CSV sales or stock data, sort them and rank them A, B and C by cumulative share. Files are not uploaded.
Add columns
- Age from birth date
Free tool that adds an age column from birth dates in Excel or CSV, in years or years and months, as of today or any date. Files are not uploaded.
- Days and business days
Free tool that adds business days or days between two date columns in Excel or CSV, skipping weekends and your holidays. Files are not uploaded.
- Add or remove tax
Free tool that adds VAT or sales tax to prices in Excel or CSV, or splits gross prices into net and tax, with your rate and rounding. Files are not uploaded.
- Hours worked
Free timesheet calculator for Excel and CSV: hours worked from start and end times minus breaks, night shifts included. Files are not uploaded.
- Share, running total and rank
Free tool that adds each row's percentage of the total, a running total and a rank to Excel or CSV data, no formulas. Files are not uploaded.
Workbook
- Workbook health check
Free online check that shows what makes an Excel file large: size per sheet and pictures, used ranges past the data, external links, hidden sheets and broken names. No upload.
- Reduce file size
Free online tool that makes a bloated Excel file smaller by removing formatting past the data, broken names and unused styles. Formatting, pictures and macros stay.
- Find and break external links
Free online tool that finds all external links in an Excel workbook and lists the cells, names and linked files. Nothing is uploaded.
- Unhide everything
Free online tool that unhides every sheet, row and column in a workbook at once, including very hidden sheets, without VBA. Formatting and macros stay.
- Remove personal information
Free online tool that removes the author, last modified by, company and comment author names from Excel files, several at once. Nothing is uploaded.
- Formulas to values
Free online tool that replaces every formula in a workbook with its value, on all sheets and in several files at once, without copy and paste. Formatting stays.
- Extract images
Free online tool that saves every picture in an Excel file at its original quality, zipped and named after its sheet and cell. No upload.
- Insert images in bulk
Free online tool that places many pictures into Excel cells at once, each in the row whose file name or code matches, sized to fit. No VBA, no upload.
- Extract hyperlinks
Free online tool that lists the text and URL of every hyperlink in an Excel file, including HYPERLINK formulas, ready to export. No VBA.
- List comments
Free online tool that exports every comment and note in a workbook as a table of sheet, cell, author and text. Nothing is uploaded.
- Count colored cells
Free online tool that counts cells by fill color, font color, bold and strikethrough and lists them. No formulas or VBA needed.
- Sheet list and contents
Free online tool that lists every sheet name in a workbook with its hidden state and used range, ready to export to Excel or CSV.
- Split sheets into files
Free online tool that saves each sheet of a workbook as its own file, zipped, keeping formatting and pictures and leaving out the other sheets' data.
- List formulas
Free online tool that lists every formula in a workbook with its cell and result, and marks values typed over a formula column and formulas returning errors.
- Merge workbooks into one
Free online tool that merges several Excel files into one workbook, one sheet per file, keeping formatting and pictures. Sheets take the file names. No upload.
Convert
- Convert CSV
Convert a CSV file to Excel (xlsx) while keeping leading zeros and long numbers, or save Excel as CSV. Free, and nothing is uploaded.
- Excel to JSON
Free online tool that converts Excel and CSV files to JSON as an array of objects or rows, with optional number types. Nothing is uploaded.
- Excel to Markdown table
Free tool that converts cells copied from Excel, or an Excel or CSV file, into a Markdown table you can copy. Number columns are right-aligned.
- Excel to SQL INSERT
Free online tool that generates INSERT queries and CREATE TABLE from Excel or CSV for MySQL, PostgreSQL, SQLite, SQL Server and Oracle. Nothing is uploaded.
- Excel to HTML table
Free tool that converts Excel or CSV to an HTML table with escaped text, as a snippet or a whole page. Your file stays in your browser.
- CSV to fixed width
Free tool that converts CSV or Excel to a fixed-width text file. Set each column's width in characters or bytes and pad numbers with spaces or zeros.
- CSV to vCard contacts
Free online tool that converts a CSV or Excel contact list to a VCF file for iPhone, Android and Google Contacts. Your contacts never leave your browser.
- CSV to iCalendar events
Free online tool that converts a CSV or Excel list of events to an ICS file for Google Calendar, Outlook and Apple Calendar. Nothing is uploaded.
- JSON to Excel or CSV
Free online tool that converts JSON to an Excel (xlsx) file, with nested objects spread into columns. Your file never leaves your browser.
- XML to Excel or CSV
Free online tool that converts the repeated elements of an XML file into an Excel table, attributes included. Nothing is uploaded.
- Fixed width to CSV
Free tool that converts a fixed-width text file to CSV or Excel. Column widths are guessed for you and can be set in characters or bytes.
- vCard contacts to CSV
Free online tool that converts a VCF contacts file from iPhone, Android or Google to CSV or Excel. Your contacts never leave your browser.
- iCalendar events to CSV
Free online tool that converts an ICS calendar file from Google Calendar or Outlook to CSV or Excel, with dates and times in columns.
- xls, Numbers and ODS to xlsx
Free online tool that converts old xls files to xlsx in bulk, keeping values, formulas and merged cells. Files never leave your browser.
- Table to PDF
Free CSV to PDF converter that lays out your rows as a printable table with the header on every page, in portrait or landscape. No upload, no sign-up.
- Table to image
Free Excel to PNG converter for tables. Paste the image into a chat, an email or a slide. The table is redrawn in your browser, no upload.
Generate
- Bulk QR codes
Free bulk QR code generator: one QR code per row of your Excel or CSV list, saved as PNG files in a zip or an Excel file. File names from a column. No upload.
- Bulk barcodes
Free bulk barcode generator for Excel and CSV lists: Code 128, EAN-13, UPC-A and ITF-14, as PNG files or an Excel file with images. No barcode font needed.
- Address labels
Free tool that turns an Excel or CSV address list into a PDF laid out for Avery 5160 / 8160 labels (30 per sheet), L7160 or L7163. Nothing is uploaded.
- Mail merge to Word
Put {{column name}} fields in a Word template and get a document for every row of your spreadsheet. Numbers and dates keep their format. Free, nothing is uploaded.
- Date list
Free tool that lists the dates between two dates with the weekday. Keep business days or weekends only, then save as Excel or CSV or copy the whole list.
- Dummy data generator
Free fake data generator: pick name, email, phone, US address, company, date and amount columns and download up to 50,000 rows as CSV or Excel.
View
- Excel viewer
Free online XLSX viewer: open .xlsx, .xls, .ods and .numbers files in your browser and see hidden sheets, hidden rows and formulas. Nothing is uploaded.
- CSV viewer
Free online CSV viewer: open a CSV file as a table with leading zeros and long numbers kept as written, then sort and search it. Nothing is uploaded.