📊CSV Import Templates

Events/Calendar Import

Event and calendar entry CSV for scheduling systems.

Explanation

Format for importing events with dates, times, locations, and attendees.

Examples

Events CSV

Output

title,startDate,startTime,endDate,endTime,location,description,attendees,allDay
Team Meeting,2024-12-20,09:00,2024-12-20,10:00,Conference Room A,Weekly sync,"john@example.com,jane@example.com",false
Company Holiday,2024-12-25,,,,,Christmas Day,,true
Product Launch,2024-12-30,14:00,2024-12-30,16:00,Main Hall,Q4 product launch event,"all@company.com",false

Code Examples

JavaScript

// Import events to calendar
async function importEvents(csvData) {
  const events = parseCSV(csvData);
  
  return events.map(event => ({
    title: event.title,
    start: event.allDay === 'true' 
      ? new Date(event.startDate)
      : new Date(`${event.startDate}T${event.startTime}`),
    end: event.endDate 
      ? (event.allDay === 'true'
        ? new Date(event.endDate)
        : new Date(`${event.endDate}T${event.endTime}`))
      : null,
    location: event.location,
    description: event.description,
    attendees: event.attendees ? event.attendees.split(',') : [],
    allDay: event.allDay === 'true'
  }));
}

Try it Now

Open in CSV/JSON Converter

💡 Tips

Use ISO date format (YYYY-MM-DD)
Time in 24-hour format (HH:MM)
All-day events can omit times
Separate multiple attendees with commas
Include timezone for remote teams
Use recurring field for repeat events

⚠️ Common Pitfalls

Timezone issues for international teams
End time must be after start time
All-day events need special handling
Outlook vs Google Calendar format differences
Large attendee lists may need truncation