Guide - Google Calendar import - 10 minute read

Move spreadsheet events into Google Calendar without a format lottery.

Google Calendar accepts both CSV and ICS on a computer, but they solve different preparation problems. Choose the route deliberately, validate the schedule, and import into a test calendar before committing a large batch.

Open the private CSV / Excel to ICS converter

Start with the format decision

Google supports two imports, but they are not interchangeable

Google's documented desktop flow accepts files ending in .csv or .ics. A direct CSV is the shortest route when the sheet already uses Google's exact English field names and simple event semantics. An ICS is the better bridge when the source has arbitrary headers, starts as Excel, needs mapping and validation, or may also be imported into Outlook or Apple Calendar.

  • CSV

    Use direct CSV for a Google-shaped sheet

    Keep the file if it already has Subject and Start Date plus the documented optional columns. This avoids conversion, but you must satisfy Google's header and value rules yourself.

  • ICS

    Use ICS for an arbitrary export

    Map unfamiliar headers, choose explicit time semantics, review all-day boundaries and invalid rows, then create one portable calendar file without rewriting the source around one vendor.

Both routes are one-time imports. If the original schedule changes later, importing it again is not the same as maintaining a live sync. For an ongoing calendar shared between Google accounts, Google's help recommends calendar sharing rather than export and re-import.

Route A - direct CSV

Use Google's exact English CSV headers

Google requires Subject and Start Date. Its optional headers are Start Time, End Date, End Time, All Day Event, Description, Location, and Private. The headers must be written in English. All Day Event and Private use True or False.

Each row represents one event. Quote a field when its text contains a comma, otherwise the comma can create an extra column. Check that the spreadsheet exported a comma-separated file and did not silently change dates or times to locale-specific display values.

Direct CSV is deliberately narrow. It does not give you a portable UID, URL, category, or standards-shaped event container. More importantly, Google warns that repeating events imported from CSV may appear as a series of separate one-off events. If recurrence needs to remain editable as a rule, rebuild it in Calendar after import or use a source that exports a real recurring iCalendar component.

Route B - CSV or Excel to ICS

Map and inspect the event model before Google sees it

Open the private CSV to ICS converter, load CSV, pasted rows, XLS, or XLSX, and select the intended workbook sheet. Confirm the title, start and end dates, times, all-day flag, location, description, URL, categories, status, and optional UID. Suggestions use header names only; event text never drives hidden mapping.

Choose UTC only when the source clock values are already UTC instants. Choose floating local time when the written clock time should stay the same in the destination calendar. The converter does not guess a named zone from the browser or location. For an all-day row, the spreadsheet end is treated as inclusive and serialized as iCalendar's following, exclusive DTEND date.

Review skipped rows, optional-property warnings, duplicate UID signals, and matching title-plus-start signatures. Set the visible default duration for timed rows that have no usable end. Then download one .ics file containing every exportable event.

Google Calendar steps

Import the reviewed file into a deliberate destination

  • 01

    Open Calendar on a computer

    Sign in to the correct Google account, open Google Calendar, then choose Settings and Settings.

  • 02

    Open Import and export

    Use the left-side Import and export section, then choose Select file from your computer.

  • 03

    Choose the file and calendar

    Select the reviewed .ics or Google-shaped .csv. Choose the destination calendar explicitly; Google otherwise defaults to the primary calendar.

  • 04

    Import and inspect

    Click Import, then check a timed event, an all-day event, a multi-day event, a description containing punctuation, and the first and last dates in the batch.

These steps follow Google Calendar's official import help. If the source is a ZIP exported from another Google account, extract the individual ICS files first and import them one at a time.

Google-specific boundaries

An imported event is smaller than a meeting invitation

Google states that guests and conference data are not imported with an event. An email address in a source column does not become an invited attendee, and a video-meeting field does not recreate conferencing. Put an ordinary meeting URL in the mapped URL or description only when that disclosure is intentional, then add guests and conferencing inside Google Calendar after the import.

Imports also do not stay synchronized with the source file or another Google account. Treat the file as a reviewed snapshot. If the same batch must be corrected, the safest operational pattern is to import into a dedicated calendar that can be removed or replaced, rather than mixing an uncertain test with an established personal calendar.

Time and all-day review

Test the cases most likely to move

A floating 09:00 keeps a 09:00 wall-clock value in the importing calendar's local context; a UTC 09:00Z is an exact instant and can display at another local hour. Neither is automatically correct for a sheet that only says 09:00. Confirm what the source means before conversion.

For all-day events, inspect both single-day and multi-day rows after import. iCalendar end dates are exclusive, so an event displayed through Friday carries a Saturday DTEND. The converter performs that boundary adjustment once. Do not pre-add another day in the spreadsheet.

Troubleshooting

Use the failure shape to find the wrong layer

  • 01

    Google rejects a CSV

    Check exact English headers, required Subject and Start Date values, quoting around text containing commas, and the final .csv extension.

  • 02

    Events land on the wrong calendar

    The primary calendar is the default. Create or select a dedicated destination before pressing Import.

  • 03

    Times shift

    A UTC file is being displayed in the calendar's local zone, or a floating source lacked a defensible zone. Revisit the clock model instead of offsetting rows by guesswork.

  • 04

    Repeats are separate

    Google documents that CSV recurrence may arrive as one-off events. Recreate the recurrence rule in Calendar when the relationship matters.

Privacy and rollback

Keep private event text local, then make the first import reversible

Schedules can contain customer names, meeting links, locations, travel, and internal plans. The csvtodashboard converter parses, maps, validates, previews, and generates the ICS inside the browser tab. It does not upload event data or include file-derived values in audience measurement.

Create a temporary Google calendar for the first representative batch. Verify the result, remove that calendar if anything is wrong, fix the source or mapping, and repeat. This gives the import a clean rollback boundary that a mixed primary calendar does not.

Common questions

Answers before you import

  • ?

    Can Google Calendar import a CSV file directly?

    Yes. On a computer, Google Calendar can import CSV or ICS files. A direct CSV needs Google's exact English headers, with Subject and Start Date required.

  • ?

    Should I use CSV or ICS for Google Calendar?

    Use CSV when the sheet already follows Google's limited import template. Use ICS when headers need mapping, the source is Excel, time and all-day behavior need validation, or the file should remain portable.

  • ?

    Why did recurring CSV events become separate events?

    Google warns that repeating events imported from CSV may appear as a series of one-off events. Recreate the recurrence inside Calendar when the rule must remain editable.

  • ?

    Does importing add guests or Google Meet data?

    No. Google states that guests and conference data are not imported with an event. Add invitations and conferencing in Calendar after reviewing the imported events.

  • ?

    Will an imported calendar stay synchronized?

    No. File import creates a snapshot. For ongoing synchronization between Google accounts, share the calendar instead of repeatedly exporting and importing it.

  • ?

    Does the converter upload my spreadsheet?

    No. CSV and Excel parsing, mapping, validation, preview, and ICS generation run in the browser tab, and event-derived data is not sent to audience measurement.

Keep going