Reports: Converting Numerical Delimiters in Excel

Reports you generate in the Brightcove Studio Reports page are exported in CSV format, using the Anglophone convention for delimiters: comma to separate thousands and dot to separate decimals. To view a report in Microsoft Excel using the opposite convention (used in Germany and many other countries):

1. In the Brightcove Studio Reports page, create a report and click Download Report. This creates a CSV file.
2. In Excel, open a new blank document.
3. From the Excel menu bar, select Data > Import External Data > Import Data, select your CSV file, and click Open.
4. In step 1 of the Text Import Wizard, set File Type to Delimited and File Origin to MS-DOS (PC-8). Click Next.
5. In step 2 of the Text Import Wizard, select Comma as the delimiter and deselect any other delimiters that are currently selected. Click Next.
6. In step 3 of the Text Import Wizard, click Advanced. Change the decimal separator to the comma (,) and the thousands separator to the comma (.). Click Finish.
7. Select the starting cell for the data import and click OK. Excel imports the data, formatted with dot as the thousands separator and comma as the decimal separator.