CSV is not Excel
CSV export is easy — but customers want styling, formulas, multiple sheets and column widths. A semicolon-separated CSV is not a professional report.
Back to overview Excel generation
JSON in, styled XLSX out.
Generate professional Excel workbooks from JSON data. With formulas, styling, freeze panes and cell protection. Or fill existing Excel templates. Plus conversion between XLSX, CSV and JSON.
1 credit per operation. 100 credits/month free.
Why Excel export in software is such a pain
Excel libraries are complex
Apache POI, EPPlus, openpyxl — all powerful, all with a steep learning curve. Hundreds of lines of boilerplate for a simple report.
Server-side gets ugly
Generating Excel on the server means: library dependencies, memory management, temporary files. Even more fun in a container environment.
Excel generation in three variants
1
Generate from JSON
Send data, columns, styling and formulas as JSON. Receive a finished XLSX file.
2
Fill template
Upload an existing Excel template. Dokmatiq fills the defined areas with your data.
3
Convert
XLSX → CSV, CSV → XLSX, XLSX → JSON and back. Including sheet selection and encoding options.
What you can do with it
Workbooks from JSON
Multi-sheet XLSX files with data, headers, column widths and sheet names.
Cell styling
Font, colour, borders, alignment, number formats — per cell or as templates.
Formulas
Insert Excel formulas into cells. SUM, VLOOKUP, IF — everything Excel understands.
Freeze panes
Fix rows and columns for scrollable tables with fixed headers.
Cell protection
Protect individual cells or ranges from editing. Sheet protection with password.
Template filling
Fill existing Excel templates with variable data. Formatting stays intact.
Perfect for
Reports & analytics
Monthly reports, sales figures, project overviews as professional Excel files from your application.
Data export for clients
Clients expect Excel, not CSV. Deliver styled workbooks with formulas and ready-made pivot structures.
Accounting & bookkeeping
Structured Excel exports for import into accounting software. Columns, formats and encoding just right.