Apaul: Die Seite wurde neu angelegt: „== Encoding / Format == {| | style="vertical-align:top; width:60em"| All files in csv format generated by Vensoft are encoded with the UTF-8 character set inc…“

2022-02-16T08:44:36Z

Die Seite wurde neu angelegt: „== Encoding / Format == {| | style="vertical-align:top; width:60em"| All files in csv format generated by Vensoft are encoded with the UTF-8 character set inc…“

Neue Seite

== Encoding / Format ==

{|
| style="vertical-align:top; width:60em"|
All files in csv format generated by Vensoft are encoded with the UTF-8 character set including BOM (Byte Order Mark). This ensures the greatest possible compatibility with the most common Windows applications and in particular Microsoft Excel for displaying special characters.

A <code>; (semicolon)</code> is used, it is the standard for German-speaking countries.

If necessary, the coding can be changed when sending or saving the file. As a result, special characters may no longer be displayed correctly. The current coding can be checked, for example, with the free text editor Notepad++. Therefore, if possible, csv files should first be opened with Excel and saved as xlsx files.
|}
{|
| style="vertical-align:top"|
[[File:CSV_1.png|300px|thumb|left|1]]
|}

== Save ==

{|
| style="vertical-align:top; width:60em"|
Files in csv format should never be saved again in csv format after processing with Microsoft Excel, otherwise formatting information will be lost and the layout, for example, will be destroyed. Instead, save the file directly as an xlsx file (standard format since Office 2013) after opening and before editing with Excel.<br>
File {{Pfr}} Save As {{Pfr}} File Type "Excel Workbook (*.xlsx)"
|}
{|
| style="vertical-align:top"|
[[Datei:CSV_2.png|300px|thumb|left|2]]
| style="vertical-align:top"|
[[Datei:CSV_3.png|300px|thumb|left|1]]
| style="vertical-align:top"|
[[Datei:CSV_4.png|300px|thumb|left|4]]
|}

== Open ==

{|
| style="vertical-align:top; width:60em"|
As a rule, Excel automatically recognizes the formatting, i.e. the division of the columns and the cell format of a csv file. If this does not happen, you can import the file manually and explicitly select the character set and the column separator character.

Data {{Pfr}} From Text/CSV {{Pfr}} Select file and import (in older Excel versions also "From Text" instead of "From Text/CSV").
|}
{|
| style="vertical-align:top"|
[[Datei:CSV_5.png|300px|thumb|left|5]]
| style="vertical-align:top"|
[[Datei:CSV_6.png|300px|thumb|left|6]]
| style="vertical-align:top"|
[[Datei:CSV_7.png|300px|thumb|left|7]]
|}

{|
| style="vertical-align:top; width:60em"|
File Origin: 65001: Unicode (UTF-8)<br>
Separator: semicolon (depending on the Excel version, multiple selections may be possible, select only semicolons)
|}
{|
| style="vertical-align:top"|
[[Datei:CSV_8.png|600px|thumb|left|8]]
|}
{| class="wikitable"
| [[Datei:Hinweis.png|50px]]
| style="background-color:#b1cded; width:60em"|
'''Note:'''<br />
*Screenshots from Excel 365 (status: 01/24/2020). Other versions may differ.
*If using Excel 365, under Data type detection, select Based on entire dataset or Do not detect data types.
|}
[[Category:Index]]
[[Category:Instructions]]
[[Category:Help]]
[[Category:Vensoft]]

Notes on handling csv files - Versionsgeschichte

Apaul: Die Seite wurde neu angelegt: „== Encoding / Format == {| | style="vertical-align:top; width:60em"| All files in csv format generated by Vensoft are encoded with the UTF-8 character set inc…“