How to convert excel column headers to a type-safe trpc router in seconds
- Step 1Upload your data Excel file — Drop the Excel file containing your data model columns onto the tool.
- Step 2Enter router name — Type the router name (e.g. 'usersRouter', 'productsRouter') — the entity name is inferred from it.
- Step 3Copy generated code — Copy the generated .ts file into your tRPC server directory.
- Step 4Replace placeholders — Swap the ctx.db.* placeholder calls with your Prisma, Drizzle, or custom data access layer.
Frequently asked questions
What tRPC version does the generated code target?+
tRPC v11 using the router() and publicProcedure/protectedProcedure pattern. The import paths follow @trpc/server.
How are column types inferred?+
The tool samples the first 50 rows. Columns with all-numeric values become z.number(), ISO-date columns become z.string(), booleans become z.boolean(), everything else z.string().
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.