Before you start
- A Vern account at app.vern.so.
- A sample export from a real (or fake) customer of yours — CSV, Excel, a SQL dump, XML, or a ZIP of those.
1. Create your templates
A template defines what your data should look like — the columns you need, and the rules each one has to pass.- Go to Templates and click New.
- Choose Create with AI to have an AI draft your templates from a schema,
spreadsheet or API docs, Upload LinkML file if you already have a
vern_templates.yaml, or Create from scratch. - Review the columns. Tighten anything the AI got wrong.
2. Create a company
A company represents one customer you’re onboarding. It holds their workbook (one sheet per template), their files, and what Vern learns about them.- Go to Companies and click Create.
- Enter the customer’s Name, and optionally the Source system they’re moving off.
- Pick the Templates that become sheets in their workbook, then click Create Company.
3. Import the data
Vern takes you straight to the import page.- Drop in the customer’s files and click Start import.
- The migration agent reads them, maps them onto your templates and shows a Preview. Answer any questions it asks.
- When the preview looks right, click Run import.
4. Check it
Open a sheet. Invalid cells are tinted red. Fix single cells by hand, or ask the workbook chat to fix a whole column. Spot-check and fix →5. Send it to your app
Click Export in the workbook header.- CSV — download one sheet, or a ZIP of several.
- Writer — write the rows straight into your app’s API.
Next steps
- How import works — the agent-driven import in depth.
- Migration API — automate everything from your backend.