Importing and loading data in CMA

This article helps in importing and loading data from other programs such as Ms-Excel. Furthermore, it will take up the case example of Cholecystitis and gallbladder carcinoma illustrated in manual data entry procedure. This feature allows to easily transfer data from other programs.Consequently this also facilitates the transfer of data maintained beforehand, not especially for meta-analysis.

For this article, the data loading or importing procedures will utilize the odds ratio data as described in the previous article. The odds ratio data involves the comparison of ‘Case’ and ‘Control’ subject groups. It will indicate the odds of an individual developing carcinoma of the gallbladder as associated with the presence of gallstones.

Importing from Excel to CMA spreadsheet

From here the instructions will be on loading data from other softwares such as Ms-Excel, SPSS or STATA. The present demonstration includes importing data from Ms-Excel. The MS-Excel datasheet as shown below, contains data for the odds ratio taken from the relevant studies.

Data in excel spreadsheet

Figure 1: Data in excel spreadsheet

The odds ratio refers to the statistical range used for assessing the risk of a specific outcome such as a disease as influenced by the presence of particular factor or exposure (Westergren et al. 2001). Now, importing data from other programs into comprehensive meta analysis (CMA) software spreadsheet could be initiated from any of the two options as shown below.

Options for importing data

Figure 2: Options for importing data

Either select “Import data from another programme” from the welcome dialog box or:

  1. go to ‘File menu’.
  2. Click onImport’.

As signified in the image, selecting any of the two options leads to the ‘Import data’ dialog box, which instructs on how to import the data, which is by performing simple copy and pasting commands. It results in the CMA spreadsheet display as shown below.

Copied data in CMA worksheet

Figure 3: Copied data in CMA worksheet

However, note that this will lead to the pasting of data values only, not the column names as in the excel sheet. Follow the below mentioned steps to facilitate the process of identification.

The “Identify” tab helps in identification of the relevant fields of data according to the pre-designed format offered by CMA.

Identifying study names

The first column “A” contains the study names. Keep column A active and perform the selection:

  1. Click on ‘Identify’.
  2. Bring cursor on ‘Column for’.
  3. Select ‘Study names’.

This selection leads to the confirmation dialog box as shown below.

Identification of the column with Study names

Figure 4: Identification of the column with Study names

Identifying columns for effect size data

Following the identification of study names, proceed towards the identification of the effect size data.

  1. Click on ‘Identify’.
  2. Bring cursor on ‘Column for‘.
  3. Select ‘Effect size data’.

This leads to the dialog box for ‘Identify columns for effect size data’, as shown below.

Proceeding towards effect size data identification

Figure 5: Proceeding towards effect size data identification

After selecting ‘Next’ select the relevant study design from the dialog box, as shown below. The given dataset concerns the comparison between two groups. Therefore, select “Comparison of two groups, time points or outcomes”.

Selection of desired data entry format

Figure 6: Selection of desired data entry format

As the odds ratios from different studies represent the computed effect sizes, perform the following:

  1. Select ‘Dichotomous’.
  2. Bring cursor on ‘Computed effect sizes’.
  3. Select ‘Odds ratios and confidence limits’.

Furthermore, select any of the available formats suiting their study design. The selection of desired data entry format is followed by identification of column containing the appropriate data, as shown below.

Identifying the columns for the effect size data as per the selected data entry format

Figure 7: Identifying the columns for the effect size data as per the selected data entry format

  1. Column B identifies as odds ratio,
  2. column C as the lower limit,
  3. column D as upper limit,
  4. column E identifies as confidence interval.

In this module, confidence interval is reported at 95%, hence the information is entered manually. The software names the identified columns as per their designation and changes the column names from alphabets to the format entry name.

Final spreadsheet

The figure below shows the final spreadsheet, complete with all the data entry columns. The ‘Odds ratio’ and ‘Logs odds ratio’ are the effect size measures, whereas ‘Std. Err.’ and ‘Variance’ constitutes measures of accuracy. The software automatically computes these fields and displays them in relevant columns.

Final spreadsheet

Figure 8: Final spreadsheet

Data entry formats in CMAUnderstanding the process of selecting data entry formats in meta-analysis

Yashika Kapoor

Research analyst at Project Guru
Yashika has completed her bachelors in life sciences and holds a masters in forensic sciences. Being a major in forensic biology, she is trained in techniques of DNA extraction and sequencing. She also has hands on experience of dealing with sensitive evidences and case files. She aims at developing her knowledge base through fact based learning. With a penchant for reading, and writing, she likes to keep her facts concrete. She is a confident person and aims at achieving perfection in every task assigned to her. She aims at securing a place in her professional life which allows her to explore different areas relevant to her field of work. Along with academics, she is a creative soul. Food, art and craft are some of her other passions.
Yashika Kapoor

Related articles

  • Introducing Comprehensive Meta analysis (CMA) software The Comprehensive Meta-analysis (CMA) software is a user-friendly and diverse software. It is capable of handling and executing multiple tests involved in performing Meta-analysis.
  • Data entry formats in CMA The earlier article (Introduction to CMA) gave a brief overview of the various functionalities offered by the CMA software. This article acquaints the user with the procedure of selecting appropriate data entry formats.
  • Performing manual data entry in CMA spreadsheet Following the discussion on the significance of effect sizes, and selecting suitable data entry formats, this next step is to understand different software functionalities through appropriate case studies.
  • Continuous data entry in CMA involving comparison between groups Acquaintance with different methods of entering data in the software makes the task simpler. The manual data entry included entering the raw data for the dichotomous category for the study investigating one group.
  • Computing meta analysis with different effect size with CMA The discussion surrounding meta analysis has effect size at the prime spot. It is the magnitude or size of an effect and usually refers to treatment effect in comprehensive meta analysis (CMA).


We are looking for candidates who have completed their master's degree or Ph.D. Click here to know more about our vacancies.