How To CSV Data Toolkit: 118+ 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 118+ 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
Convert CSV to XLSX free, right in your browser — no upload. Builds a real Excel workbook with correct text/number/date types, so leading zeros, long IDs, dates and UTF-8 characters survive. Handles large files.
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, ptCSV to XML
Convert CSV rows into an XML document with one element per row, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptXML to CSV
Flatten an XML file with repeating records into CSV rows, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptCSV to YAML
Convert CSV rows into a YAML list of mappings, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptYAML to CSV
Flatten a YAML list of mappings into CSV rows, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptCSV to TOML
Convert CSV rows into a TOML array of tables, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptTOML to CSV
Flatten a TOML array of tables into CSV rows, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptCSV to INI
Convert CSV rows into an INI config file with one section per row, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptINI to CSV
Flatten an INI config file into CSV rows, one per section, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptCSV to HTML
Convert CSV rows into an HTML <table>, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptHTML to CSV
Extract an HTML <table> and flatten it into CSV rows, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptCSV to Markdown
Convert CSV rows into a GitHub-flavored Markdown table, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptMarkdown to CSV
Extract a GitHub-flavored Markdown table and flatten it into CSV rows, entirely in your browser — no upload, no file size limit.
Available: en, it, es, fr, de, ptDOCX to Markdown
Convert Word (.docx) documents to clean GitHub-Flavored Markdown, entirely in your browser.
Available: en, it, es, fr, de, ptPPTX to Markdown
Convert PowerPoint (.pptx) presentations to GitHub-Flavored Markdown, entirely in your browser.
Available: en, it, es, fr, de, ptXLSX to Markdown
Convert Excel (.xlsx) spreadsheets to GitHub-Flavored Markdown tables, entirely in your browser.
Available: en, it, es, fr, de, ptPDF to Markdown
Convert native, text-layer PDF documents to GitHub-Flavored Markdown, entirely in your browser.
Available: en, it, es, fr, de, ptEPUB to Markdown
Convert EPUB eBooks to GitHub-Flavored Markdown, entirely in your browser.
Available: en, it, es, fr, de, ptRTF to Markdown
Convert Rich Text Format (.rtf) documents to GitHub-Flavored Markdown, entirely in your browser.
Available: en, it, es, fr, de, ptODT to Markdown
Convert OpenDocument Text (.odt) files from LibreOffice/OpenOffice to GitHub-Flavored Markdown, entirely in your browser.
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
Compress CSV and XLSX files online for free, losslessly, with no upload. Shrink spreadsheets past email attachment limits and upload caps in seconds, straight in your browser.
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
Extract every email address from a CSV, Excel or text file in one pass — scans all columns and free text, deduplicates, and exports a clean list. Runs entirely in your browser, nothing uploaded.
Available: en, it, es, fr, de, ptPhone Extractor
Scrape all phone numbers found in a text file or CSV, across every column.
Available: en, it, es, fr, de, ptURL Extractor
Scrape all http(s) links found in a text file or CSV, across every column.
Available: en, it, es, fr, de, ptIP Extractor
Scrape all IPv4 addresses found in a text file or CSV, across every column.
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, ptCSV Forecasting & Trend Prediction
Free online CSV forecasting tool using linear regression.
Available: en, it, es, fr, de, ptMonte Carlo Simulator
Run Monte Carlo simulations and what-if scenarios on your CSV, in the browser.
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
Normalize or standardize numeric CSV columns online, free. Min-max scale to 0-1 or apply Z-score standardization before feeding data into a clustering, regression, or gradient-descent model.
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 (Variant Call) to CSV
Convert genomic Variant Call Format (VCF) files into CSV rows with chromosome, position, reference/alternate alleles and INFO fields. For phone/address book .vcf files, use the vCard to CSV converter instead.
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