CSV / Excel / JSON to Data quality report

Data Quality Checker

Find empty values, duplicates, mixed types, and outliers. UChartX adds empty cell, duplicate column, mixed type, and date parse checks, then lets you audit and export the result.

  1. 1Upload DataPaste, upload, or load a sample
  2. 2Check & DescribeReview fields and data quality
  3. 3VisualizeChoose and refine the chart
  4. 4Publish & ExportCheck context and download
Chart ready

Loaded sample: Website traffic by channel as CSV

Analyzer5 rows96/100 score
Browser-side processingNo account requiredUse small, non-sensitive datasets

Steps 1-2

Upload and check data

CSV or pasted tableUse a header row followed by one row per item. Commas, tabs, and copied spreadsheet rows are accepted.Month,Revenue Jan,12400 Feb,13850
Field inspectorOverride a type when the automatic detection is wrong.
5rows
3fields
100%filled
0issues
5 parsed row(s)

Website traffic by channel gives Data Quality Checker a different data shape for checking recommendations, controls, and exports.

Step 3

Visualize

Preview: Auto

Exports use report 1200x800 with the current title, source note, chart view, and watermark.

Chart viewChoose a view for this preview.

Auto: Use the best default for the current page and detected fields.

uchartx.com

Publish & Export checksTitle readySource note readyAuto preview selected
Channel: categorySessions: numberConversions: percent
Input shapeCSV / Excel / JSON

cleaning data before visualization

What this page addsempty cell, duplicate column, mixed type, and date parse checks

Find empty values, duplicates, mixed types, and outliers.

Export decisionData quality report

Avoid this workflow for large-scale data profiling.

Data Quality Checker workflow

Data Quality Checker is for cleaning data before visualization. It works with traffic channels, acquisition mix, and conversion signals, adds empty cell, duplicate column, mixed type, and date parse checks, and keeps the preview, checks, and exports tied to the data you entered.

From input to export

  1. Start with the traffic sample or paste your own CSV, Excel, JSON data.
  2. Treat the score as a checklist, not a final approval.
  3. Apply the specific fixes before exporting or publishing.
  4. Export Data quality report after the checks explain any remaining context or readability issues.

When to use

  • Use Data Quality Checker when you need to find problems before a chart is published.
  • It is a good fit for cleaning data before visualization.
  • It works best when your data resembles traffic channels, acquisition mix, and conversion signals.

When not to use

  • Do not use this workflow for large-scale data profiling.
  • Do not publish the result until title, unit, source, and export size have been reviewed.
  • Use another chart preview when the recommendations explain a better fit.

Controls that matter

  • Use the score panel to identify the next fix.
  • Apply safe fixes such as source note, Top N, or chart switch.
  • Export the audit summary after review.

Input and method

  • The parser normalizes rows into a browser-side table and never requires an account.
  • Field detection classifies traffic channels, acquisition mix, and conversion signals into number, date, category, or text fields.
  • The chart logic checks audit fit against the detected fields and the current page task.
  • The score combines data readiness, field mapping, chart fit, labels, accessibility, and data quality report export readiness.

Checks before export

  • Exporting the score without acting on the listed issues.
  • Exporting before adding a clear title, unit, or source note.
  • Ignoring the page limit: this workflow is not intended for large-scale data profiling.
  • Treating the score as approval instead of reviewing the specific fixes.

Export options

  • PNG and SVG exports use the current data quality report preview and selected size.
  • Markdown and mini report exports include title, source note, detected fields, score, and fixes.
  • HTML, JSON config, clean CSV, and alt text are available from the secondary export panel when data is valid.

Output limits

  • Very large datasets should be summarized before using this browser-side tool.
  • Avoid this workflow for large-scale data profiling.
  • Image-only chart recognition, cloud storage, and collaborative editing are not part of this version.
  • Generated summaries should be reviewed before publication.

FAQ

What data works best with Data Quality Checker?

Data Quality Checker works best with clean traffic channels, acquisition mix, and conversion signals that includes headers and enough rows to find problems before a chart is published.

What should I do with audit results?

Use the fixes as a publishing checklist and rerun the chart after changing labels, data shape, or export context.

Does UChartX upload my data?

Core chart creation runs in the browser. Avoid pasting private or regulated datasets into any web tool.

Can I export from Data Quality Checker?

Yes. This page supports the relevant export options listed for the tool: Data quality report.