Skip to main content

Collect and clean data using Excel spreadsheets.

Project description


## Introduction

datamaps is a command line tool, written in Python, which facilitates the collection of data using Excel as the ‘form’. It accepts that Excel files are freely distributable, easy to understand and already well integrated in the non-technical office environment.

The tool uses a concept a datamap, which is simple, user-created CSV file which maps cell references within Excel ‘templates’. The datamap concept makes it easy to design pretty Excel spreadsheets with blank cells (the ‘template’) intended for the user to complete - the cell references in the datamap inform the datamaps program where it should expect to find user-entered data. At this point, the output is another master spreadsheet which contains all the data from each completed template compiled into a single table. This is then used by other tools for further analysis.

The documentation found at [Datamaps - Twenty Four Software]( gives a more detailed explanation.

## Installation

pip install datamaps

## Bugs and issues

Please report bugs as [Github issues](

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

datamaps-1.1.9.tar.gz (20.3 kB view hashes)

Uploaded source

Built Distribution

datamaps-1.1.9-py3-none-any.whl (23.9 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page