Skip to main content


 

 

druva_logo.pngDruva
|
Documentation

How can we help you?

Trending articles:

 

Druva Documentation

How to correctly display inSync CSV reports in Microsoft Excel

  1. Last updated
  2. Save as PDF
Heads up!

We've transitioned to a new documentation portal to serve you better. Access the latest content by clicking here.

This article applies to:

  • OS: All versions of Windows OS
  • Product edition: inSync Cloud and On-Premise

Overview

On opening inSync reports in .csv (comma separated values) format using Microsoft Excel, the values in the file are displayed in a single column. This article describes the procedure to distribute the comma separated values into their respective column headers when displayed in Microsoft Excel.

CSVExcelDisplay.png 

Since the decimal point in Windows machines of European countries is a comma (,) instead of a period (.), Microsoft Excel displays all the values in a single column. 

EuropeanComma.png

Procedure 

  1. To change the decimal symbol from comma to period (dot), open Regions from Control Panel.
  2. Click Additional settings.

    AdditionalSettings.png
  3. Change the Decimal symbol from comma to period (dot).

    ChangeDecimal.png
  4. Apply the settings and open the inSync .csv reports in Microsoft Excel. The data is displayed under their respective column headers.

    TabularValues.png