If you will be importing your CSV or iCal/ICS file into Google Calendar or Outlook, please take note of the instructions below and read the Google FAQ or Outlook FAQ which address potential problems you may have with importing files into those apps and how you can get around those restrictions.
Default Settings
I will be importing my CSV or iCal/ICS file(s) into:
I don't know yet (uses default values)
Google Calendar
Microsoft Outlook
Yahoo Calendar
iCalendar
Mozilla Thunderbird
When you choose one of these settings it will automatically update the options below to correspond to the setting you choose:
Output Options
Output Format
iCal/ICS
CSV
Not sure? Use iCal/ICS!
Max Output File Size
KB
Maximum size of each output file, in kilobytes.
0 = no limit, and will produce a single large file.
Max Output File Lines
Maximum number of lines in each output file.
0 = no limit, and will produce a single large file.
Terminate Lines With
\n (newline)
\r (carriage return)
Internal Newlines As
\n (newline)
\r (carriage return)
<br /> (HTML newline)
' ' (blank space)
Output File Extension
.ics
.ical
.csv
.tsv
CSV Options
Boolean Format
Uppercase (TRUE/FALSE)
Mixed (True/False)
Lower (true/false)
Digital (1/0)
Column Separator
, (comma)
\t (tab)
Enclose Fields With
" (quote)
' (apostrophe)
iCal/ICS Options
Organizer
What should appear in the "ORGANIZER" field (leave blank to omit this field from the output file)
Make untimed events "transparent"
Yes
No
Select "Yes" if you want Palm2CSV to output "TRANSP=TRANSPARENT" for all-day (i.e. untimed) events, which will make them invisible to free-busy time searches
Date/Time Adjustment
I am assuming your Palm DBA/TDA file is from the
America/New York (US Eastern Time / GMT/UTC-5) time zone.
If your Palm file is from a different time zone, you should change the
Time Zone setting below. For more info on these settings see the
FAQ .
Time Zone
America/Adak [GMT-10]
America/Anchorage [GMT-9]
America/Anguilla [GMT-4]
America/Antigua [GMT-4]
America/Araguaina [GMT-3]
America/Argentina/Buenos_Aires [GMT-3]
America/Argentina/Catamarca [GMT-3]
America/Argentina/ComodRivadavia [GMT-3]
America/Argentina/Cordoba [GMT-3]
America/Argentina/Jujuy [GMT-3]
America/Argentina/La_Rioja [GMT-3]
America/Argentina/Mendoza [GMT-3]
America/Argentina/Rio_Gallegos [GMT-3]
America/Argentina/Salta [GMT-3]
America/Argentina/San_Juan [GMT-3]
America/Argentina/San_Luis [GMT-3]
America/Argentina/Tucuman [GMT-3]
America/Argentina/Ushuaia [GMT-3]
America/Aruba [GMT-4]
America/Asuncion [GMT-3]
America/Atikokan [GMT-5]
America/Atka [GMT-10]
America/Bahia [GMT-3]
America/Bahia_Banderas [GMT-6]
America/Barbados [GMT-4]
America/Belem [GMT-3]
America/Belize [GMT-6]
America/Blanc-Sablon [GMT-4]
America/Boa_Vista [GMT-4]
America/Bogota [GMT-5]
America/Boise [GMT-7]
America/Buenos_Aires [GMT-3]
America/Cambridge_Bay [GMT-7]
America/Campo_Grande [GMT-3]
America/Cancun [GMT-5]
America/Caracas [GMT-4]
America/Catamarca [GMT-3]
America/Cayenne [GMT-3]
America/Cayman [GMT-5]
America/Chicago [GMT-6]
America/Chihuahua [GMT-7]
America/Coral_Harbour [GMT-5]
America/Cordoba [GMT-3]
America/Costa_Rica [GMT-6]
America/Cuiaba [GMT-3]
America/Curacao [GMT-4]
America/Danmarkshavn [GMT]
America/Dawson [GMT-8]
America/Dawson_Creek [GMT-7]
America/Denver [GMT-7]
America/Detroit [GMT-5]
America/Dominica [GMT-4]
America/Edmonton [GMT-7]
America/Eirunepe [GMT-5]
America/El_Salvador [GMT-6]
America/Ensenada [GMT-8]
America/Fort_Wayne [GMT-5]
America/Fortaleza [GMT-3]
America/Glace_Bay [GMT-4]
America/Godthab [GMT-3]
America/Goose_Bay [GMT-4]
America/Grand_Turk [GMT-4]
America/Grenada [GMT-4]
America/Guadeloupe [GMT-4]
America/Guatemala [GMT-6]
America/Guayaquil [GMT-5]
America/Guyana [GMT-4]
America/Halifax [GMT-4]
America/Havana [GMT-5]
America/Hermosillo [GMT-7]
America/Indiana/Indianapolis [GMT-5]
America/Indiana/Knox [GMT-6]
America/Indiana/Marengo [GMT-5]
America/Indiana/Petersburg [GMT-5]
America/Indiana/Tell_City [GMT-6]
America/Indiana/Vevay [GMT-5]
America/Indiana/Vincennes [GMT-5]
America/Indiana/Winamac [GMT-5]
America/Indianapolis [GMT-5]
America/Inuvik [GMT-7]
America/Iqaluit [GMT-5]
America/Jamaica [GMT-5]
America/Jujuy [GMT-3]
America/Juneau [GMT-9]
America/Kentucky/Louisville [GMT-5]
America/Kentucky/Monticello [GMT-5]
America/Knox_IN [GMT-6]
America/La_Paz [GMT-4]
America/Lima [GMT-5]
America/Los_Angeles [GMT-8]
America/Louisville [GMT-5]
America/Maceio [GMT-3]
America/Managua [GMT-6]
America/Manaus [GMT-4]
America/Marigot [GMT-4]
America/Martinique [GMT-4]
America/Matamoros [GMT-6]
America/Mazatlan [GMT-7]
America/Mendoza [GMT-3]
America/Menominee [GMT-6]
America/Merida [GMT-6]
America/Metlakatla [GMT-9]
America/Mexico_City [GMT-6]
America/Miquelon [GMT-3]
America/Moncton [GMT-4]
America/Monterrey [GMT-6]
America/Montevideo [GMT-3]
America/Montreal [GMT-5]
America/Montserrat [GMT-4]
America/Nassau [GMT-5]
America/New_York [GMT-5]
America/Nipigon [GMT-5]
America/Nome [GMT-9]
America/Noronha [GMT-2]
America/North_Dakota/Beulah [GMT-6]
America/North_Dakota/Center [GMT-6]
America/North_Dakota/New_Salem [GMT-6]
America/Ojinaga [GMT-7]
America/Panama [GMT-5]
America/Pangnirtung [GMT-5]
America/Paramaribo [GMT-3]
America/Phoenix [GMT-7]
America/Port-au-Prince [GMT-5]
America/Port_of_Spain [GMT-4]
America/Porto_Acre [GMT-5]
America/Porto_Velho [GMT-4]
America/Puerto_Rico [GMT-4]
America/Rainy_River [GMT-6]
America/Rankin_Inlet [GMT-6]
America/Recife [GMT-3]
America/Regina [GMT-6]
America/Resolute [GMT-6]
America/Rio_Branco [GMT-5]
America/Rosario [GMT-3]
America/Santa_Isabel [GMT-8]
America/Santarem [GMT-3]
America/Santiago [GMT-3]
America/Santo_Domingo [GMT-4]
America/Sao_Paulo [GMT-2]
America/Scoresbysund [GMT-1]
America/Shiprock [GMT-7]
America/Sitka [GMT-9]
America/St_Barthelemy [GMT-4]
America/St_Johns [GMT-3.5]
America/St_Kitts [GMT-4]
America/St_Lucia [GMT-4]
America/St_Thomas [GMT-4]
America/St_Vincent [GMT-4]
America/Swift_Current [GMT-6]
America/Tegucigalpa [GMT-6]
America/Thule [GMT-4]
America/Thunder_Bay [GMT-5]
America/Tijuana [GMT-8]
America/Toronto [GMT-5]
America/Tortola [GMT-4]
America/Vancouver [GMT-8]
America/Virgin [GMT-4]
America/Whitehorse [GMT-8]
America/Winnipeg [GMT-6]
America/Yakutat [GMT-9]
America/Yellowknife [GMT-7]
Africa/Abidjan [GMT]
Africa/Accra [GMT]
Africa/Addis_Ababa [GMT+3]
Africa/Algiers [GMT+1]
Africa/Asmara [GMT+3]
Africa/Asmera [GMT+3]
Africa/Bamako [GMT]
Africa/Bangui [GMT+1]
Africa/Banjul [GMT]
Africa/Bissau [GMT]
Africa/Blantyre [GMT+2]
Africa/Brazzaville [GMT+1]
Africa/Bujumbura [GMT+2]
Africa/Cairo [GMT+2]
Africa/Casablanca [GMT]
Africa/Ceuta [GMT+1]
Africa/Conakry [GMT]
Africa/Dakar [GMT]
Africa/Dar_es_Salaam [GMT+3]
Africa/Djibouti [GMT+3]
Africa/Douala [GMT+1]
Africa/El_Aaiun [GMT]
Africa/Freetown [GMT]
Africa/Gaborone [GMT+2]
Africa/Harare [GMT+2]
Africa/Johannesburg [GMT+2]
Africa/Kampala [GMT+3]
Africa/Khartoum [GMT+3]
Africa/Kigali [GMT+2]
Africa/Kinshasa [GMT+1]
Africa/Lagos [GMT+1]
Africa/Libreville [GMT+1]
Africa/Lome [GMT]
Africa/Luanda [GMT+1]
Africa/Lubumbashi [GMT+2]
Africa/Lusaka [GMT+2]
Africa/Malabo [GMT+1]
Africa/Maputo [GMT+2]
Africa/Maseru [GMT+2]
Africa/Mbabane [GMT+2]
Africa/Mogadishu [GMT+3]
Africa/Monrovia [GMT]
Africa/Nairobi [GMT+3]
Africa/Ndjamena [GMT+1]
Africa/Niamey [GMT+1]
Africa/Nouakchott [GMT]
Africa/Ouagadougou [GMT]
Africa/Porto-Novo [GMT+1]
Africa/Sao_Tome [GMT]
Africa/Timbuktu [GMT]
Africa/Tripoli [GMT+2]
Africa/Tunis [GMT+1]
Africa/Windhoek [GMT+2]
Antarctica/Casey [GMT+11]
Antarctica/Davis [GMT+7]
Antarctica/DumontDUrville [GMT+10]
Antarctica/Macquarie [GMT+11]
Antarctica/Mawson [GMT+5]
Antarctica/McMurdo [GMT+13]
Antarctica/Palmer [GMT-3]
Antarctica/Rothera [GMT-3]
Antarctica/South_Pole [GMT+13]
Antarctica/Syowa [GMT+3]
Antarctica/Vostok [GMT+6]
Arctic/Longyearbyen [GMT+1]
Asia/Aden [GMT+3]
Asia/Almaty [GMT+6]
Asia/Amman [GMT+2]
Asia/Anadyr [GMT+12]
Asia/Aqtau [GMT+5]
Asia/Aqtobe [GMT+5]
Asia/Ashgabat [GMT+5]
Asia/Ashkhabad [GMT+5]
Asia/Baghdad [GMT+3]
Asia/Bahrain [GMT+3]
Asia/Baku [GMT+4]
Asia/Bangkok [GMT+7]
Asia/Beirut [GMT+2]
Asia/Bishkek [GMT+6]
Asia/Brunei [GMT+8]
Asia/Calcutta [GMT+5.5]
Asia/Choibalsan [GMT+8]
Asia/Chongqing [GMT+8]
Asia/Chungking [GMT+8]
Asia/Colombo [GMT+5.5]
Asia/Dacca [GMT+6]
Asia/Damascus [GMT+2]
Asia/Dhaka [GMT+6]
Asia/Dili [GMT+9]
Asia/Dubai [GMT+4]
Asia/Dushanbe [GMT+5]
Asia/Gaza [GMT+2]
Asia/Harbin [GMT+8]
Asia/Ho_Chi_Minh [GMT+7]
Asia/Hong_Kong [GMT+8]
Asia/Hovd [GMT+7]
Asia/Irkutsk [GMT+8]
Asia/Istanbul [GMT+3]
Asia/Jakarta [GMT+7]
Asia/Jayapura [GMT+9]
Asia/Jerusalem [GMT+2]
Asia/Kabul [GMT+4.5]
Asia/Kamchatka [GMT+12]
Asia/Karachi [GMT+5]
Asia/Kashgar [GMT+6]
Asia/Kathmandu [GMT+5.75]
Asia/Katmandu [GMT+5.75]
Asia/Kolkata [GMT+5.5]
Asia/Krasnoyarsk [GMT+7]
Asia/Kuala_Lumpur [GMT+8]
Asia/Kuching [GMT+8]
Asia/Kuwait [GMT+3]
Asia/Macao [GMT+8]
Asia/Macau [GMT+8]
Asia/Magadan [GMT+11]
Asia/Makassar [GMT+8]
Asia/Manila [GMT+8]
Asia/Muscat [GMT+4]
Asia/Nicosia [GMT+2]
Asia/Novokuznetsk [GMT+7]
Asia/Novosibirsk [GMT+7]
Asia/Omsk [GMT+6]
Asia/Oral [GMT+5]
Asia/Phnom_Penh [GMT+7]
Asia/Pontianak [GMT+7]
Asia/Pyongyang [GMT+8.5]
Asia/Qatar [GMT+3]
Asia/Qyzylorda [GMT+6]
Asia/Rangoon [GMT+6.5]
Asia/Riyadh [GMT+3]
Asia/Saigon [GMT+7]
Asia/Sakhalin [GMT+11]
Asia/Samarkand [GMT+5]
Asia/Seoul [GMT+9]
Asia/Shanghai [GMT+8]
Asia/Singapore [GMT+8]
Asia/Taipei [GMT+8]
Asia/Tashkent [GMT+5]
Asia/Tbilisi [GMT+4]
Asia/Tehran [GMT+3.5]
Asia/Tel_Aviv [GMT+2]
Asia/Thimbu [GMT+6]
Asia/Thimphu [GMT+6]
Asia/Tokyo [GMT+9]
Asia/Ujung_Pandang [GMT+8]
Asia/Ulaanbaatar [GMT+8]
Asia/Ulan_Bator [GMT+8]
Asia/Urumqi [GMT+6]
Asia/Vientiane [GMT+7]
Asia/Vladivostok [GMT+10]
Asia/Yakutsk [GMT+9]
Asia/Yekaterinburg [GMT+5]
Asia/Yerevan [GMT+4]
Atlantic/Azores [GMT-1]
Atlantic/Bermuda [GMT-4]
Atlantic/Canary [GMT]
Atlantic/Cape_Verde [GMT-1]
Atlantic/Faeroe [GMT]
Atlantic/Faroe [GMT]
Atlantic/Jan_Mayen [GMT+1]
Atlantic/Madeira [GMT]
Atlantic/Reykjavik [GMT]
Atlantic/South_Georgia [GMT-2]
Atlantic/St_Helena [GMT]
Atlantic/Stanley [GMT-3]
Australia/ACT [GMT+11]
Australia/Adelaide [GMT+10.5]
Australia/Brisbane [GMT+10]
Australia/Broken_Hill [GMT+10.5]
Australia/Canberra [GMT+11]
Australia/Currie [GMT+11]
Australia/Darwin [GMT+9.5]
Australia/Eucla [GMT+8.75]
Australia/Hobart [GMT+11]
Australia/LHI [GMT+11]
Australia/Lindeman [GMT+10]
Australia/Lord_Howe [GMT+11]
Australia/Melbourne [GMT+11]
Australia/North [GMT+9.5]
Australia/NSW [GMT+11]
Australia/Perth [GMT+8]
Australia/Queensland [GMT+10]
Australia/South [GMT+10.5]
Australia/Sydney [GMT+11]
Australia/Tasmania [GMT+11]
Australia/Victoria [GMT+11]
Australia/West [GMT+8]
Australia/Yancowinna [GMT+10.5]
Europe/Amsterdam [GMT+1]
Europe/Andorra [GMT+1]
Europe/Athens [GMT+2]
Europe/Belfast [GMT]
Europe/Belgrade [GMT+1]
Europe/Berlin [GMT+1]
Europe/Bratislava [GMT+1]
Europe/Brussels [GMT+1]
Europe/Bucharest [GMT+2]
Europe/Budapest [GMT+1]
Europe/Chisinau [GMT+2]
Europe/Copenhagen [GMT+1]
Europe/Dublin [GMT]
Europe/Gibraltar [GMT+1]
Europe/Guernsey [GMT]
Europe/Helsinki [GMT+2]
Europe/Isle_of_Man [GMT]
Europe/Istanbul [GMT+3]
Europe/Jersey [GMT]
Europe/Kaliningrad [GMT+2]
Europe/Kiev [GMT+2]
Europe/Lisbon [GMT]
Europe/Ljubljana [GMT+1]
Europe/London [GMT]
Europe/Luxembourg [GMT+1]
Europe/Madrid [GMT+1]
Europe/Malta [GMT+1]
Europe/Mariehamn [GMT+2]
Europe/Minsk [GMT+3]
Europe/Monaco [GMT+1]
Europe/Moscow [GMT+3]
Europe/Nicosia [GMT+2]
Europe/Oslo [GMT+1]
Europe/Paris [GMT+1]
Europe/Podgorica [GMT+1]
Europe/Prague [GMT+1]
Europe/Riga [GMT+2]
Europe/Rome [GMT+1]
Europe/Samara [GMT+4]
Europe/San_Marino [GMT+1]
Europe/Sarajevo [GMT+1]
Europe/Simferopol [GMT+3]
Europe/Skopje [GMT+1]
Europe/Sofia [GMT+2]
Europe/Stockholm [GMT+1]
Europe/Tallinn [GMT+2]
Europe/Tirane [GMT+1]
Europe/Tiraspol [GMT+2]
Europe/Uzhgorod [GMT+2]
Europe/Vaduz [GMT+1]
Europe/Vatican [GMT+1]
Europe/Vienna [GMT+1]
Europe/Vilnius [GMT+2]
Europe/Volgograd [GMT+3]
Europe/Warsaw [GMT+1]
Europe/Zagreb [GMT+1]
Europe/Zaporozhye [GMT+2]
Europe/Zurich [GMT+1]
Indian/Antananarivo [GMT+3]
Indian/Chagos [GMT+6]
Indian/Christmas [GMT+7]
Indian/Cocos [GMT+6.5]
Indian/Comoro [GMT+3]
Indian/Mahe [GMT+4]
Indian/Maldives [GMT+5]
Indian/Mauritius [GMT+4]
Indian/Mayotte [GMT+3]
Indian/Reunion [GMT+4]
Pacific/Apia [GMT+14]
Pacific/Auckland [GMT+13]
Pacific/Chatham [GMT+13.75]
Pacific/Chuuk [GMT+10]
Pacific/Easter [GMT-5]
Pacific/Efate [GMT+11]
Pacific/Enderbury [GMT+13]
Pacific/Fakaofo [GMT+13]
Pacific/Fiji [GMT+13]
Pacific/Funafuti [GMT+12]
Pacific/Galapagos [GMT-6]
Pacific/Gambier [GMT-9]
Pacific/Guadalcanal [GMT+11]
Pacific/Guam [GMT+10]
Pacific/Honolulu [GMT-10]
Pacific/Johnston [GMT-10]
Pacific/Kiritimati [GMT+14]
Pacific/Kosrae [GMT+11]
Pacific/Kwajalein [GMT+12]
Pacific/Majuro [GMT+12]
Pacific/Marquesas [GMT-9.5]
Pacific/Midway [GMT-11]
Pacific/Nauru [GMT+12]
Pacific/Niue [GMT-11]
Pacific/Norfolk [GMT+11]
Pacific/Noumea [GMT+11]
Pacific/Pago_Pago [GMT-11]
Pacific/Palau [GMT+9]
Pacific/Pitcairn [GMT-8]
Pacific/Pohnpei [GMT+11]
Pacific/Ponape [GMT+11]
Pacific/Port_Moresby [GMT+10]
Pacific/Rarotonga [GMT-10]
Pacific/Saipan [GMT+10]
Pacific/Samoa [GMT-11]
Pacific/Tahiti [GMT-10]
Pacific/Tarawa [GMT+12]
Pacific/Tongatapu [GMT+14]
Pacific/Truk [GMT+10]
Pacific/Wake [GMT+12]
Pacific/Wallis [GMT+12]
Pacific/Yap [GMT+10]
Adjust Times By
-23
-22
-21
-20
-19
-18
-17
-16
-15
-14
-13
-12
-11
-10
-9
-8
-7
-6
-5
-4
-3
-2
-1
0
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+16
+17
+18
+19
+20
+21
+22
+23
hours to account for timezone differences (affects TIMED events only!)
Adjust DST Prior to 2007
Yes
No
Select "Yes" if you want Palm2CSV to properly adjust DST prior to 2007.
Repeating events end a day later
Yes
No
Select "Yes" if you want Palm2CSV to output ";UNTIL=" as the date after the last day
Date Format
mm/dd/yyyy (American)
dd/mm/yyyy (European)
yyyy/mm/dd (ISO)
Applies only to CSV, not iCal/ICS
Date Separator
/ (slash)
- (dash)
between month, day and year (applies only to CSV, not iCal/ICS)
Time Format
12:00:00 PM (12 hr with am/pm)
24:00:00 PM (24 hr with am/pm)
12:00:00 (12 hr)
24:00:00 (24 hr)
Select "12:00:00 PM (12 hr with am/pm)" if you will be importing into Google Calendar. (Applies only to CSV, not iCal/ICS.) For more info see this page .
Date Range
Use this to limit which events get converted. Note that year must have 4 digits, e.g. 1998, not 98! If you want to convert all events, leave this section blank.
Start Date
(MM/DD/YYYY format) Don't show events before this date. (Blank = no limit.)
End Date
(MM/DD/YYYY format) Don't show events past this date.
Repeating Events (applies only to CSV, not iCal/ICS)
Repeat Maximum
Limit repeating events to this number of occurrences (0 = no limit)
End Date Display
Normal
Suppressed (blank)
Display Start Date
Select "Display Start Date" if you will be importing into Google Calendar or Outlook. This will cause Google Calendar or Outlook to properly preserve event start and end times.
Show Repeat Exceptions
Check this box if you want the "Comments" field in the output to include a list of all the exceptions to repeated events. This is mainly useful for debugging. (To reduce the size of your output file, don't check this box.) Applies only to CSV, not iCal/ICS.
Categories
Limit to Category
Which category to output, e.g. Business , Personal or Unfiled (blank=all). Case-insensitive, but spelling counts!
Add category to description?
No
Yes
Select "Yes" if you want to put the category at the end of each event description. This will prevent you from losing categories when importing into applications such as Google Calendar and iCalendar that don't recognize the iCal/ICS "CATEGORIES:" field
Advanced Options
Encode in UTF-8
No
Yes
If your Palm file contains foreign/accented characters (i.e. high/extended ASCII), selecting "Yes" will convert those characters to UTF-8.AS OF 5/27/2022 THIS SETTING DEFAULTS TO "YES" BECAUSE ACCORDING TO THE SPECS, .ICS FILES MUST BE ENCODED IN UTF-8 FORMAT
Add UTF-8 BOM?
No
Yes
Select "Yes" if you want to start each output file with a UTF-8 BOM (\xEF\xBB\xBF).
MDB Tools Version
0.7rc1 (this is the latest!)
Which version of the MDB Tools library to use (only applies when converting from Palm Desktop 6.x for Windows). Note that currently only 0.7rc1 (the latest version) is available.
Step 6: Convert!
Ready? Click the button below to begin conversion: