xlPort - the Excel API
Generate and read Excel files with a single line of code!
Step 1
Prepare template
Tag cells with names and data as Excel tables.
Step 2
Call xlPort API
cat <MY FILE>.xlsx | curl -X PUT --data-binary @- https://api.xlport.io/import --header "Authorization: <APIKEY>" -O -J
Features
Import from Excel
- Extract data from tables and individual cells
- Specify which information should be retrieved or get all available data
Export to Excel
- Convert arbitrary JSON to custom Excel template
- Populate tables and cells
- Update calculation, formats, etc. based on exported data
- Include any additional Excel logic into templates (e.g. VBA macros, pivot tables. etc.)
Overall
- Ready to use SDKs for easy integration
- Highest performance
- Support any Excel format (xls, xlsx, xlsm, xlsb) as well as Google Sheets
Playground
Drop any Excel file here to retrieve its contents as JSON
Pricing
Free
- Up to 20 calls per day
- All features
- SDKs available
Free for OSS
Starter
$199/month
- Up to 200 calls per day
- Export to Excel
- SDKs available
Professional
$399/month
- Up to 1,000 calls per day
- Import & export
- SDKs available
- DPA for GDPR compliance
- 1h implementation support to get started
- Support ticket SLA <24hrs
Enterprise
Contact us
- Unlimited calls
- All features
- SDKs available
- On premise