SmartTechnology solutions for business

Data

CSV tables and record cleanup on your device.

  • 20 tools ready
  • Free, no account
  • Runs in your browser

20 tools

CSV File Viewer

Open a CSV file as a table you can search and sort. Free, with nothing uploaded.

Remove Duplicate Rows

Paste a table or a list to get the rows without duplicates and a count of what was removed. Free, with nothing uploaded.

Phone Number Cleaner and Formatter

Paste a list of phone numbers to get them in one international format, without spaces or repeats. Free, with nothing uploaded.

CSV Cleaner

Remove empty rows, trim spaces, and normalize headings, with a preview of the changes.

CSV File Merger

Combine files with compatible columns and handle different order and headings before download.

CSV File Comparison

Show new, removed, and changed records using a key you choose.

CSV File Splitter

Split a file by row count or by a column value such as city or category.

CSV and JSON Converter

Convert either way, map columns, and choose how nested values are handled.

CSV and TSV Converter

Change delimiters, quotes, and line endings while keeping values that contain separators.

Table Column Reshaping

Choose, rename, and reorder columns, or transpose rows and columns within a limited range.

Email Address List Cleaner

Trim spaces and find duplicates and shape errors. It does not prove an address exists or can be delivered.

Table Join by Key

Add columns from one table to another by a shared column, and show unmatched rows.

XLSX Sheet to CSV

Read XLSX sheets locally and export one sheet as values. Macros are not run and formulas are not guaranteed.

CSV to XLSX

Produce a spreadsheet with column names and types you review, and stop text from being treated as formulas.

Table Date Format Normalizer

Read stated date formats, convert them to one format, and ask you to resolve ambiguous values such as 03/04.

Table Data Masking

Replace selected columns with masked values or local identifiers before sharing a copy.

Data Quality Report

Count blanks, duplicates, type distribution, and outliers using rules you set.

Small Table Statistics and Charts

Choose numeric and category columns to show a sum, average, distribution, and a downloadable chart.

Import Template Mapper

Map file columns to a required template, check required fields, and export the prepared file.

Sample Data Generator

Create fictional names, addresses, identifiers, and values from limited schemas for interface tests.