Dashboard
Capital Deployed
—
Total Profit
—
In Inventory
—
Avg ROI
—
on sold watches
Current Inventory
| Watch | Cost Basis | Break Even | Days Held |
|---|
Profit by Brand
Inventory
Watch / StageCost BasisMSRPListed AtPotential ProfitDays HeldPlatform
Sold History
| Brand / Model | Ref / Serial | Cost Basis | Sold Price | Platform | Net Profit ↕ | ROI ↕ | Hold Days | P/Day | Photos |
|---|
Contacts
👤
Select a contact to view details
Invoices
Sent
Received
Import / Export
Bring in existing data from spreadsheets — or export what you have
⚡ Convert Your Existing Spreadsheet with AI
Already tracking watches in Excel or Google Sheets? Use this copy-paste prompt to convert your data in under 2 minutes — no manual reformatting needed.
Step 1 — Copy this prompt
I have a watch inventory spreadsheet I need to convert to a specific CSV format for import into DialTrader.
Here are the EXACT column headers I need in the output CSV:
brand, model, ref, serial, year, purchase_date, purchase_price, tax, shipping_in, other_fees, listed_price, platform, condition, box_papers, notes
Rules:
- Output ONLY the CSV — no explanation, no markdown backticks, no extra columns
- Dates must be in YYYY-MM-DD format (e.g. 2024-01-15)
- Numbers with no dollar signs, commas, or symbols (e.g. 12500 not $12,500)
- If a column has no data, leave it empty (just a comma)
- condition should be text like: Mint, Excellent, Good, Fair
- box_papers should be: Full Set, Box Only, Papers Only, No Box/Papers, or empty
- platform should be the main platform the watch is listed on, or empty
- First row must be the header row exactly as shown above
Here is my spreadsheet data:
[PASTE YOUR DATA HERE — copy from Excel/Google Sheets and paste directly]
Step 2 — Use ChatGPT or Claude
1. Go to chat.openai.com or claude.ai
2. Paste the prompt above
3. Replace
4. Send — the AI will output a clean CSV
5. Copy the AI's output into a text file, save as
2. Paste the prompt above
3. Replace
[PASTE YOUR DATA HERE] with your actual spreadsheet data (copy from Excel/Sheets)4. Send — the AI will output a clean CSV
5. Copy the AI's output into a text file, save as
my-watches.csv
Step 3 — Drop the CSV below
Drop your converted CSV into the Inventory import zone. DialTrader will show you a preview before importing anything — you can cancel if something looks off.
Tip: If the AI output has backtick fences (```csv ... ```) just delete those lines — keep only the comma-separated rows. Numbers sometimes come back with quotes — that's fine, the importer handles it.
Importing Sold History
Use this separate prompt for watches you've already sold.
Convert my sold watch data to this EXACT CSV format (output CSV only, no explanation):
brand, model, ref, serial, year, purchase_date, purchase_price, tax, shipping_in, other_fees, sale_date, sold_price, platform_fee, payment_fee, shipping_out, platform, notes
Rules: dates YYYY-MM-DD, numbers no symbols, empty cell = empty comma, first row = headers.
[PASTE YOUR SOLD WATCH DATA HERE]
Import Inventory
Drop Inventory CSV Here
or click to browse
Import Sold History
Drop Sold History CSV Here
or click to browse