JSI Tip 7613. When you use the Windows Management Instrumentation Command-line to generate a CSV file, it is NOT properly formatted in Excel?

When you use the /FORMAT:CSV switch with WMIC in Windows Server 2003, and open the CSV in Excel, it is NOT properly formatted.

To workaround this behavior, after the CSV has been generated, use the following command to convert it from UNICODE to ANSI:

type Unicode.csv >Ansi.csv



Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish