> For the complete documentation index, see [llms.txt](https://docs.yourv.id/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.yourv.id/royalties-and-payments/reports/open-csv-files.md).

# Open CSV Files

We provide reports about asset performance in CSV format. 

Depending on your Excel's regional setting, your default delimiter/separator may either be using semicolons (;) or commas (,) to separate items in a CSV file. If your regional setting is to use semicolons, this can cluster all the field values into column A because exported files from YourVid use commas (,) as the default delimiter/separator.

In this case, we suggest using **Google Sheets** to convert the CSV to any format that you can process:

1. Create a new sheet in Google Sheets.
2. Go to "File" -> "Settings", and set "Locale" to "United States". Click "Save and reload". 

   <figure><img src="/files/uXHWbm8ENtSvKFal1KkU" alt=""><figcaption></figcaption></figure>
3. Click "File" -> "Import" and select/upload our report in CSV format.
4. Select "Insert new sheet(s)" as "Import location", make sure the other inputs are as on the screenshot, and click "Import data".

   <figure><img src="/files/v2Y2zXS4rZdX3A2tSw0D" alt=""><figcaption></figcaption></figure>
5. The report should be imported correctly, like this:<br>

   <figure><img src="/files/pxAAAq5n4JqZk4FXDUqa" alt=""><figcaption></figcaption></figure>
6. You can now view and process the report in Google Sheets. Alternatively, click "File" -> "Download" -> "Microsoft Excel (.xlsx)" to download a file you can open in Excel.