petti.oneDownload for Apple silicon

Validate spreadsheet data in SQLite before sharing it

A spreadsheet export looks fine until an identifier loses its leading zeros or a blank value changes meaning. Use a separate SQLite file to inspect what the import actually contains.

Keep an untouched source

Export the relevant sheet as CSV and keep the original spreadsheet. CSV carries text rows and column separators; it does not carry formulas, multiple sheets, formatting or database constraints. Petti imports CSV into SQLite rather than directly opening an XLSX workbook.

Validate a small sample first

  1. Create a separate blank SQLite database with an editing license.
  2. Import the CSV into a new table after reviewing the header and delimiter.
  3. Check the exact row count and inspect representative records.
  4. Inspect stored types for identifiers, dates and amounts.
  5. Check missing values and duplicate business identifiers according to your actual rules.

Follow the CSV tutorial for a three-row sample with postal codes 00123, 04567 and 01001. The expected stored type is text. A valid import cannot restore zeros that were already lost in the spreadsheet export.

Decide what a correction means

Two identical names do not necessarily identify the same person. An empty string is not automatically the same as SQL NULL. A customer number should not be summed just because it contains digits. Define these rules before deduplicating, normalizing or replacing values.

Petti saves edits to the database immediately. Capture a snapshot before a batch change and verify the result afterward. Keep changes in a working copy until they have passed your checks. An import is not an automatic merge against an existing customer list.

Export and check the handoff

Return to Data and choose an explicit CSV export scope. Reopen the exported text to check column names and tricky values. If the receiving spreadsheet application guesses types, tell the recipient which columns are identifiers and should be imported as text.

This workflow helps validate local tabular data. It does not preserve the original workbook or replace application-specific business validation. Browsing and exporting are free; database creation, imports and corrections require an editing license.

Updated