Export Calendly events to JSON
How to export Calendly scheduled events as CSV, convert them to JSON in the browser, and automate the same pipeline with the Calendly API.
Calendly makes it easy to schedule meetings, but getting your event data into a CRM, a reporting dashboard, or a custom script usually means dealing with CSV exports. This guide shows how to export your Calendly events and convert them into clean JSON — either as a one-off file or as the start of an automated pipeline.
Export scheduled events from Calendly
- Sign in to Calendly and open the Events page.
- Use the date filters to select the range you want to export.
- Click Export and choose CSV. The download will include one row per scheduled event.
A typical Calendly CSV export includes columns such as:
Event Type NameEvent DateEvent Start TimeEvent End TimeDuration (min)Invitee NameInvitee EmailPhone NumberLocation- Any custom questions you have added to the booking form.
Convert the Calendly CSV to JSON
Once you have the CSV file, open it in a text editor, copy the contents, and paste them into the Calendly to JSON converter. The first row becomes the JSON keys, and every event becomes an object in a JSON array. Numbers and booleans are coerced automatically, so Duration (min) becomes a number and the active flag becomes a boolean.
Because the conversion runs in your browser, attendee emails and phone numbers never leave your machine. You can verify this by checking the network tab — no request is sent.
Example output
A CSV with two events produces JSON like this:
[
{
"Event Type Name": "30 Minute Meeting",
"Event Date": "2024-07-01",
"Event Start Time": "09:00",
"Event End Time": "09:30",
"Duration (min)": 30,
"Invitee Name": "Ada Lovelace",
"Invitee Email": "ada@example.com",
"Phone Number": "+1 555-0100",
"Location": "Zoom"
},
{
"Event Type Name": "60 Minute Meeting",
"Event Date": "2024-07-02",
"Event Start Time": "14:00",
"Event End Time": "15:00",
"Duration (min)": 60,
"Invitee Name": "Alan Turing",
"Invitee Email": "alan@example.com",
"Phone Number": "+1 555-0101",
"Location": "Phone call"
}
]Automating the export with the Calendly API
If you need fresh data on a schedule, the Calendly API is the better route. A typical flow:
- Create a personal access token in Calendly's integrations settings.
- Call
GET /v2/scheduled_eventsto list events. - Call
GET /v2/scheduled_events/{uuid}/inviteesfor each event to get attendee details. - Store the JSON in your database or data warehouse.
The API returns richer data than the CSV export — including UTM parameters, rescheduling history, and cancellation reasons — so it is worth the extra setup for production workflows.
Common use cases
- CRM import: map
Invitee Emailto a contact andEvent Type Nameto a meeting type. - Analytics: count meetings per week, track no-shows, or compare conversion rates across event types.
- Backup: keep a JSON snapshot of scheduled events outside Calendly.
- Webhook handler: use the Calendly webhook payload as the source of truth and store the same shape in your own database.
Frequently asked questions
- Can I export Calendly events to JSON directly?
- Calendly does not offer a JSON export in the UI. Export as CSV, then use the Calendly to JSON converter to turn it into JSON.
- Does the converter keep my data private?
- Yes. The CSV is parsed entirely in your browser. Nothing is uploaded or logged.
- What about custom Calendly questions?
- Custom questions appear as additional CSV columns. They become JSON keys just like the standard fields.
- Can I convert Calendly data to SQL instead?
- Yes. Use the CSV to SQL tool to generate an
INSERT INTO ... VALUESstatement from the same CSV export.
Whether you export once a month or automate the pipeline, turning Calendly events into JSON makes the data portable across every tool in your stack.