Online Tool Store
103 Articles
Data & CSV
Articles filed under Data & CSV.
Showing 22–42 of 103 articles
📊 Data & CSV
How to Convert a JSON Array of Objects Into CSV
Convert a JSON array of objects into properly quoted CSV rows, with the header built automatically from every key across the array.
🔍 Data & CSV
How to Find Out Why a CSV Import Failed
Detect the real type of every CSV column, list the values that do not fit, and fix the handful of rows that make an import reject an entire file.
🔄 Data & CSV
How to Pivot Data Between Long and Wide
Reshape data between long and wide formats, choose the right one for storage or presentation, and catch the duplicate keys that silently lose rows.
🔎 Data & CSV
How to Profile a Dataset Before You Use It
Generate a profile of types, null rates, cardinality and outliers before analysing data, and find the constant columns and bad values that break conclusions.
🧮 Data & CSV
How to Run SUM/AVG Formulas on CSV Without a Spreadsheet
Paste CSV data and apply simple spreadsheet-style formulas — SUM, AVG, MIN, MAX, COUNT — to a chosen column, entirely client-side.
🕰️ Data & CSV
How to Turn a Dated CSV Into a Timeline
Convert a CSV with start and end dates into timeline data, normalise date formats, and catch the reversed and unparseable dates before they render.
text Data & CSV
How to Use Address Normalizer
A quick browser-based tool for the task.. Learn the practical steps, common mistakes, and the quickest way to use address normalizer in your browser.
text Data & CSV
How to Use Column Type Inferencer
A quick browser-based tool for the task.. Learn the practical steps, common mistakes, and the quickest way to use column type inferencer in your browser.
text Data & CSV
How to Use CSV Header Aligner
A quick browser-based tool for the task.. Learn the practical steps, common mistakes, and the quickest way to use csv header aligner in your browser.
text Data & CSV
How to Use Date Format Normalizer
A quick browser-based tool for the task.. Learn the practical steps, common mistakes, and the quickest way to use date format normalizer in your browser.
➕ Data & CSV
How to Add a Calculated Column to a CSV
Add a computed column to a CSV using arithmetic across existing fields, and decide what blanks and text-formatted numbers should do before running it.
chart Data & CSV
How to Build a Gauge Chart
Create a gauge-style chart from a value, range, and thresholds for quick status visualizations that are easy to scan in the browser.
🌊 Data & CSV
How to Build a Waterfall Chart That Balances
Show how an opening figure becomes a closing one through a sequence of changes, and make sure the steps actually reconcile before you present it.
📊 Data & CSV
How to Chart Likert Survey Responses
Use a diverging stacked bar to show agreement across survey questions, and report distributions rather than averaging an ordinal scale.
database Data & CSV
How to Clean CSV Number Columns
Clean number formatting in CSV data by stripping symbols, fixing separators, and standardizing decimals before the file goes anywhere else.
database Data & CSV
How to Convert Parquet to CSV
Preview a Parquet to CSV conversion workflow with column selection and row sampling so you can export data locally with more control.
code Data & CSV
How to Convert SQL to Pandas
Convert common SQL-style query patterns into a pandas-oriented outline for notebook work so you can move between query and data-frame thinking.
🔧 Data & CSV
How to Fix Mojibake and Broken CSV Encoding
Upload a CSV with garbled characters and get it re-decoded correctly and saved as clean UTF-8, entirely in your browser.
⏱️ Data & CSV
How to Resample Time Series Data Correctly
Change a time series to a coarser interval without corrupting it, choosing sum or mean based on what the value represents and marking partial periods.
✅ Data & CSV
How to Score a CSV for Missing Values and Issues
Upload a CSV to check it for missing values, duplicates, formatting issues, and outliers, with an overall quality score, entirely in your browser.
📊 Data & CSV
How to Summarize Survey CSV Exports by Question
Upload a survey response CSV and get an automatic percentage breakdown for each question, entirely in your browser.