How to correctly display .csv files within Excel 2013?

by

Open the CSV file with a decent text editor like Notepad++ and add the following text in the first line:

sep=,

Now open it with excel again.

This will set the separator as a comma, or you can change it to whatever you need.

More Related Contents:

  1. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  2. Stop Excel from automatically converting certain text values to dates
  3. Microsoft Excel mangles Diacritics in .csv files?
  4. Excel to CSV with UTF8 encoding [closed]
  5. Excel CSV – Number cell format
  6. Generating CSV file for Excel, how to have a newline inside a value
  7. How to export a CSV to Excel using Powershell
  8. Export hashtable to CSV with the key as the column heading
  9. Save each sheet in a workbook to separate CSV files
  10. Export each sheet to a separate csv file
  11. Convert xlsx file to csv using batch
  12. Importing CSV with line breaks in Excel 2007
  13. How do I use awk under cygwin to print fields from an excel spreadsheet?
  14. converting an Excel (xls) file to a comma separated (csv) file without the GUI
  15. sep=”;” statement breaks utf8 BOM in CSV file which is generated by XSL
  16. How to save excel columns with long numbers into csv?
  17. Combine Multiple Tables Rows Into Master Table
  18. Can Excel interpret the URLs in my CSV as hyperlinks?
  19. Convert matrix to 3-column table (‘reverse pivot’, ‘unpivot’, ‘flatten’, ‘normalize’)
  20. How to return the number of dimensions of a (Variant) variable passed to it in VBA [duplicate]
  21. Find last used cell in Excel VBA
  22. Does Dir() make any guarantee on the order of files returned?
  23. Call a Sub with a String
  24. Get text from clipboard using GetText – avoid error on empty clipboard
  25. Benchmarking VBA Code
  26. Display milliseconds in Excel
  27. Application.Quit command not closing the entire Excel Application
  28. Trying to open the workbook in separate instance
  29. Application.WorksheetFunction.Match method
  30. Excel telling me my blank cells aren’t blank

Leave a Comment