Lune Docs Logo
Log inContact us

CSV upload

Calculate the CO₂e emissions for your transactions by uploading a CSV.

Pre-requisites

Complete the following setup steps before using this guide:
/illustrations/stamp-analytics.png
Log in and familiarize yourself with the Lune dashboard.

1. Fill in the CSV

Each row in the CSV represents a single transaction. Only a few pieces of information are required for each row.Lune uses semantic search to determine the best emission factor for your transaction given the informartion. You can generate several calculations for each transaction by adjusting the limit heading.
version
Required. Set this to 1 for all rows.
limit
The maximum number of emission factor matches to calculate an emission estimate for. A new calculation will be preformed for each match.
transaction_id
A unique identifier for reconciling emission estimates with transactions in your system. Generate this string to track transactions in the results CSV.
item
The item purchased.
category
The category that best describes the purchase.
price
Monetary value of the item. This should exclude shipping and taxes.
currency
The ISO 4217 3 character currency code. Note: Lune supports most but not all currency codes.
country_code
The three letter country code of the merchant’s country.
region_fallback
If an emission factor for the specified country code can not be identified, setting this to “true” will result in a search for emission factors outside of the region. The default is false, where no fallback is preformed.
Get started with a ready-made CSV template from the Lune dashboard.

2. Upload the CSV

Populate the CSV sheet using your preferred editor. You can either omit or leave blank any non-required columns. Once all required values have been added, save the file in .csv format, ensuring it has the .csv file extension.Next, go to the fintech spreadsheet calculation page to upload your file. You can upload the CSV by either dragging and dropping it onto the page or clicking the Upload button to select the file manually. Make sure the file size does not exceed 2MB.An image showing the drag and drop area of the dashboard, where the CSV can be uploaded.Once uploaded, the file will begin processing automatically. You will receive an email notification when the processing is complete.

3. Interpret the results

Once the sheet has been processed and you receive the confirmation email, you can download the results directly from the confirmation email.The results are also available in a table at the bottom of the fintech spreadsheet calculation page. This table displays each upload, the number of calculations processed, and provides an option to download the results.The results are provided in CSV format. Your original submitted data remains intact, with a few additional headings added to the results file.If several matches were requested, a matchX_ prefix will be added to the headings, where X is the number of the match. For example, if the limit was set to three, there will three estimate IDs returned, one for each estimate calculation based on the respective match: estimate_id, match2_estimate_id, and match3_estimate_id.
estimate_id
The unique identifier for the emission estimate.
dashboard_url
The URL to the specific emission calculation page in the Lune dashboard. This page allows you to review your estimate, understand how the emissions were calculated, and offset emissions.
client_account_analytics_url
This column is populated if the estimate was made for a client account. This page allows your customers to view their shipment analytics, review individual calculations, and better understand how the emissions were calculated.
total_mass_tco2
The total emission estimate for the transaction calculated based on the matched emission factor, measured in tCO₂e.
emission_factor_name
The name of the matched emission factor chosen in the emission estimate calculation.
confidence_score
The confidences score when performing a search for the transaction and it's best suited emission factor (0.0 is very confident, 2.0 lowest confidence). Only results < 0.15 are returned.
error
Describes any error encountered when processing the row. If this column is populated, the row failed to process and no results were returned. Review and correct the provided data.
Success! Just like that, you’ve calculated emissions for your transactions. This brings you one step closer to climate compliance!

What to do next...

Now that you have your estimate, there are several actions you can take!