Complete round-trip spreadsheet engineering for mock databases. Convert any REST resource or custom collection into real .csv or .xlsx spreadsheet files, and import tabular data back into your sandbox with strict column schema validation.
Export any system resource or custom collection as standard RFC 4180 CSV or native Excel (.xlsx) workbooks:
100 articles with title, body, and user_id foreign keys.
10 user profiles with nested dot-notation address.* and company.*.
500 comments with postId, author name, email, and body text.
200 todos with boolean completion status and userId.
Catalog items with SKU, price, stock boolean, and category.
Store orders with customer details, order totals, and fulfillment status.
Upload a .csv or .xlsx file or paste CSV text to import into your sandbox with schema validation:
| title | body | userId |
|---|---|---|
| Automated Test Post 1 | Dispatched via CSV bulk spreadsheet import | 1 |
| Automated Test Post 2 | Second row parsed with strict column validation | 2 |
| Automated Test Post 3 | Third item merged into session overlay database | 1 |
Every imported row is strictly validated against database constraints and system columns before entering your overlay:
| Resource | Required Headers | Optional / Nested Columns | Automatic Transformations |
|---|---|---|---|
| posts | title, body | userId (or user_id) | userId is integer coerced (default 1). System metadata (id, createdAt) stripped for new local IDs. |
| users | name, username, email | phone, website, address.*, company.* | Validates email RFC format. Unflattens dot notation (address.city) into nested JSON structures. |
| comments | name, email, body | postId (or post_id) | Validates email format. Post ID defaults to 1 if omitted. |
| todos | title | completed, userId | Coerces "true"|"false"|"1"|"0" to strict boolean values (defaults to false). |
| custom_* | Any non-empty property | Any custom domain columns | Auto-coerces numbers and booleans. Rejects prototype pollution (__proto__). Max 500 rows/batch. |
Code patterns for importing and exporting spreadsheet files programmatically: