Import data from a file

Data can be imported into Position Green from the following kinds of files:

• Excel .xlsx
  
• CSV .csv
  
• Google Sheets - Ensure the file is "Shared with everyone."

Supply the data to the files page, and Position Green will insert the data. 

Contact your Position Green team to explore the possibilities of file import in adding data directly into measures.

Importing data from files:

• Ensure that there are existing active measure point(s) to store the data in Position Green.
• All versions of the file to import data from must have the same format. This allows the Position Green team to work effectively with the data upload.
• If new information is added to the file relating to a measure or unit, e.g. a new organizational unit in an electricity consumption report. Contact your Sustainability Platform Manager to input the data.

Additional settings for file imports:

Some settings can be altered when creating an import, such as:

• Access level: Controller's can reach the import page. Controllers can alter who can access specific import(s). 
  
  
• Auto-confirmation: When importing data, data may be entered in a large number of registrations. Registrations connected to an import can be auto-confirmed. However, we recommend that you go through the registrations and confirm them manually to ensure the quality of the data.
  
  
• Data validation: It is possible to set up basic validations of the data to ensure that essential data in the file is not missing. Validation criteria leads to a warning or an error being generated when invalid data is imported. Contact your Position Green team to set up validation criteria.