Skip to content

Importing and managing your data

NumberLens allows you to centrally manage all of your data and keep it up to date either manually or by uploading new data files.

Inputting your data

The data input in NumberLens is designed to be as easy to use as possible to allow you to focus on what you really want to do, visualise your numbers.

Data files can be uploaded directly from your computer or device or downloaded from your cloud storage provider directly into the system (currently Dropbox, Google Drive and OneDrive although additional providers can be added on request). After you upload a file the system asks which of the data fields you would like to import into the system thus allowing you to exclude any data that is not required.

If you don't have your data in a file you may type it in. First create your data fields, supplying a name and a type of data (numeric, text etc.). Once you have your fields you can type your data values directly into the system.

Selecting fields from a data file

Selecting fields from a data file

Refreshing or editing your data

All of your data sources can be refreshed at any time. You can choose to use the same method which created the data or a different method. For example, data uploaded from your computer can be manually edited and updated. Or you can download manually created data to a file, make changes to the data in the file and upload it back to the system to update the original data.

When refreshing the data from a file you have the option to replace the current stored data with the data from the new file or to append the data as additional rows.

All data sources can be manually edited to allow you to make corrections, keep data up to date and add additional records. The data editing facility also allows you to manage the data fields/columns of your data source. Existing fields may be removed or renamed and new fields may be added.

Exporting your data

All of your data can also be exported to data files and either downloaded to your computer or device or uploaded to your cloud storage provider directly from the system. This includes all data you have manually created using the system.

You may also choose to send your data in a data file as an email attachment directly from the system.