Data & Database Workflows (page 10 of 40)
PostgreSQL, SQL, CSV, JSON, Excel, PDF, and conversion pipelines — practical workflows for working with structured data safely.
- Excel Scientific Notation on Long Numeric IDs: Prevention
A practical guide to stopping Excel from corrupting long numeric identifiers through scientific notation, rounding, or type coercion.
- Excel's List Separator Setting and “Mystery Semicolon” CSVs
A practical guide to understanding Excel’s list separator behavior so semicolon CSV files stop surprising your pipelines.
- "Extra columns" Error on Import: a Systematic Fix Path
A practical guide to tracking down extra-columns errors in CSV files without guessing, hand-editing blindly, or hiding structural problems.
- Fixed-width vs CSV: Telling Them Apart and Converting Safely
A practical guide to telling fixed-width files apart from CSV and converting them safely without shifting columns, trimming meaningful spaces, or breaking downstream imports.
- Foreign Keys and CSV Loads: Load Order Templates
A practical guide to loading CSV data with foreign keys without breaking referential integrity, scrambling load order, or relying on manual retries.
- Format Checker vs Validator: What Each Layer Should Catch
A practical guide to separating format checks from validation rules so CSV pipelines fail for the right reasons and produce clearer error messages.
- Future of Tabular Interchange: CSV vs Parquet vs Iceberg (Pragmatic Take)
A practical guide to choosing between CSV, Parquet, and Iceberg without turning a data-format decision into ideology.
- Google Ads CSV Exports: Columns That Change with Account Settings
A practical guide to understanding why Google Ads CSV exports do not always have stable columns, and how to design imports that survive account-level variation.
- Google Sheets: Avoiding Automatic Type Coercion on Import
A practical guide to keeping Google Sheets from quietly reinterpreting your imported data as dates, numbers, percentages, or scientific notation.
- Google Sheets CSV Export Quirks Teams Should Document
A practical guide to the Google Sheets CSV export quirks that quietly break downstream imports when teams fail to document them.