I have the text with special characters like "Gürhan Bakırküre" but when i export this as CSV and opened with excel it was showing as "Gürhan Bakırküre".
I am exporting the text using drupal data export view.
3 Answers
May be below link can help you - http://www.jpstacey.info/blog/2015-05-04/unicode-accented-characters-drupal-views-data-export-and-excel.
In a nutsehll, jus follow below instructions-
Copy views-data-export-csv-header.tpl.php to site's custom theme, and add a single executable line (print "\xEF\xBB\xBF";) to write the BOM:
<?php
// Print out header row, if option was selected.
if ($options['header']) {
// Begin file with UTF-8 BOM.
print "\xEF\xBB\xBF";
// Now continue to output header as normal.
print implode($separator, $header) . "\r\n";
}
Thanks
4 Comments
Prudhvi
Please avoid link-only answers as links might tend to change or break in the future. Instead explain the answer here itself.
user3686276
Thanks user5317514 ..the information in above link helped.
user-pj
@prudhvi, I agree with you, i will post the answer seprately, plz vote up
Prudhvi
@user5317514 Please edit your answer, by copying your comment.
You need to choose the proper encoding in the Excel import dialog. For example, I saved the following sample data into a CSV file:
Gürhan Bakırküre, 1
Tim Biegeleisen, 2
I saved the file as UTF-8, since I do not know the exact encoding of your actual data. During the import process in Excel, I made sure to also select the same UTF-8 encoding as shown in this screen capture:
The text rendered in Excel correctly with no problems. You should probably find out what exact encoding your original file is and use that when you import.
2 Comments
user3686276
Thanks Tim, i am exporting the data using drupal view.May be it causing.
Tim Biegeleisen
Please try my answer and then mark it correct if it solved your problem.
Drupal 8 and Drupal 9, Unicode signature can be included in format settings
