freesabaiICS calendar to CSV / Excel
Exported a calendar from Google Calendar or Outlook and need a list of the appointments in Excel, for a report or to count meetings? Open the .ics here and save a CSV that Excel opens with Thai intact. It runs in your browser; the calendar is not sent anywhere.
Getting the tool ready…This tool needs JavaScript. If you still see this after a few seconds, JavaScript is switched off in your browser or the page did not load completely: turn JavaScript on or reload the page.
How to use it
- Export the calendar: in Google Calendar go to Settings, Import & export, Export (you get a .zip; unzip it for the .ics files); in Outlook save the calendar as an iCalendar (.ics) file.
- Choose the .ics file, pick the time zone and, if you want, a date range; the first 50 events show in the table.
- Press "Save the CSV" and open it in Excel or Google Sheets.
Good to know
- Columns: subject, start, end, all day, location, description, organizer and repeats. Dates are written YYYY-MM-DD HH:MM; all-day events only have the date, and the end is the last day of the event (an .ics stores the day after).
- Times stored in UTC or with a time zone are converted to the zone you pick (this device's by default, or Thailand time, or UTC). Times without a zone are shown as written.
- A repeating event is one row (its first time) with the rule in words, such as "Weekly, on Monday" or "Monthly, on the first Monday"; it is not expanded into a row per time, and dates removed from the series (EXDATE) or moved instances are not applied.
- The date range keeps one-off events that start in it and repeating events whose run overlaps it.
- Only events (VEVENT) go into the CSV; to-dos (VTODO) and journal entries (VJOURNAL) are counted and named. Attendees and reminders are not included.
Your data stays on your device
A calendar is personal: who you meet, where and when. Everything runs in your browser: the file is not sent to freesabai's server or anyone else's, and nothing is kept in the browser; close the page and it is gone. The site only counts that this page was opened and how many times a result was saved (never the file name or content; you can turn counting off at the bottom of the site, see the privacy policy).
Report a problem or suggest an idea
Found a calendar this reads wrong? Tell us on the feedback page; no sign-up needed (do not attach a real calendar).
Other file converters
Thai text files
Subtitles
ZIP and TAR archives
- Unzip with Thai file namesZIPs from Thai Windows whose names show as garbage: extract or re-zip readable
- Extract ZIP filesOpen a ZIP, browse its folders, save files or extract to a folder, password ZIPs too
- Create a ZIP filePut files or a whole folder in a ZIP, with an AES-256 password if you like
- Open TAR, TAR.GZ, TGZ and GZOpen .tar.gz, .tgz, .tar or .gz files: save each file or all as a ZIP
- Create a TAR.GZ filePack files or a folder into .tar.gz or .tar, or gzip one file to .gz
Images
- SVG to PNG, JPG, WebPSVG to PNG at any size, transparent or coloured background, many files at once
- Favicon and ICO generatorA favicon.ico with several sizes, and the full icon set with the code
- GIF to framesSplit a GIF into PNG frames with their delays, one by one or as a ZIP
- GIF maker from imagesMake an animated GIF from pictures: order, delays, size and loops
- BMP and TIFF converterTIFF to JPG or PNG, BMP to PNG, and pictures to BMP or TIFF
Excel and Word files
- Excel to CSV / JSONOpen an xlsx, pick a sheet, get a CSV that keeps Thai intact or JSON; every sheet in one ZIP
- CSV / JSON to ExcelA real xlsx: leading zeros and Thai kept, several files as several sheets
- Word to text / HTMLOpen a docx, get plain text, HTML or Markdown with headings, lists, tables, links and pictures
HTML, Markdown, JSON and XML
- HTML / Word / Google Docs to MarkdownPaste from Word, Google Docs or a web page and get Markdown with tables and lists
- Markdown to HTMLA .md file as a readable .html page or just the content
- JSON to XMLSet the root name; @name keys become attributes; Thai keys work
- XML to JSONRSS, sitemaps or exports to JSON, with the line of any mistake
Contacts and calendars
Questions and answers
Can I export Google Calendar to Excel?
Yes. In Google Calendar open Settings, Import and export, Export, and unzip the download to get the .ics files. Open one here and save a CSV that Excel opens.
The times are off from Thai time. What do I do?
Pick Thailand time (Asia/Bangkok) under Show times in. Times stored in UTC or with a zone are converted; times the file stores without a zone are shown as written.
How many rows does a weekly meeting give?
One row, its first time, with the Repeats column saying the rule in words, such as Weekly, on Monday, 10 times. The tool does not expand it into a row per meeting.
Rate this tool
Tap the stars, then add a word if you like
Thank you! Your rating helps make the tool better
No sign-up. No name or e-mail is kept; a comment is kept for 3 months · Details