Is it possible to force Excel recognize UTF-8 CSV files automatically?

Alex is correct, but as you have to export to csv, you can give the users this advice when opening the csv files:

  1. Save the exported file as a csv
  2. Open Excel
  3. Import the data using Data–>Import External Data –> Import Data
  4. Select the file type of “csv” and browse to your file
  5. In the import wizard change the File_Origin to “65001 UTF” (or choose correct language character identifier)
  6. Change the Delimiter to comma
  7. Select where to import to and Finish

This way the special characters should show correctly.

Related Posts:

  1. IndexError: too many indices for array
  2. IndexError: too many indices for array
  3. What is the difference between UTF-8 and ISO-8859-1?
  4. IndexError: too many indices for array
  5. Python – Reading and writing csv files with utf-8 encoding
  6. Invalid column count in CSV input on line 1 Error
  7. Invalid column count in CSV input on line 1 Error
  8. ValueError: cannot index with vector containing NA / NaN values
  9. How can I import an Excel file into SQL Server?
  10. Adding a newline character within a cell (CSV)
  11. Substring in excel
  12. Writing a pandas DataFrame to CSV file
  13. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  14. Swap x and y axis without manually swapping values
  15. Excel: Calculate the frequency of a particular month in a column of date cells
  16. ValueError : I/O operation on closed file
  17. csv.Error: iterator should return strings, not bytes
  18. u’\ufeff’ in Python string
  19. How to remove \xa0 from string in Python?
  20. Help needed with Median If in Excel
  21. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  22. How to find a value in an excel column by vba code Cells.Find
  23. Python Error io.UnsupportedOperation: not readable
  24. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  25. Object Required Error in excel VBA
  26. Dump a NumPy array into a csv file
  27. How to parse a CSV file using PHP
  28. Is there a way to include commas in CSV columns without breaking the formatting?
  29. Convert XML to CSV file
  30. TypeError: list indices must be integers or slices, not str
  31. Elegant way to search for UTF-8 files with BOM?
  32. What are .NumberFormat Options In Excel VBA?
  33. VBA, if a string contains a certain letter
  34. What is the difference between UTF-8 and Unicode?
  35. Convert from CSV to array in Python
  36. Python import csv to list
  37. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  38. Workaround for “Formula omits adjacent cells”
  39. ValueError: x and y must be the same size
  40. How to concatenate text from multiple rows into a single text string in SQL Server
  41. Why does “Paste Method of Worksheet class failed” occasionally occur?
  42. check if a file is open in Python
  43. How to return a result from a VBA function
  44. Exception from HRESULT: 0x800A03EC Error
  45. Use VBA to Clear Immediate Window?
  46. python csv2libsvm.py: AttributeError: ‘_csv.reader’ object has no attribute ‘next’
  47. Syntax error on token(s), misplaced construct(s)
  48. Python CSV error: line contains NULL byte
  49. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  50. Python CSV Error: sequence expected
  51. Using unicode character u201c
  52. convert csv file to list of dictionaries
  53. UnicodeDecodeError: ‘utf8’ codec can’t decode byte 0x80 in position 3131: invalid start byte
  54. VBA: Convert Text to Number
  55. _csv.Error: field larger than field limit (131072)
  56. VBA Error: “Compile error: Expected End Sub”
  57. Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
  58. Error -1072896636 “DTD Prohibited” when opening xml file in Excel, what do I do?
  59. How to open an Excel file in C#?
  60. Change default ‘delimiters’ in excel
  61. Loop without Do error
  62. How to install Date Picker form control in Excel 2016
  63. How to install Date Picker form control in Excel 2016
  64. How to fill color in a cell in VBA?
  65. (Excel) Conditional Formatting based on Adjacent Cell Value
  66. Is there a coalesce-like function in Excel?
  67. How to label scatterplot points by name?
  68. Average in VBA in Excel
  69. Paste Special error 1004 PasteSpecial method of Range class failed
  70. Cannot run the macro… the macro may not be available in this workbook
  71. Is there a way to crack the password on an Excel VBA Project?
  72. How to import CSV into Custom Post Type custom fields?
  73. Export User Info to CSV from Front End
  74. Export WordPress Table to CSV from page
  75. Export entries and multiple custom field meta to .csv?
  76. WordPress.com Stats stats_get_csv with custom field?
  77. CSV syntax for WP All Import upload without ACF
  78. Cron job update csv, need help solving :-)
  79. Importing CSV into database table not working?
  80. Feed format for woocommerce [closed]
  81. What’s the fastest way to import products with variations in WooCommerce (CSV, XML, …) [closed]
  82. Creating custom page template from existing PHP site
  83. Exporting a form to a CSV file does not work in WordPress but it does in PHP
  84. How to add CSV upload functionality on the edit page of a Custom Post Type
  85. How to fetch csv file and show in shortcode
  86. best way to upload a large file to wordpress using wp all import
  87. How to send a particular csv file as an email?
  88. Why is that only the first row getting inserted into Mysql table when i import csv file on backend custom plugin?
  89. Export to csv adding html to file
  90. Updating the database after parsing CSV document
  91. Query a custom taxonomy in a function to create an csv file
  92. multiple string replace of post’s content for large data
  93. how can i import the csv file in wordpress woocommerce.?
  94. Creating connections programmatically with common fields on CPT’s
  95. Function to get the name in database table from the comma separated string
  96. I would like to import two columns into WordPress
  97. CSV import stopped working when I upgraded to WP 3.5.2
  98. Reading CSV values and showing them in PHP
  99. WordPress Custom Post type csv exporter
  100. How to set an exact search box in tablepress plug-in

Leave a Comment

tech