Clean inconsistent records, organize related tables, and preserve the steps that turn an export into a useful result.
Start with cleanup when names or categories need normalization. Use related tables when several datasets need stable identifiers and ongoing maintenance.
Start with the input and the result you need.
Data workflowRun product spreadsheet cleanup with OpenRefine: trim names, standardize category casing, preserve IDs, and review exceptions before reuse.
Automation workflowPrepare an AI weekly report from complete source windows, checked totals, explicit unknowns, and a practical next action.
Research workflowBuild a supplier quote comparison with source-linked quantities, currencies, minimum orders, shipping, and unresolved terms before choosing.
Check the setup and running requirements before you start.
Use OpenRefine to clean supplier CSV names and categories, preserve product IDs, review exceptions, and save repeatable operations.
Explore guide ↗Use Grist to import a practice CSV, check dates and data types, and reconcile totals before preparing a report.
Explore guide ↗Choose the specific decision or check that is holding up the task.
Keep leading zeros in product IDs through CSV import and export, inspect changed values, and preserve authoritative supplier identifiers.
Read the guide ↗Review duplicate product records before merging or deleting, separating repeats, legitimate variants, and conflicting source updates.
Read the guide ↗
Check CSV dates and timezones before reporting: separate calendar days from timestamps, preserve source strings, and verify boundaries.
Read the guide ↗Use a CSV import checklist to review headers, match keys, blanks, units, and expected changes before repeating an import.
Read the guide ↗Check PDF quote extraction against original pages for shifted amounts, currencies, quantities, and detached conditions before comparing prices.
Read the guide ↗