Cisco Webex Meetings CSV File Import and Export

The information in this article is for administrators who manage Webex sites through Cisco Webex Control Hub. For a Control Hub-managed site, the identity service stores all identities. Each user has one identity for all collaboration services, including the Webex Meetings service.

Bulk Modify User Attributes

You can use comma-separated values (CSV) files to bulk-inspect and -update privileges and options that are specific to Webex Meetings, for existing entitled users. The Webex Meetings-specific CSV file method is the best way to modify:

  • Webex Meetings-specific attributes for many users.

  • Attributes that differ from one user to another (such as, Audio PIN and TSP audio accounts).

You cannot use the Webex Meetings-specific CSV file to add or to entitle users. For information about how to use CSV files to bulk-add and -entitle new users, see Add Multiple Users With the CSV Template.

  Command or Action Purpose
1

Create a Cisco Webex Meetings CSV File Template

In this step, you export a CSV file that includes all the existing entitled Webex Meetings users for your site.

2

Batch Edit Cisco Webex Meetings Settings and Privileges for Multiple Users

In this step, you edit the CSV file (Webex Meetings-specific CSV file template) that you created in step one. After you update the file, import the file back in to your Webex site.

Create a Cisco Webex Meetings CSV File Template

You can export a CSV file that contains the Webex Meetings-specific settings for all entitled users for your site. You can use this file to bulk-inspect settings or as a template that you can edit.

1

From the customer view in https://admin.webex.com, go to Services.

2

Under Meetings, select Sites, and then choose the site that you want to create a template for.

3

In the Licenses and Users section, select Bulk Manage.

4

In the Bulk Modify User Attributes window, click Export.

5

After exporting completes, select the Export Results link that appears.

6

In the Export Results dialog, click Download.

Batch Edit Cisco Webex Meetings Settings and Privileges for Multiple Users

Use a spreadsheet editor such a Microsoft Excel to update the Webex Meetings-specific CSV file template that you exported for your site.


When you open a CSV file, Microsoft Excel removes the leading zeros from all number codes. For workaround instructions, see Open a CSV File in Microsoft Excel and Keep the Leading Zeros.

Before you begin

Create a Webex Meetings-specific CSV file template.

1

Use a spreadsheet editor to open the CSV file template, change the user settings, and then save the file.

2

From the customer view in https://admin.webex.com, and go to Services.

3

Under Meetings, select Sites, and then choose the site that you want to create a template for.

4

In the Licenses and Users section, select Bulk Manage.

5

Do one of the following:

  • Drag the updated CSV file into the Import section of the Bulk Modify User Attributes window.

  • Click Import, browse to the location of the updated CSV file, select the file, and then click Open.

6

In the Bulk Modify User Attributes window, click Import.

7

After importing completes, select the Import Results link that appears.

8

If there are errors that are recorded in the Import Results window, select the Download the import error log link. The downloaded CSV file lists why any updates did not go through.

Open a CSV File in Microsoft Excel and Keep the Leading Zeros

1

Open a new, blank Excel workbook, and click the Data tab.

2

In the Get External Data category, select From text.

3

Browse to the location of the CSV file, select the file, and then click Import.

4

Under Original data type, select Delimited, and then click Next.

5

Under Delimiters, check Tab, and then click Next.

6

Under Column data format, choose Text.

7

Under Data Preview, select all of the columns.


 

Select the first column, hold Shift, and then click the last column.

8

Click Finish.

9

In the Import Data window, choose where to place the data, and then click OK.

Save a CSV File in Microsoft Excel and Keep the Leading Zeros

1

With the CSV file open in Excel, select the cell or range of cells that you want to format.

2

Select the Home tab.

3

In the Number group, click the Number Format (Format Cells: Number image) icon.

4

In the Format Cells window, select the Number tab, and select Custom from the category list.

5

In the Type box, enter the number format, such as 000-000-0000 for a phone number.

6

Click OK.

7

Select the File tab, choose Save As, select the location to save the CSV file, and in the Save As window, click Save.

Import a CSV File and Check the Import Results

After the import process is complete, you can view the import results and download the import error log (if applicable). The error log lists each record that failed to update, along with a reason for the failure. The error log is in the CSV file format and you can open it in a spreadsheet editor such as Microsoft Excel.

1

From the customer view in https://admin.ciscospark.com, go to Services.

2

Under Meetings, select Sites, and then choose the site that you want to create a template for.

3

In the Licenses and Users section, select Bulk Manage.

4

Do one of the following:

  • Drag the updated CSV file into the Import section of the Bulk Modify User Attributes window.

  • Click Import, browse to the location of the updated CSV file, select the file, and then click Open.

5

In the Bulk Modify User Attributes window, click Import.

6

After importing completes, select the Import Results link that appears.

7

If there are errors that are recorded in the Import Results window, select the Download the import error log link.

8

Use a spreadsheet editor to open the file.

CSV File Format for Tracking Code Values

  • A CSV file must include column headings at the top of the file. When creating a CSV file using a spreadsheet program, such as Microsoft Excel, the column headings must be in the first row of a spreadsheet. Column headings must appear exactly as specified under Code-Value Information Fields.

  • Some tracking code information is required, as specified under Code-Value Information Fields. You must include all column headings, regardless of whether their information is optional, and format them exactly as specified.

  • The code-value information fields in a CSV file are not case-sensitive. Thus, you can type values in either upper- or lowercase letters, or a combination of both. The tracking code values appear on your site as they appear in the CSV file.

  • After you finish specifying code values, save the spreadsheet file as a CSV file, which as a .csv extension.

  • When uploading a CSV file, Control Hub displays a table containing the information that you specified in the file. Review the information carefully, and verify its accuracy before you confirm that you want to upload the file.

  • If you specify any code values incorrectly, Control Hub cannot add those values to the list. In this case, Control Hub generates a list of records for the values that it was unable to add, including the cause for each error. You can download a file containing these records to your computer for reference or to correct the errors directly in that file.

  • If you correct the errors directly in the file that Control Hub creates for you, delete the last column, labeled Comments, before you upload the file to create the remaining code values.

Alternately, you can edit values individually in Control Hub,on the Tracking Codes List page. Or, you can contact your Webex account manager for assistance.

Code-Value Information Fields

Use this option...

To...

Index

(Optional) Specifies the database ID of the tracking code value. An Index value must be a unique number from 1-500, inclusive. To prevent errors that duplicate index numbers can cause, you can leave this column blank. If the Index column does not contain values, Control Hub inserts the code values sequentially on the Tracking Codes List page.

Active

(Optional) Specifies the status of the tracking code value. A value must be Yes or No. If you leave this value blank, the status automatically defaults to Yes.

Code

(Requiredl) Specifies the value of the tracking code. A value can be up to 128 characters, and include letters, numbers, and special characters.

Cisco Webex Meetings Information Fields

The following table lists the fields (columns) that comprise Webex Meetings-specific CSV files. The description for a read-only field specifically indicates that the field is read-only.

Field

Description

UserID

Read-only

Indicates an identification number that Webex Meetings database for Site Administration automatically generates for the account.

Active

Read-only

Specifies whether a user account is active or inactive. To host Webex Meetings, training sessions, support sessions, or events, the host’s account must be active. This field can contain one of the following values:

  • Y: The user account is active.

  • N: The user account in inactive.

If the field is empty, the default is Y.

FirstName

Read-only

Specifies the first name of the user to whom this account belongs.

LastName

Read-only

(Required) Specifies the last name of the user to whom this account belongs.

Email

Read-only

Specifies the user's email address.

Language

(Optional) Specifies the language that is selected by default on the user's Preferences page. This option determines the language in which text appears to the user on your meeting service website. Depending on which languages your site supports, this field contains one of the following short name values. In the following list, the short name appears next to the corresponding language.

If the field is left empty, it defaults to the default language for the site.

Language - ID

English: en-us

Simplified Chinese: zh-cn

Traditional Chinese: zh-tw

Japanese: jp

Korean: ko

French: fr

German: de

Italian: it

Castilian Spanish: es-me

Latin American Spanish: es-sp

Swedish: sw

Dutch: nl

Portuguese: pt-br

Russian: ru

HostPrivilege

Read-only

Specifies the type of user account. This field can contain the following account types:

  • HOST: Specifies that the user has a host account.

  • ADMN: Specifies that the user has a site administrator account.

  • ADMV: Specifies that the user has a view-only site administrator account.

  • ATTND: Specifies that the user has an attendee account.

If this field is empty, the default is the HOST account type.

MeetingPrivilege

(Optional) Specifies which types of meetings the user can host. This field can contain one or more codes that indicate the meeting types a user can host.


 
  • To obtain a valid code for this field, see the Site Administration home page, which lists the Index values for each session type. However, if your site includes the Access Anywhere meeting type, do not type its code in this field.

  • If any codes contain leading zeros, do not type them. For example, if your meeting type code is 004, type only the digit 4 in this field.

  • You can specify multiple meeting types for any user account, if your organization has the appropriate licenses. To specify multiple service types, separate them with commas, but without spaces—For example:

    15,120

  • If you have any questions about the meeting types that your organization has purchased, please contact your Webex Meetings account manager.

    If you leave this field empty, the value is left blank.

TelephonyPrivilege

(Optional) Specifies the types of teleconferencing services that the user can use when hosting a session. This field can contain one or more of the following values for an account, depending on the teleconferencing services that your organization's Webex Meetings service supports:

  • CLIN: Call-in teleconferencing. Specifies that the user can host sessions in which attendees can call a phone number to join a teleconference.

  • TOLL: Toll-free call-in teleconferencing. Specifies that the user can host sessions in which attendees call a toll-free phone number to join a teleconference.

  • CLBK: Call-back teleconferencing. Specifies that the user can host sessions in which attendees receive a phone call from the Webex Meetings service to join a teleconference. Each attendee first calls a phone number, and then hangs up. The service then calls the attendee's phone number.

  • INTL: International call-back teleconferencing. Specifies that the user can host meetings or training sessions in which attendees receive an international phone call from the Webex Meetings service to join a teleconference.

  • VoIP: Internet phone. Specifies that the user can host sessions that include an Internet phone (Voice over IP) conference.

  • ILCI: International call-in numbers. Specifies that the user can host sessions for which attendees in other countries can call a local phone number to join a teleconference.

  • SELT: Teleconferencing location. Specifies that the user can select the location of the telephony bridge to use for a teleconference. Available only if your Webex service is provisioned with multiple bridge locations.

To disable all telephony privileges for a user, enter a comma (,). You cannot remove telephony privileges for users with Personal Room enabled.


 

You can specify multiple teleconferencing types for any user account, if your organization has purchased the appropriate options. To specify multiple teleconferencing types, separate them with commas, without spaces—For example:

  • CLIN, CLBK, VoIP

  • To determine which teleconferencing services your organization supports, refer to the Site Administration home page.

SCOptions

(Optional) Available for Cisco Webex Support sites only. You can specify the following value in this field:

AREC: Auto record. Specifies that Remote Support automatically records support sessions that the user conducts.

If you leave this field empty, the value is left blank.

STComputers

(Optional) Available for Cisco Webex Support sites with the Remote Access option only. Applies only if you specified the Auto Record (AREC) for STOptions for the user. Specifies which computers the user can access remotely, using Remote Access. The computers must already be defined for Remote Access in Site Administration. Type the computer names exactly as they appear in Site Administration.


 

You can specify multiple computers for a user account. To specify multiple computers, separate them with commas, without spaces---For example:

Computer 1, Computer 2

If you leave this field empty, the value is left blank.

TimeZone

(Optional) Specifies the index number for the time zone in which the user resides.

If you leave this field empty, Webex Meetings uses the default time zone for the Webex site.

PhoneCntry

(Optional) Specifies the number that you dial to call a user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to 1.

PhoneLocal

(Optional) Specifies the user's phone number. Enter numbers only; do not include punctuation, such as dashes or periods.

If you leave this field empty, the value is left blank.

PhoneCallin

(Optional) Specifies the number that the user requires to call in. Enter numbers only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to N.

PhoneCallback

(Optional) Specifies the number, at which the user wants to be called. Enter numbers only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to N.

CellCntry

(Optional) Specifies the number that you dial to call a mobile phone user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to 1.

CellLocal

(Optional) Specifies the user's cell phone number. Enter only numbers; do not include punctuation, such as dashes or periods.

If you leave this field empty, the value is left blank.

CellCallin

(Optional) Specifies the number that the user requires to call in. Enter numbers only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to N.

CellCallback

(Optional) Specifies the cell phone number, at which the user wants to be called. Enter numbers only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to N.

AP1Cntry and AP2Cntry

(Optional) Specifies the number that you dial to call a pager user who resides in another country. Enter numbers and underscores (_) only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to 1.

AP1Local and AP2Local

(Optional) Specifies the user's pager number. Enter numbers only; do not include punctuation, such as dashes or periods.

If you leave this field empty, the value is left blank.

AP1Callin and AP2Callin

(Optional) Specifies the number that the pager user requires to call in. Enter numbers only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to N.

AP1Callback and AP2Callback

(Optional) Specifies the pager number, at which the user wants to be called. Enter numbers only; do not include punctuation, such as dashes or periods.

If you leave this field empty, it defaults to N.

Pin

(Optional) Specifies the user’s PCN audio personal identification number.

If you leave this field empty, the value is left blank.

AdditionalRecordingStorage

(Optional) Specifies the number of megabytes (MB) of extra storage space to allocate to the user for storing network-based recording files. Type only numbers in this field. If you do not want to allocate extra storage space to a user account, you can leave this field blank.

If you leave this field empty, the default value is 0.

TeleAcct1TollFree-Cntry

TeleAcct2TollFree-Cntry

TeleAcct3TollFree-Cntry

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1TollFree-Area

TeleAcct2TollFree-Area

TeleAcct3TollFree-Area

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1TollFree-Num

TeleAcct2TollFree-Num

TeleAcct3TollFree-Num

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1TollFree-IsTollFree

TeleAcct2TollFree-IsTollFree

TeleAcct3TollFree-IsTollFree

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1Toll-Cntry

TeleAcct2Toll-Cntry

TeleAcct3Toll-Cntry

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1Toll-Area

TeleAcct2Toll-Area

TeleAcct3Toll-Area

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1Toll-Num

TeleAcct2Toll-Num

TeleAcct3Toll-Num

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1Toll-IsTollFree

TeleAcct2Toll-IsTollFree

TeleAcct3Toll-IsTollFree

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1-SubAC

TeleAcct2-SubAC

TeleAcct3-SubAC

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1-PartAC

TeleAcct2-PartAC

TeleAcct3-PartAC

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

TeleAcct1RecordingDialOutNumFlag

TeleAcct2RecordingDialOutNumFlag

TeleAcct3RecordingDialOutNumFlag

(Optional) These fields contain data only if your site provides users with personal teleconference accounts, through the Webex Meetings Telephony API or the teleconference accounts option.


 

Do not add or edit data in these fields. If you export user account data, these fields populate with the teleconferencing numbers from the user’s personal teleconferencing accounts. The telephony server provides these numbers to the user when the user adds a personal teleconferencing account using the My Profile page.

If you leave this field empty, all information is retained.

  • 1: Specifies there's a toll.

  • 0: Specifies there's no toll.

LabAdmin

(Optional) Applies to Cisco Webex Training sessions only- specifies whether the user is an administrator for Hands-on Lab.

If you leave this field empty, the default is N.

SchedulePermission

(Optional) Applies to Webex Meetings, Training session, and Event sites only. Specifies the users who can schedule sessions on behalf of this user. You can specify only users who have accounts on the same Webex Meetings service site as this user. To specify a user, type the user's email address exactly as it appears for the user's account.

You can specify multiple email address, by separating them with commas and without spaces—For example: jsmith@anyco.com,mbartel@anyco.com

If you leave this field empty, the value is left blank.

PCNAcc1AutoGenerate

PCNAcc2AutoGenerate

PCNAcc3AutoGenerate

(Optional) Specifies whether the system automatically generates an access code.

This field can contain one of the following values:

  • Y: Specifies that the access code is automatically generated.

  • N: Specifies that the access code is not automatically generated.

If you leave this field empty, it defaults to Available. If PCN is not enabled, the value is left blank.

PCNAcc1HostAccCode

PCNAcc2HostAccCode

PCNAcc3HostAccCode

Read-only

(Optional) Specifies the host access code.

If PCN is not enabled, the value is left blank.

PCNAcc1TollFreeCallInNum

PCNAcc2TollFreeCallInNum

PCNAcc3TollFreeCallInNum

(Optional) Specifies the toll-free call in number.

If PCN is not enabled, the value is left blank.

PCNAcc1TollCallInNum

PCNAcc2TollCallInNum

PCNAcc3TollCallInNum

(Optional) Specifies the backup toll call number.

If PCN is not enabled, the value is left blank.

PCNAcc1ILNum

PCNAcc2ILNum

PCNAcc3ILNum

(Optional) Specifies that PCN account supports international call-in.

If PCN is not enabled, the value is left blank.

SupportCascading

(Optional) Specifies whether download bandwidth optimization is enabled for Event Center users. Bandwidth optimization allows relaying traffic to other clients on the same subnet.

If you leave this field empty, the default is N.

WebcastBasic

(Optional) Allows Webex Events users to broadcast online presentations and audio.

If you leave this field empty, the value is left blank.

WebcastVideo

(Optional) Allows Webex users to stream video.

If you leave this field empty, the value is left blank.

WebcastAdmin

(Optional) States whether the current user is a Webcast Administrator or Presenter. If checked, the user is an Administrator.

If you leave this field empty, the value is left blank.

SupportCMR

Read-only

(Optional) Specifies whether video device-enabled meetings are available for the user. This option is avaialble for Webex Meetings and Webex Events (panelists only).

  • 1: Specifies that video device-enabled meetings are available for the user.

  • 0: Specifies that video device-enabled meetings are not available for the user.

If you leave this field empty, the default is 0.

SupportPR

(Optional) Specifies whether Personal Room is available for the user (Meeting Center only).

  • 1: Specifies that the user has a Personal Room.

  • 0: Specifies that the user doesn't have a Personal Room.

If you leave this field empty, the default is 0.

SupportHQV

(Optional) Specifies whether high-quality video is available for the user (Meetings, Events, and Training sites only).

If you leave this field empty, the default is Y.

SupportHDV

(Optional) Specifies whether high-definition video is available for the user (Meetings, Events, and Training sites only).

If you leave this field empty, the default is Y.

VideoDeviceName1-5

(Optional) Specifies the name of the video device, at which the user wants to be called.

If you leave this field empty, the value is left blank.

VideoDeviceAddress1-5

(Optional) Specifies the address of the video device, at which the user wants to be called.

If you leave this field empty, the value is left blank.

DefaultVideoDeviceIndex

(Optional) Specifies the index number (from 1 to 5) of the user's default video device.

If you leave this field empty, the value is left blank.

Time Zones

Time zones are displayed in an easy-to-read format. The menu items display differently depending on whether or not the time zones are in DST (Daylight Savings Time). The time zone menu format uses this format:

Location (<Time zone name> <DST label> "Time", <GMT offset>)

An example of the time zone format as it displays is:

San Francisco (Pacific Standard Time), GMT-08:00

The following table lists the time zones by index and includes details about each time zone.

Table 1. Time Zone Index

Index

GMT

Name

Location

Standard

DST

0

-12 hr

Dateline

Marshall Islands

1

-11 hr

Samoa

Samoa

2

-10 hr

Hawaii

Honolulu

Standard

Daylight

3

-9 hr

Alaska

Anchorage

Standard

Daylight

4

-8 hr

Pacific

San Francisco

Standard

Daylight

5

-7 hr

Mountain

Arizona

6

-7 hr

Mountain

Denver

Standard

Daylight

7

-6 hr

Central

Chicago

Standard

Daylight

8

-6 hr

Mexico Central

Mexico City

Standard

Daylight

9

-6 hr

Central

Saskatchewan

10

-5 hr

S. American Pacific

Bogota

11

-5 hr

Eastern

New York

Standard

Daylight

12

-5 hr

Eastern

Indiana

Standard

Daylight

13

-4 hr

Atlantic

Halifax

Standard

Daylight

14

-4 hr

S. American Western

Caracas

15

-3.5 hr

Newfoundland

Newfoundland

Standard

Daylight

16

-3 hr

S. American Eastern

Brasilia

Standard

Daylight

17

-3 hr

S. American Eastern

Buenos Aires

18

-2 hr

Mid-Atlantic

Mid-Atlantic

Standard

Daylight

19

-1 hr

Azores

Azores

Summer

20

0 hr

Greenwich

Casablanca

21

0 hr

Greenwich Mean

London

Summer

22

1 hr

Central European

Amsterdam

Summer

23

1 hr

Central European

Paris

Summer

25

1 hr

Central European

Berlin

Summer

26

2 hr

Eastern European

Athens

Summer

28

2 hr

Egypt

Cairo

Standard

Daylight

29

2 hr

South Africa

Pretoria

30

2 hr

Eastern European

Helsinki

Summer

31

2 hr

Israel

Tel Aviv

Standard

Daylight

32

3 hr

Saudi Arabia

Riyadh

33

3 hr

Russia

Moscow

Standard

Daylight

34

3 hr

Nairobi

Nairobi

35

3.5 hr

Iran

Tehran

36

4 hr

Arabian

Abu Dhabi

37

4 hr

Baku

Baku

Standard

Daylight

38

4.5 hr

Afghanistan

Kabul

39

5 hr

West Asia

Ekaterinburg

40

5 hr

West Asia

Islamabad

41

5.5 hr

India

Bombay

42

5.5 hr

Columbo

Columbo

43

6 hr

Central Asia

Almaty

44

7 hr

Bangkok

Bangkok

45

8 hr

China

Beijing

46

8 hr

Australia Western

Perth

Standard

Daylight

47

8 hr

Singapore

Singapore

48

8 hr

Taipei

Taipei

49

9 hr

Japan

Tokyo

50

9 hr

Korea

Seoul

51

9 hr

Yakutsk

Yakutsk

52

9.5 hr

Australia Central

Adelaide

Standard

Daylight

53

9.5 hr

Australia Central

Darwin

54

10 hr

Australia Eastern

Brisbane

55

10 hr

Australia Eastern

Sydney

Standard

Daylight

56

10 hr

West Pacific

Guam

57

10 hr

Tasmania

Hobart

Standard

Daylight

58

10 hr

Vladivostok

Vladivostok

Standard

Daylight

59

11 hr

Central Pacific

Solomon Islands

60

12 hr

New Zealand

Wellington

Standard

Daylight

61

12 hr

Fiji

Fiji

130

1 hr

Central European

Stockholm

Summer

131

-8 hr

Mexico Pacific

Tijuana

Standard

Daylight

132

-7 hr

Mexico Mountain

Chihuahua

Standard

Daylight

133

-4.5 hr

S. America Western

Caracas

Standard

Daylight

134

8 hr

Malaysia

Kuala Lumpur

Standard

Daylight