Convert TSV Supplier Price List to PostgreSQL
Extract item numbers, product descriptions, unit pricing, and tier rates from TSV price lists directly into structured PostgreSQL rows.
Transform Supplier Price Lists into Structured Data
We capture every detail. Extract supplier metadata, SKUs, tier pricing, and order minimums into clean structured fields with zero manual entry required.
1Supplier
Who the prices come from and your account with them.
2Validity & currency
The list number, the date the prices apply from, and the currency they're quoted in.
3Items & list prices
One row per priced item, with its description, pack size, and list price.
4Quantity breaks
The lower prices printed for larger orders, such as 10+ and 25+.
5Terms & minimums
The payment terms, freight terms, and order minimums printed with the list.
Upload
Your supplier's TSV price list.
Check the columns
Preview the rows, then rename, remove, or reorder columns to match your import.
Export
Excel, CSV, JSON, XML, SQL, and more.
Compare new price lists against historical updates
Match incoming catalogs with previous price lists on SKU to surface rate changes, increases, and updates side by side.
kessler-price-list-2026-q3.tsv
Effective 2026-07-01 · 208 items
kessler-price-list-2026-q4.tsv
Effective 2026-10-01 · 212 items
joined on sku
| SKU | Description | Pack | Q3 List Price | Q4 List Price |
|---|---|---|---|---|
| KCK-SP-2040 | Stock pot, 40 qt | 1 EA | 89.00 | 93.50 |
| KCK-HP-1218 | Hotel pan, full size | CS / 6 | 87.00 | 87.00 |
| KCK-SB-0600 | Sheet pan rack | 1 EA | 212.00 | 224.00 |
| KCK-CB-1824 | Cutting board set | SET | 62.00 | 58.90 |
| KCK-TH-0100 | Probe thermometer | 1 EA | 18.75 | 18.75 |
| KCK-TG-1200 | Tongs, 12 in | 1 EA | 4.90 | 4.90 |
Convert price lists from your own code
The API runs the same conversion. Send each new price list from your own code and get rows back.
Explore the APIcurl -X POST "https://dataconverter.io/api/v1/convert/tsv-to-postgresql" \ -H "Authorization: Bearer YOUR_TOKEN_HERE" \ -F "file=@price-list-2026-q4.tsv" \ --output price-list-2026-q4.sql✓ 200 OK · price-list-2026-q4.sql · 212 items
Built for anyone handling supplier price lists
Whether you buy from suppliers or resell their products, get new prices into your systems without retyping them.
Procurement & purchasing
Load new supplier prices into your item master instead of keying them in one by one.
Distributors & resellers
Get new cost prices into a spreadsheet and work out your selling prices from there.
E-commerce teams
Update product costs in your store from the supplier's latest price list.
Finance & margin analysis
Put supplier prices next to your selling prices and spot where margins have shrunk.
Restaurants & facilities
Check your distributor's new prices before you place the next order.
Developers
Export to JSON or call the conversion API to feed price lists into your ERP or product catalog.
Set up once, reuse for every price list
Save your settings and data preparation steps as a template. Apply them to the next price list without setting them up again.
Frequently asked questions
Does it work with price lists from any supplier?
Yes. The price list is read as a document rather than matched against a fixed list of supplier templates, so a layout it has never seen before still comes out as rows.
Can I combine price lists from different suppliers into one file?
Yes. Convert each supplier's price list and save it as a dataset, then use Merge Data to stack them into one sheet. You map each supplier's columns to a shared set of columns, so lists with different headings still line up.
Which formats can I export to?
Excel (XLSX), CSV, JSON, XML, SQL, and more. Pick your target type on the upload page before you convert.