Working with Survey Data in Excel

Background

This toolkit is part of a larger effort by DataShift to strengthen organisational capacity to work with data in an actionable way through the Data for Action programme. It was developed to serve as a guide for organisations in thinking critically about survey data using spreadsheets. The instructions contained in this manual are designed specifically for data entry by a single user using one computer at a time nd is not intended to be applicable for large-scale data collection utilising multiple data entry personnel on multiple devices.

This toolkit has been designed to fit two purposes:

  • As a quick reference for common functions and tools when working with survey data in Excel
  • As a guide for beginners working with survey data and Excel for the first time

What’s in the tool

The toolkit invites the reader to think critically about data while minimising decision-making during research; it takes us through a journey that starts with data entry to data cleaning and analysis. Data visualisation and communication are also covered in this guide, that also includes data security tips and checklists, and other useful techniques for your organisation.  

Downloads

Download in English

Sign up for our newsletters

Our Newsletters

civicus logo white

CIVICUS is a global alliance that champions the power of civil society to create positive change.

brand x FacebookLogo YoutubeLogo InstagramLogo LinkedinLogo TikTokLogo BlueSkyLogo

Johannesburg Hub

25  Owl Street, 6th Floor

Johannesburg
South Africa
2092

Tel: +27 (0)11 833 5959


Fax: +27 (0)11 833 7997

UN Hub: New York

CIVICUS, c/o We Work

450 Lexington Ave

New York
NY
10017

United States

UN Hub: Geneva

11 Avenue de la Paix

Geneva

Switzerland
CH-1202

Tel: +41 (0)79 910 3428