expand_less
If you have a lot of values to add for a metric, adding these one at a time can be very time-consuming. The import feature allows you to upload a .CSV (comma-seperated-values) file with many metric values all at once. Any simple spreadsheet can be saved as a .CSV file (using software like Excel, OpenOffice Calc or Google Docs). The first step is to add the .CSV file as a source (middle button on 'add source' page, see image below).
{{import graphic 1|size:large}}
{{csvpic|float:right}}
The .CSV file you upload should contain two columns: Company and Value - the Company column should contain company names, the Value column should contain the corresponding value for each company.
When you upload a CSV file it becomes a source on WikiRate - please also write a short description of where the data inside the CSV came from, so that people who browse the metric later will know the original source for the values.
When you click submit the source will be created and you will see a page like the one below. Click "Import to metric values" to import the data inside the CSV file as values for a metric.
{{import graphic 2| size: large}}{{import graphic 2| size:original}}
{{import graphic 1|size:large}}
{{csvpic|float:right}}
The .CSV file you upload should contain two columns: Company and Value - the Company column should contain company names, the Value column should contain the corresponding value for each company.
When you upload a CSV file it becomes a source on WikiRate - please also write a short description of where the data inside the CSV came from, so that people who browse the metric later will know the original source for the values.
When you click submit the source will be created and you will see a page like the one below. Click "Import to metric values" to import the data inside the CSV file as values for a metric.