Can I import/export my entire code list to Excel on ATLAS.ti Windows?

Can I export my entire code list to Excel?

Yes – You can also export and import your entire code list or your codebook to Excel. ATLAS.ti 23 Windows has integrated universal Excel export options, so that you can easily handle your data from an Excel spreadsheet

To do so:

Open the Code Manager, select " Export". You find "Export codebook (XLSX). Save your file in your preferred directory.

Export dialogue for creating a codebook in ATLAS.ti Windows

Importing an already existing codebook can be useful for a number of reasons:

  • To prepare a stock of predefined codes in the framework of a given theory. This is especially useful in the context of team work when creating a Master project.
  • To code in a "top-down" (or deductive) way with all necessary concepts already at hand. This complements the "bottom-up" or inductive coding stage in which concepts emerge from the data.

This is how you need to prepare the Excel file:

You can enter headings like Code, Code Definition, Code Group 1, Code Group 2, but you do not have to. If you do not enter headings, the columns are interpreted in the following order:

– column 1: code name– column 2: code description (comment)– column 3: code group– column 4: code group– all subsequent columns: further code groups

If you color the code names, this color is used in ATLAS.ti as code color.

To import the Excel file, select the Import & Export tab and next Codebook. From the dropdown menu, select Import Codebook (XLSX).

Prepare your code book in Excel, or export it to Excel.