How To CSV Data Toolkit: 95+ CSV & Excel Tools
Instantly clean, convert, analyze, and secure your spreadsheet data. No downloads, no uploads—works worldwide, GDPR compliant.
Here at How To CSV, we believe working with data should be fast, easy, and secure. Our growing collection of 95+ free online tools empowers you to clean, convert, analyze, and visualize your CSV, Excel, and JSON data—all without leaving your browser. Whether you're a data analyst, marketer, researcher, or just someone who hates dealing with broken spreadsheets, our toolkit is designed to save you time and headaches. Explore our comprehensive guide below to see how each tool can help you master your data and unlock insights in seconds.
We cover everything from basic data cleaning and format conversion to advanced AI-powered analysis, anonymizer, forecasting and scenario generations. Plus, all our tools are built with privacy in mind—your data never leaves your device. Say goodbye to clunky software and hello to the future of data processing with How To CSV.
Browse All Tools by Category
Cleaning & Preparation
Super Fix
One-click AI repair for broken CSV structure and encoding.
Available: en, it, es, fr, de, ptQuick Cleaning
Standardize text and format with one click.
Available: en, it, es, fr, de, ptGhost Scrub
Removes zero-width spaces and non-breaking spaces that break code.
Change Encoding
Fix garbled text (mojibake) by converting any text file (CSV, TXT) to the proper UTF-8 encoding.
Available: en, it, es, fr, de, ptSmart Merge
Combine multiple CSV files into one master dataset intelligently.
Available: en, it, es, fr, de, ptFiltering
Query your CSV like a database using logical operators.
Available: en, it, es, fr, de, ptBasic Cleaning
Remove whitespace, empty rows, and duplicates.
Available: en, it, es, fr, de, ptFill Missing
Impute missing values using linear interpolation or defaults.
Available: en, it, es, fr, de, ptRename Cols
Bulk rename headers and convert to snake_case for SQL.
Available: en, it, es, fr, de, ptLogical Dedupe
Remove duplicates based on specific columns and rules.
Available: en, it, es, fr, de, ptFuzzy Dedupe
Find and merge similar records (e.g. "Jon Doe" vs "John Doe").
Available: en, it, es, fr, de, ptHealth Profile
Audit your dataset for nulls, errors, and type mismatches.
Available: en, it, es, fr, de, ptDates
Standardize messy dates into ISO-8601 format.
Available: en, it, es, fr, de, ptUniqueness
Filter and export only unique values from a list.
Available: en, it, es, fr, de, ptConversion & Export
Multiway Converter
Convert between Excel (XLS, XLSX), JSON, CSV, and TSV formats instantly in your browser. Free universal file converter that handles large datasets, preserves UTF-8 encoding, auto-detects delimiters, and keeps your data private with local-only processing. No file size limits.
Available: en, it, es, fr, de, ptCSV to XLSX
Securely convert CSV files to native Excel XLSX format with correct formatting, data types, and UTF-8 encoding. Free online CSV to Excel converter that handles large files, preserves special characters, and works without uploading data to external servers.
Available: en, it, es, fr, de, ptPDF to CSV
Extract tables from PDF documents into editable CSV files.
Available: en, it, es, fr, de, ptCSV to JSON
Convert CSV rows into structured JSON arrays or objects.
Available: en, it, es, fr, de, ptTSV to CSV
Convert Tab-Separated Values (TSV) files to Comma-Separated Values (CSV) format instantly. Free online TSV to CSV converter that preserves data integrity, handles large files efficiently, and works entirely in your browser without uploading data to servers.
Available: en, it, es, fr, de, ptCSV to TSV
Convert Comma-Separated Values (CSV) files to Tab-Separated Values (TSV) format online. Perfect for exporting data to systems that require tab delimiters, handling scientific data, or preparing files for bioinformatics analysis. Fast, secure, and privacy-focused.
Available: en, it, es, fr, de, ptXLSM to CSV
Convert Excel Macro-Enabled Workbook (XLSM) files to CSV format. Extract data from XLSM spreadsheets while preserving data integrity. Perfect for processing macro-enabled Excel files, automating data pipelines, and converting complex workbooks to simple CSV format.
Available: en, it, es, fr, de, ptCSV to XLSM
Convert CSV files to Excel Macro-Enabled Workbook (XLSM) format. Create XLSM files from CSV data for use with VBA macros and automated Excel workflows. Secure, fast, and browser-based conversion without uploading to external servers.
Available: en, it, es, fr, de, ptNDJSON to CSV
Convert newline-delimited JSON (NDJSON / JSON Lines) log and pipeline exports into CSV rows, one JSON object per line turned into one row.
Available: en, it, es, fr, de, ptParquet to CSV
Convert Apache Parquet columnar files into CSV rows, and CSV back into Parquet — the standard format for data engineering, Spark, and pandas pipelines.
Available: en, it, es, fr, de, ptAvro to CSV
Convert Apache Avro container files into CSV rows, and CSV back into schema-inferred Avro — the schema-based binary format used across Kafka and Hadoop pipelines.
Available: en, it, es, fr, de, ptAnalysis & Visualization
Charts
Create bar, line, and scatter charts from your CSV instantly.
Available: en, it, es, fr, de, ptExcel Chart Extractor
Extract embedded charts from Excel files and recreate them as interactive visualizations.
Pivot Table
Summarize data like in Excel but faster and simpler.
Available: en, it, es, fr, de, ptStatistics
Calculate Mean, Median, Mode, and Standard Deviation.
Available: en, it, es, fr, de, ptEDA Report
Generate a full data quality and profile report in one click.
Available: en, it, es, fr, de, ptGroup By
Group rows by category and calculate sums or averages.
Available: en, it, es, fr, de, ptSQL on CSV
Run SQL SELECT queries directly on your CSV files.
Available: en, it, es, fr, de, ptCorrelation
Find relationships between variables (Pearson Correlation).
Available: en, it, es, fr, de, ptCount
Count frequency of unique values in a column.
Available: en, it, es, fr, de, ptDataset Diff
Find differences (added/removed rows) between two CSV files.
Available: en, it, es, fr, de, ptSchema Detect
Infer data types and structure for SQL CREATE TABLE.
Available: en, it, es, fr, de, ptText Profile
Analyze word frequency and text length distributions.
Available: en, it, es, fr, de, ptData Chat
Ask questions about your dataset in plain English (or Italian, French, Spanish...) and get trends, statistics, charts and outliers back instantly — matched locally, no cloud AI, no API key.
Available: en, it, es, fr, de, ptTransformation & Logic
Type Converter
Force convert columns to Numbers, Dates, or Text.
Available: en, it, es, fr, de, ptMerge Excel Sheets
Combine multiple Excel sheets into one unified dataset. Supports vertical stacking (append), horizontal joining (merge on common columns), and side-by-side concatenation. Perfect for consolidating monthly reports, regional data, or multi-tab workbooks.
Compare Excel Sheets
Find differences between Excel sheets with detailed comparison reports. Identify unique rows, changed values, and generate visual diff reports. Perfect for version control, audit trails, data validation, and reconciliation tasks.
Compress CSV/XLSX
Reduce file size by zipping CSV and XLSX files.
Available: en, it, es, fr, de, ptBatch Processor
Upload multiple CSV/Excel files, clean them all with one preset, and download as a single ZIP.
Available: en, it, es, fr, de, ptCalculated Cols
Apply math formulas (A + B) to create new data.
Available: en, it, es, fr, de, ptNatural Join
Perform SQL-style joins or VLOOKUP between two files.
Available: en, it, es, fr, de, ptFuzzy Join
Join tables even when spelling doesn't match perfectly.
Available: en, it, es, fr, de, ptMoving Averages
Smooth out volatile data using rolling windows.
Available: en, it, es, fr, de, ptEmail Extractor
Scrape all email addresses found in a text file or CSV.
Available: en, it, es, fr, de, ptUnpivoting (Melting)
Transform wide data (months as columns) into long format.
Available: en, it, es, fr, de, ptDate Decomp
Extract Day, Month, Year, and Weekday from dates.
Available: en, it, es, fr, de, ptText Features
Count words, characters, and extract patterns.
Available: en, it, es, fr, de, ptRegex Extraction
Use Regular Expressions to extract complex patterns.
Available: en, it, es, fr, de, ptCat Mapping
Rename or group specific values (e.g., US -> USA).
Available: en, it, es, fr, de, ptValidator
Check if data meets specific logical rules.
Available: en, it, es, fr, de, ptAI & Machine Learning
Live Chat
Ask questions about your data using AI.
Available: en, it, es, fr, de, ptAI Transform
Transform and edit your CSV using natural language commands. AI converts your instructions into code and applies changes instantly.
CSV Forecasting & Trend Prediction
Free online CSV forecasting tool using linear regression.
Available: en, it, es, fr, de, ptClustering
Group similar data points automatically.
Available: en, it, es, fr, de, ptRegression
Model the relationship between two variables.
Available: en, it, es, fr, de, ptOutliers
Find data points that don't fit the pattern (Z-Score).
Available: en, it, es, fr, de, ptOutlier Mgmt
Cap, remove, or flag anomalies in your dataset.
Available: en, it, es, fr, de, ptFeature Scaling
Scale numbers to 0-1 range or standardize them.
Available: en, it, es, fr, de, ptOne-Hot Encoding
Convert categorical text into binary numbers for ML.
Available: en, it, es, fr, de, ptBinning
Group continuous numbers into buckets (e.g. Age groups).
Available: en, it, es, fr, de, ptGroup Impute
Fill missing values based on group averages.
Available: en, it, es, fr, de, ptScenarios
Create "What-if" scenarios by modifying variables.
Available: en, it, es, fr, de, ptAugment
Generate synthetic data samples to expand small datasets.
Available: en, it, es, fr, de, ptSecurity & Privacy
Platforms
Shopify Tools
Complete Shopify toolkit: bulk product editor, multi-store inventory sync, profit calculator, dynamic pricing engine, order anomaly detection, and customer segmentation. Optimize your store operations, prevent overselling, maximize profits, and identify your best customers - all with CSV-based workflows.
Ads Tools
Complete marketing agency toolkit: multi-platform campaign aggregation (Google Ads, Facebook, LinkedIn), ROI calculator per client, white-label report generator, keyword gap analysis, competitor ad tracking, and AI-powered budget allocation optimizer. Manage 10-100 clients efficiently with unified analytics.
HR Tools
Complete HR and recruitment toolkit: resume parser with skill scoring, candidate deduplication using fuzzy matching, salary benchmarking against market rates, diversity & inclusion analytics, interview scheduler optimizer, and automated onboarding checklist generator. Streamline hiring from application to onboarding.
Financial Formats
OFX to CSV
Convert OFX and QFX bank/broker statement exports into clean CSV rows (date, type, amount, name, memo) for spreadsheets or accounting software.
Available: en, it, es, fr, de, ptQIF to CSV
Convert legacy Quicken QIF exports into CSV, mapping date, amount, payee, memo and category fields to clean columns.
Available: en, it, es, fr, de, ptMT940 to CSV
Convert SWIFT MT940 bank statement files into CSV rows with value date, amount, credit/debit indicator and remittance info.
Available: en, it, es, fr, de, ptCAMT.053 to CSV
Convert ISO 20022 CAMT.053 XML bank statement files into CSV rows with booking date, amount, currency and remittance info.
Available: en, it, es, fr, de, ptIIF to CSV
Convert QuickBooks IIF transaction files into CSV rows for spreadsheet review or migration to another accounting system.
Available: en, it, es, fr, de, ptScientific Formats
FASTA to CSV
Convert FASTA sequence files into CSV rows with ID, description and sequence columns for spreadsheet review or downstream analysis.
Available: en, it, es, fr, de, ptFASTQ to CSV
Convert FASTQ sequencing read files into CSV rows with ID, sequence and quality score columns.
Available: en, it, es, fr, de, ptVCF to CSV
Convert genomic Variant Call Format (VCF) files into CSV rows with chromosome, position, reference/alternate alleles and INFO fields.
Available: en, it, es, fr, de, ptBED to CSV
Convert BED genomic interval files into CSV rows with chromosome, start, end and optional name/score/strand columns.
Available: en, it, es, fr, de, ptPDB to CSV
Convert Protein Data Bank (PDB) atomic coordinate files into CSV rows with atom name, residue, chain and X/Y/Z coordinates.
Available: en, it, es, fr, de, ptGPX to CSV
Convert GPX waypoint and track files into CSV rows with latitude, longitude, elevation, time and name columns.
Available: en, it, es, fr, de, ptNMEA to CSV
Convert raw NMEA 0183 GPS sentence logs (GGA, RMC) into CSV rows with decimal latitude, longitude, time and fix quality.
Available: en, it, es, fr, de, ptMarketing Formats
Google Ads Normalizer
Normalize Google Ads Editor and Google Ads UI bulk export column names into a stable Campaign/AdGroup/Keyword schema.
Available: en, it, es, fr, de, ptMeta Ads Normalizer
Normalize Meta Ads Manager exports into a stable Campaign/AdSet/Ad schema with spend, reach and CTR columns aligned.
Available: en, it, es, fr, de, ptMailchimp Normalizer
Normalize Mailchimp audience/subscriber exports into a stable Email/FirstName/LastName/Tags schema for migration to another platform.
Available: en, it, es, fr, de, ptHubSpot Normalizer
Normalize HubSpot contact exports into a stable Email/Name/Company/LifecycleStage schema for CRM migration or reporting.
Available: en, it, es, fr, de, ptKlaviyo Normalizer
Normalize Klaviyo list and segment exports into a stable Email/Name/List/ConsentStatus schema, ready for e-commerce marketing migrations.
Available: en, it, es, fr, de, ptFiscal Compliance
FatturaPA Validator
Validate a FatturaPA XML e-invoice before sending it to SDI: mandatory fields, Partita IVA and Codice Fiscale checksums, and IVA (VAT) math consistency across every line.
Available: en, it, es, fr, de, ptEU VAT Compliance
Bulk-validate EU VAT numbers with real checksum algorithms and flag when cumulative distance sales cross the €10,000 EU-wide OSS/IOSS registration threshold.
Available: en, it, es, fr, de, ptUS/CA Sales Tax Auditor
Aggregate transactions by US state or Canadian province to flag post-Wayfair economic nexus threshold breaches, and audit charged tax against the correct Canadian GST/HST/PST rate.
Available: en, it, es, fr, de, ptIndia GST Compliance
Validate GSTIN checksums, CGST/SGST/IGST combination logic, HSN/SAC code format, and the ₹5 crore e-invoice (IRN) mandate on a GST invoice export.
Available: en, it, es, fr, de, ptInvoice Sequence Auditor
Detect gaps and duplicates in invoice numbering — most tax authorities (SDI, GSTN, and most EU VAT regimes) require sequential, non-repeating invoice numbers within a fiscal year.
Available: en, it, es, fr, de, ptFrequently Asked Questions
Are these tools available in my country?
Yes! All tools run in your browser and are accessible globally. No region restrictions.
Is my data secure and private?
Absolutely. All processing happens locally in your browser. No files are uploaded or stored.
Do you support Excel, CSV, TSV, and JSON?
Yes. The toolkit covers all major spreadsheet and data formats, including Excel (.xlsx, .xlsm), CSV, TSV, and JSON.
Can I use these tools on Mac, Windows, Linux?
Yes. The platform is fully cross-device and works on any modern browser, including Chrome, Edge, Firefox, and Safari.
Start Your Data Journey
Join thousands of professionals worldwide using How To CSV for fast, secure, and advanced data processing.
Try All Tools Free