Exporting and Importing Visual Studio Analyzer Data

See Also

You can export Visual Studio Analyzer event logs to a standard, comma-separated variable (.csv) file, which you can then open in Microsoft® Access, Microsoft® Excel, or similar programs. You can also import exported Visual Studio Analyzer event logs back into Visual Studio Analyzer.

Note:   Some programs, such as Microsoft Excel, might treat exported Visual Studio Analyzer data as numeric, even when the data is enclosed in quotes. This can cause data to be translated incorrectly; for example, the hex value "1e8" might be incorrectly translated into the exponential value 1.0 E+8 = 100000000. If you run into this conversion problem with your data, then you might want to explicitly import your data into these programs as text. For Excel, this means renaming the .csv file to an alternate extension. Once you rename the file extension, Excel will prompt you for the data type of each field.

To export Visual Studio Analyzer log data

  1. In the Project Explorer, select the event log you want to export.

  2. Click the Analyzer menu, and then click Export Events.

  3. In the File Name box, type a name for the data file.

  4. Change the location of the saved file (optional).

  5. Click Save.

To import exported Visual Studio Analyzer log data

  1. In the Project Explorer, select an event log.

    Important   You cannot import into the active event log.

  2. Click the Analyzer menu, and then click Import Events.

  3. Select the exported data file you want to import.

  4. Click Open.