Can I export my entire code list to Excel?

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 8 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 all codes and export to Excel or as spreadsheet.  You find a ‘Create Report’ option in each browser at the top right-hand side in the ribbon or toolbar.

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 base project.
    To code in a “top-down” (or deductive) way with all necessary concepts already at hand. This complements the “bottom-up” (or inductive) *open coding* stage in which concepts emerge from the data.

You can prepare a code book including code descriptions, code groups and colors in Excel and import the Excel file. 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.

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

See also the following video tutorials: