The quickest way to get your data into Worksheet Systems is to use our comprehensive importing tool to extract data from an existing spreadsheet.
The data import wizard or Quandl Dataset Explorer will appear. You now need to select your XLS or CSV file from the location where you saved it, or specify a Quandl dataset.
The XLS/CSV import wizard will now grab the fields from your existing data and list them on the screen.
You need to select the correct data type for each of these fields, for Worksheet Systems to understand how to manipulate the data. You can choose from the following data types:
You also need to select a key field. This is a unique field – a column where every entry is unique. Having a unique field ensures that every single row in your data table is unique, and the data is not repeated. You can either add it manually by using the checkbox to the left of your field information, or click Add Unique ID for the system to generate the key.
If you follow the steps correctly, you will see a link to your new table under Data Tables on the left. Click this link to view and modify your table.