FAQ
Frequently Asked Questions
Everything you need to know about Data File Tool — 51 free tools across CSV, JSON, Excel, import validation, and developer utilities, plus 260+ guides. All processing runs locally in your browser with no uploads or accounts.
What file formats does Data File Tool support?
We support CSV, JSON, Excel (.xlsx/.xls), SQL queries, and plain text. Each format has dedicated tools for validation, transformation, and quality scoring — all processed locally in your browser. Browse toolkits for CSV, JSON, Excel, import validation, and developer utilities from the home page.
What is a Health Score?
A Health Score is a 0–100 rating with an A–F grade that measures data quality — missing values, duplicates, encoding issues, type consistency, and format-specific problems — with actionable recommendations. Health Score is available on CSV, JSON, and Excel file tools, plus platform import validators.
How do I validate a file online?
Choose the validator for your format — CSV Validator, JSON Validator, or a platform-specific import validator (Shopify, HubSpot, Salesforce, Mailchimp, Airtable). Drop your file and review results instantly. For deeper analysis, use the Health Score tool for your format.
Are my files uploaded to a server?
No. All processing happens locally in your browser. Your files never leave your device — whether you are validating CSV, JSON, Excel, SQL, or text.
Do I need to create an account?
No account is required. All 51 tools are free and work instantly without sign-up.
Is there a file size limit?
There is no hard server limit because files are not uploaded — processing uses your browser memory. We recommend files under 50 MB for reliable performance. Very large files may be slow or fail depending on your device; try splitting the file first with our CSV or Excel splitter tools.
Do you have validators for Shopify, HubSpot, or other platforms?
Yes. Our Import Validation toolkit includes platform-specific CSV validators for Shopify, HubSpot, Salesforce, Mailchimp, and Airtable. Each checks your export against common import requirements and combines results with a CSV Health Score.
Where can I find guides and tutorials?
Visit the Guides section for 260+ articles — five guides per tool covering how-to steps, common mistakes, best practices, when to use the tool, and troubleshooting. Each guide links back to the live tool and its toolkit hub.
Can I compare or convert Excel and JSON files?
Yes. Excel tools cover compare, deduplicate, split, column extract, and Excel-to-CSV conversion. JSON tools include validate, format, minify, compare, diff, JSON-to-CSV, and string escape/unescape — all in your browser.
What SQL and text tools are available?
Developer tools include SQL formatter, minifier, beautifier, and query analyzer, plus text utilities — remove duplicates, remove blank lines, sort lines, count words, case converter, line joiner, grep, and reverse lines.