Convert Excel to REST API — Step-by-Step Guide
Have data in Excel or CSV? Turn it into a live REST API in minutes. Upload your file, map columns to your schema, and serve JSON to any client.
Step 1: Create a project and API
Create a new project in apismaker and add an API. Define the path (e.g. /products) and the entity fields that match your data.
Step 2: Upload your Excel or CSV file
Go to the Data Import section and upload your file. apismaker supports .xlsx, .xls, and .csv. The first row is used as column headers.
Step 3: Map columns to entity fields
Preview your data and map file columns to your API entity fields. You can include or exclude columns, and use dot notation for nested objects (e.g. user.address.city).
Step 4: Use your API
Your data is now served as JSON. GET requests return the data with optional filtering and pagination. Share the API URL with your team or integrate it into your app.