📊
Free Online Data AnalyzerCSV, Excel, JSON, REST API and OData
Find duplicate rows, missing values and data errors. Clean data, view charts and export results.
Up to 100,000 API Rows🔒 Files Stay on Your Device⚡ Free
🔁 Duplicate Rows⬜ Missing Values⚡ Type Check📊 Statistics📉 Outliers💡 Insights🔧 Clean Data📈 Charts⬇️ Export📡 REST APIOData
📊
Drop your data file here
or click to browse CSV, Excel (.xlsx / .xls) or JSON
CSVXLSXXLSJSON
Related Tools
Free tools that complement your data workflow.
Analyze CSV, Excel, JSON and API Data Online
Open a CSV, Excel (.xlsx or .xls) or JSON file, or connect a REST API or OData API. Find duplicate rows, missing values, data type errors and unusual values without writing code. Filter table columns, view statistics and charts, remove duplicates and download your working data as CSV, Excel or JSON. Files are processed on your device. API connections fetch data directly from your service into your browser.
How do I find and remove duplicate rows in CSV?
Upload your file, then go to the Clean Data tab. Click "Remove Duplicate Rows" to deduplicate instantly. The row count updates and you can download the cleaned file as CSV, Excel or JSON.
Can I fill null values instead of deleting rows?
Yes. In the Clean Data tab, choose "Fill Nulls" with options to fill with 0, with the column mean, or with an empty string. This lets you keep all rows while fixing missing values.
What does the Dashboard tab show?
The Dashboard tab auto-generates bar charts for numeric columns showing value distribution, and donut charts for categorical columns showing the most frequent values. It gives you an instant visual overview without any configuration.
Can I analyze REST API and OData data online?
Yes. Use Connect REST API for JSON endpoints with an optional bearer token. Use Connect OData API for OData v2, v3 or v4 JSON collections with a username and password, bearer token or no authentication. Both connections require the service to allow browser access through CORS.
Can I filter an OData API before analysis?
Yes. Enter supported query options such as $filter, $select, $expand, $orderby, $top and $skip. You can also add custom parameters and function parameter aliases. The OData connection follows next-page links automatically.
How many records can I analyze?
REST API and OData imports load up to 100,000 records. A smaller $top value limits an OData import further. File analysis has no fixed row cap, but available browser memory and device speed determine the file size you can process.