Feed File Clinic: a worked example

Inspect uneven rows, preserve text IDs, normalize CSV quoting and protect spreadsheet formula cells before importing a catalog.

A practical example

Paste a CSV or open a UTF-8 text file. Choose its delimiter, review the report, then download the repaired file. Original files are never overwritten. Numeric-looking identifiers stay text in this tool; import them as text in your spreadsheet.

Input

sku,title,price
001,"Small bowl, blue",12.50
002,=1+1,9.00

Actual tool output

{
  "changes": "Formula protection adds an apostrophe. Quoting alone does not protect formulas.",
  "columns": 3,
  "data_rows": 2,
  "formula_cells_escaped": 1,
  "leading_zeros": "Preserved as text; select text columns when importing into spreadsheets.",
  "trimmed_cells": 0
}

This example was executed by the same engine shipped in the product. The release passed 10 executable regression checks. Large reports can be viewed and downloaded in full in the workbench.

Use it in your own workflow

Open Feed File Clinic to try the online tool. The optional paid pack adds an offline copy, editable source, regression checks and a commercial customization license. Test it on representative inputs before relying on it.

Leave a Reply

Discover more from Agen-tex

Subscribe now to keep reading and get access to the full archive.

Continue reading