Data & Database Workflows
PostgreSQL performance, schema design, analytics, format conversion, and data hygiene for teams working across databases and file-based workflows.
391 articles in this topic
Tools for this topic
Free, privacy-first utilities in your browser — no uploads required for most workflows.
- CSV guides (topic index)All CSV-tagged articles: validation, encoding, conversion, and tabular data workflows.
- CSV SuiteClient‑side CSV tools: 15 converters, validators, and analyzers. No upload.
- Universal ConverterConvert JSON ↔ YAML ↔ XML ↔ CSV ↔ Excel in your browser.
- CSV to JSON ConverterConvert CSV files to JSON instantly in your browser. No uploads required. Perfect for APIs, web apps, and data pipelines. Free, private, and secure.
- JSON to CSV ConverterConvert JSON arrays into CSV in your browser with upload, copy and download.
- CSV ValidatorFree CSV validator that checks for malformed rows, duplicate headers, delimiter issues, and encoding problems. Runs entirely in your browser - no uploads required.
- Spreadsheet Analytics & BI
A comprehensive pillar page for spreadsheet analytics and BI covering the tools, workflows, decisions, and learning path teams use to move from spreadsheets to scalable reporting and dashboards.
- Excel Guide for Analytics, Reporting, and Dashboards
A comprehensive Excel pillar page covering formulas, functions, pivots, dashboards, data cleanup, business reporting, common workflows, and the best path to advanced spreadsheet analysis.
- Google Sheets Guide for Reporting, Analysis, and Collaboration
A complete Google Sheets pillar page covering formulas, functions, collaboration, dashboards, data cleanup, reporting workflows, common use cases, and the best path to stronger spreadsheet analysis.
- Power Query Guide for Data Cleanup, Transformation, and Reporting
A complete Power Query pillar page covering data import, cleanup, transformation, merges, append workflows, refresh patterns, common use cases, and the best path to stronger spreadsheet analytics.
- Power BI Pillar Page
A Power BI pillar page linking dashboards, DAX, modeling, refresh, and reporting guides in one place.
- DAX Guide for Measures, Context, and Power BI Modeling
A complete DAX pillar page covering measures, context, time intelligence, model-aware calculations, common DAX patterns, and the best learning path for stronger Power BI reporting.
- SQL Spreadsheet Bridges Pillar Page
A complete pillar page on SQL spreadsheet bridges covering Excel and Google Sheets connections, imports, exports, Power Query, reporting workflows, validation, governance, automation, and when to move from spreadsheets into databases.
- Errors Fixes Pillar Page
Use this pillar page to navigate the most common spreadsheet and BI errors, understand what type of problem you are dealing with, and choose the right fix path across Excel, Google Sheets, Power Query, Power BI, DAX, and SQL-connected workflows.
- Templates Dashboards Pillar Page
Use this pillar page to navigate templates and dashboards across Excel, Google Sheets, Power Query, and Power BI, compare common workflow patterns, and choose the right reporting setup for your team.
- Stripe CSV exports: reporting categories vs balance transactions
A practical guide to Stripe CSV exports that explains when reporting categories help, when balance transactions are the real source of truth, and why they are not interchangeable.