Excel in DAT umwandeln

PDF download PDF herunterladen
unter Mitarbeit von wikiHow Staff

PDF download PDF herunterladen

In diesem wikiHow zeigen wir dir, wie du auf einem Windows-PC eine Microsoft Excel-Datei (.XLS) ins .DAT-Format umwandelst. Du beginnst mit der Konvertierung der .XLS-Datei in eine .CSV-Datei (Comma Separated Values) und dann kannst du die Datei in einem Programm wie Notepad ins .DAT-Format umwandeln.

Teil 1
Teil 1 von 2:

In .CSV umwandeln

PDF download PDF herunterladen
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/5a\/Convert-Excel-to-Dat-Step-1.jpg\/v4-460px-Convert-Excel-to-Dat-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5a\/Convert-Excel-to-Dat-Step-1.jpg\/v4-728px-Convert-Excel-to-Dat-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Du findest es im Windows-Startmenü in der Gruppe Microsoft Office unter Alle Apps .
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2c\/Convert-Excel-to-Dat-Step-2.jpg\/v4-460px-Convert-Excel-to-Dat-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2c\/Convert-Excel-to-Dat-Step-2.jpg\/v4-728px-Convert-Excel-to-Dat-Step-2.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/39\/Convert-Excel-to-Dat-Step-3.jpg\/v4-460px-Convert-Excel-to-Dat-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/39\/Convert-Excel-to-Dat-Step-3.jpg\/v4-728px-Convert-Excel-to-Dat-Step-3.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6e\/Convert-Excel-to-Dat-Step-4.jpg\/v4-460px-Convert-Excel-to-Dat-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Convert-Excel-to-Dat-Step-4.jpg\/v4-728px-Convert-Excel-to-Dat-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Sie wird in Excel geöffnet.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bf\/Convert-Excel-to-Dat-Step-5.jpg\/v4-460px-Convert-Excel-to-Dat-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bf\/Convert-Excel-to-Dat-Step-5.jpg\/v4-728px-Convert-Excel-to-Dat-Step-5.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c8\/Convert-Excel-to-Dat-Step-6.jpg\/v4-460px-Convert-Excel-to-Dat-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c8\/Convert-Excel-to-Dat-Step-6.jpg\/v4-728px-Convert-Excel-to-Dat-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/38\/Convert-Excel-to-Dat-Step-7.jpg\/v4-460px-Convert-Excel-to-Dat-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/38\/Convert-Excel-to-Dat-Step-7.jpg\/v4-728px-Convert-Excel-to-Dat-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3c\/Convert-Excel-to-Dat-Step-8.jpg\/v4-460px-Convert-Excel-to-Dat-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Convert-Excel-to-Dat-Step-8.jpg\/v4-728px-Convert-Excel-to-Dat-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Eine Liste mit Dateitypen wird eingeblendet.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1b\/Convert-Excel-to-Dat-Step-9.jpg\/v4-460px-Convert-Excel-to-Dat-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1b\/Convert-Excel-to-Dat-Step-9.jpg\/v4-728px-Convert-Excel-to-Dat-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Dies erstellt eine Datei, die du ins .DAT-Format umwandeln kannst.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Convert-Excel-to-Dat-Step-10.jpg\/v4-460px-Convert-Excel-to-Dat-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Convert-Excel-to-Dat-Step-10.jpg\/v4-728px-Convert-Excel-to-Dat-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Wenn du den aktuellen Namen übernehmen möchtest, kannst du dies überspringen.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bb\/Convert-Excel-to-Dat-Step-11.jpg\/v4-460px-Convert-Excel-to-Dat-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bb\/Convert-Excel-to-Dat-Step-11.jpg\/v4-728px-Convert-Excel-to-Dat-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Eine Bestätigung wird eingeblendet.
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7f\/Convert-Excel-to-Dat-Step-12.jpg\/v4-460px-Convert-Excel-to-Dat-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Convert-Excel-to-Dat-Step-12.jpg\/v4-728px-Convert-Excel-to-Dat-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Die .CSV-Datei wurde gespeichert und ist bereit zur Umwandlung.
    Werbeanzeige
Teil 2
Teil 2 von 2:

Die .CSV-Datei in .DAT umwandeln

PDF download PDF herunterladen
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a0\/Convert-Excel-to-Dat-Step-13.jpg\/v4-460px-Convert-Excel-to-Dat-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a0\/Convert-Excel-to-Dat-Step-13.jpg\/v4-728px-Convert-Excel-to-Dat-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Dies öffnet den Windows Explorer.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/01\/Convert-Excel-to-Dat-Step-14.jpg\/v4-460px-Convert-Excel-to-Dat-Step-14.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/01\/Convert-Excel-to-Dat-Step-14.jpg\/v4-728px-Convert-Excel-to-Dat-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klicke die Datei nicht an, wenn du den Ordner geöffnet hast.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4a\/Convert-Excel-to-Dat-Step-15.jpg\/v4-460px-Convert-Excel-to-Dat-Step-15.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Convert-Excel-to-Dat-Step-15.jpg\/v4-728px-Convert-Excel-to-Dat-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ee\/Convert-Excel-to-Dat-Step-16.jpg\/v4-460px-Convert-Excel-to-Dat-Step-16.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ee\/Convert-Excel-to-Dat-Step-16.jpg\/v4-728px-Convert-Excel-to-Dat-Step-16.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Eine Liste mit Apps wird eingeblendet.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-17.jpg\/v4-460px-Convert-Excel-to-Dat-Step-17.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-17.jpg\/v4-728px-Convert-Excel-to-Dat-Step-17.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Die Datei wird in Notepad geöffnet.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6b\/Convert-Excel-to-Dat-Step-18.jpg\/v4-460px-Convert-Excel-to-Dat-Step-18.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Convert-Excel-to-Dat-Step-18.jpg\/v4-728px-Convert-Excel-to-Dat-Step-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c6\/Convert-Excel-to-Dat-Step-19.jpg\/v4-460px-Convert-Excel-to-Dat-Step-19.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c6\/Convert-Excel-to-Dat-Step-19.jpg\/v4-728px-Convert-Excel-to-Dat-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/48\/Convert-Excel-to-Dat-Step-20.jpg\/v4-460px-Convert-Excel-to-Dat-Step-20.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Convert-Excel-to-Dat-Step-20.jpg\/v4-728px-Convert-Excel-to-Dat-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Eine Liste mit Dateitypen wird eingeblendet.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/af\/Convert-Excel-to-Dat-Step-21.jpg\/v4-460px-Convert-Excel-to-Dat-Step-21.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/Convert-Excel-to-Dat-Step-21.jpg\/v4-728px-Convert-Excel-to-Dat-Step-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    . Wenn du diese Option wählst, kannst du deine eigene Dateiendung angeben.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4c\/Convert-Excel-to-Dat-Step-22.jpg\/v4-460px-Convert-Excel-to-Dat-Step-22.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Convert-Excel-to-Dat-Step-22.jpg\/v4-728px-Convert-Excel-to-Dat-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Wenn im Feld "Dateiname" derzeit bspw. Buch1.txt steht, ändere den Namen auf Buch1.dat .
    • Es ist egal, ob .DAT groß- oder kleingeschrieben ist.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-23.jpg\/v4-460px-Convert-Excel-to-Dat-Step-23.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/08\/Convert-Excel-to-Dat-Step-23.jpg\/v4-728px-Convert-Excel-to-Dat-Step-23.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Die Originaldatei ist jetzt im .DAT-Format gespeichert.
    Werbeanzeige

Verwandte wikiHows

Eine Dropdown Liste in Excel erstellen
Versteckte Zeilen in Excel wieder anzeigen
In Excel Spalten einklappen
Ein Diagramm in Excel erstellen
In Excel Kleinbuchstaben in Großbuchstaben umwandeln
In MS Excel automatisch nummerieren
Zwei Excel Dateien vergleichen
In Excel führende oder anhängende Nullen entfernen
Einen Kalender in Microsoft Excel erstellen
In Excel den Standardfehler des Mittelwerts berechnen
In Excel Text verkürzen
In Excel die relative Standardabweichung berechnen
Solver in Microsoft Excel verwenden
In Excel aus einem Komma einen Punkt machen
Werbeanzeige

Über dieses wikiHow

In anderen Sprachen
Diese Seite wurde bisher 15.468 mal abgerufen.

War dieser Artikel hilfreich?

Werbeanzeige