Opening CSV Reports With Non-English Text in MS Excel

KB Home   |   Opening CSV Reports With Non-English Text in MS Excel

Main.CSVReportsAndExcel History

Hide minor edits - Show changes to output

Changed lines 11-19 from:
!!! Import data into Excel and specify the character encoding

To work around this problem you do the following steps to use Excel:
* Save the .csv file as .txt
* Open the .txt file in Excel. This will bring up the 'import wizard'
* Choose 'Delimited' data type, and specify an appropriate encoding to match the contents of your report

!!!
Change the character encoding PaperCut uses to create CSV files
to:
!!! 1. Change the character encoding PaperCut uses to create CSV files
Changed lines 27-34 from:
to:
!!! 2. Import data into Excel and specify the character encoding

To work around this problem you do the following steps to use Excel:
* Save the .csv file as .txt
* Open the .txt file in Excel. This will bring up the 'import wizard'
* Choose 'Delimited' data type, and specify an appropriate encoding to match the contents of your report

Changed lines 5-6 from:
When opening a CSV report in MS Excel, some non-English characters (or symbols like the British Pound or Euro sign) may not display correctly.  This is usually related to the complex and confusing topic of [[ http://en.wikipedia.org/wiki/Character_encoding | character encoding]].  PaperCut generates the text-based CSV files in the operating system's default character encoding.  Sometimes there is a mismatch between the encodings where PaperCut is running (e.g. on a Mac or Linux server) and the Windows machine where Excel is running.
to:
When opening a CSV report in MS Excel, some non-English characters (or symbols like the British Pound () or Euro () sign) may not display correctly.  This is usually related to the complex and confusing topic of [[ http://en.wikipedia.org/wiki/Character_encoding | character encoding]].  PaperCut generates the text-based CSV files in the operating system's default character encoding.  Sometimes there is a mismatch between the encodings where PaperCut is running (e.g. on a Mac or Linux server) and the Windows machine where Excel is running.
Changed lines 3-7 from:
When opening a CSV report in MS Excel, some non-English characters may not display correctly.

This is because Excel does not correctly detect the encoding of CSV files
, and assumes ASCII encoding.  In general, MS Excel's support for Unicode text is very poor.  Alternative spreadsheet applications such as [[http://www.openoffice.org/product/calc.html | OpenOffice Calc]] and [[http://koffice.kde.org/kspread/ | KOffice KSpread]] correctly detect and display CSV files.

If you must use Excel, you can use the following workaround
:
to:
PaperCut offers a large variety of reports to allow you to analyse your printing usage in many different ways.  These reports are available in PDF, HTML and Excel/CSV.

When opening a CSV report in
MS Excel, some non-English characters (or symbols like the British Pound or Euro sign) may not display correctly.   This is usually related to the complex and confusing topic of [[ http://en.wikipedia.org/wiki/Character_encoding | character encoding]].  PaperCut generates the text-based CSV files in the operating system's default character encoding.  Sometimes there is a mismatch between the encodings where PaperCut is running (e.g. on a Mac or Linux server) and the Windows machine where Excel is running.

Unfortunately, Excel doesn't do a very good job of detecting the correct character encoding, which can result in some of these characters from displaying incorrectly.  Alternative spreadsheet applications such as [[http://www.openoffice.org/product/calc.html | OpenOffice Calc]] and [[http://koffice.kde.org/kspread/ | KOffice KSpread]] correctly detect and display CSV files.

There are a couple of options to try ...

!!! Import data into Excel and specify the character encoding

To work around this problem you do the following steps to use Excel
:
Added lines 18-34:
!!! Change the character encoding PaperCut uses to create CSV files

Instead of using the platform default, you can force PaperCut to use a particular character encoding.  To do this:
* Login to the PaperCut admin interface
* Go to the "Options" tab.
* Select the "Config Editor (Advanced)" option.
* Find the "reports.csv-charset" and set to an appropriate encoding.  For most western languages, "ISO-8859-1" is an appropriate choice.  A sample of options are:
** UTF-16LE - a unicode format commonly used on Windows.
** ISO-8859-1 - used for most western and latin based languages
** UTF-8 - a unicode format commonly used on Linux and Mac
* Press the "Update" button next to the setting and confirm that the setting changed.
* Re-create a report and test that it works as expected.

Some testing may be required to find the appropriate encoding for your language and tools.


Changed lines 13-14 from:
''Categories:'' [[!Reporting]], [[!Translation]]
----
to:
''Categories:'' [[Category.Reporting|+]], [[Category.Translation|+]]
August 17, 2007, at 05:26 AM by 218.214.136.161 -
Changed lines 1-2 from:
(:title Opening CSV Reports With Non-English in MS Excel :)
to:
(:title Opening CSV Reports With Non-English Text in MS Excel :)
Added lines 1-14:
(:title Opening CSV Reports With Non-English in MS Excel :)

When opening a CSV report in MS Excel, some non-English characters may not display correctly.

This is because Excel does not correctly detect the encoding of CSV files, and assumes ASCII encoding.  In general, MS Excel's support for Unicode text is very poor.  Alternative spreadsheet applications such as [[http://www.openoffice.org/product/calc.html | OpenOffice Calc]] and [[http://koffice.kde.org/kspread/ | KOffice KSpread]] correctly detect and display CSV files.

If you must use Excel, you can use the following workaround:
* Save the .csv file as .txt
* Open the .txt file in Excel. This will bring up the 'import wizard'
* Choose 'Delimited' data type, and specify an appropriate encoding to match the contents of your report

----
''Categories:'' [[!Reporting]], [[!Translation]]
----

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on September 13, 2010, at 04:55 AM
Printable View   |   Article History   |   Edit Article