XML in Excel umwandeln

PDF download PDF herunterladen
unter Mitarbeit von Luigi Oppido

PDF download PDF herunterladen

In diesem wikiHow zeigen wir dir, wie du unter Windows oder macOS eine XML-Datei in eine Microsoft Excel Arbeitsmappe umwandelst.

Methode 1
Methode 1 von 2:

Windows

PDF download PDF herunterladen
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4d\/Convert-XML-to-Excel-Step-1.jpg\/v4-460px-Convert-XML-to-Excel-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4d\/Convert-XML-to-Excel-Step-1.jpg\/v4-728px-Convert-XML-to-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Du findest Excel in der Gruppe “Microsoft Office” im Bereich Alle Apps des Windows-Menüs.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/75\/Convert-XML-to-Excel-Step-2.jpg\/v4-460px-Convert-XML-to-Excel-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/75\/Convert-XML-to-Excel-Step-2.jpg\/v4-728px-Convert-XML-to-Excel-Step-2.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    • Wenn du Excel 2007 hast, klicke stattdessen auf den runden Button mit dem Microsoft Office Logo darin. [1]
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/af\/Convert-XML-to-Excel-Step-3.jpg\/v4-460px-Convert-XML-to-Excel-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/Convert-XML-to-Excel-Step-3.jpg\/v4-728px-Convert-XML-to-Excel-Step-3.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Dies öffnet den Datei-Browser.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/20\/Convert-XML-to-Excel-Step-4.jpg\/v4-460px-Convert-XML-to-Excel-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/20\/Convert-XML-to-Excel-Step-4.jpg\/v4-728px-Convert-XML-to-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Je nach Format der Datei musst du vielleicht weitere Schritte unternehmen, um sie zu öffnen:
    • Wenn du ein Dialogfenster namens "XML importieren" siehst, referenziert die Datei auf mindestens ein Arbeitsblatt im XSLT Stil. Wähle Datei öffnen, ohne Stylesheet anzuwenden , um das Standardformat zu wählen, oder Datei mit angewandtem Stylesheet öffnen , um die Daten entsprechend des Stylesheets zu formatieren.
    • Wenn du den Dialog XML öffnen siehst, dann wähle Als Arbeitsmappe (nur lesen) .
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/59\/Convert-XML-to-Excel-Step-5.jpg\/v4-460px-Convert-XML-to-Excel-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/59\/Convert-XML-to-Excel-Step-5.jpg\/v4-728px-Convert-XML-to-Excel-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\/b\/bd\/Convert-XML-to-Excel-Step-6.jpg\/v4-460px-Convert-XML-to-Excel-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Convert-XML-to-Excel-Step-6.jpg\/v4-728px-Convert-XML-to-Excel-Step-6.jpg","smallWidth":460,"smallHeight":348,"bigWidth":728,"bigHeight":551,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/da\/Convert-XML-to-Excel-Step-7.jpg\/v4-460px-Convert-XML-to-Excel-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/Convert-XML-to-Excel-Step-7.jpg\/v4-728px-Convert-XML-to-Excel-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\/a\/a8\/Convert-XML-to-Excel-Step-8.jpg\/v4-460px-Convert-XML-to-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Convert-XML-to-Excel-Step-8.jpg\/v4-728px-Convert-XML-to-Excel-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8e\/Convert-XML-to-Excel-Step-9.jpg\/v4-460px-Convert-XML-to-Excel-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8e\/Convert-XML-to-Excel-Step-9.jpg\/v4-728px-Convert-XML-to-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Die XML-Daten werden jetzt als Excel-Datei gespeichert.
    Werbeanzeige
Methode 2
Methode 2 von 2:

macOS

PDF download PDF herunterladen
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3c\/Update-Excel-Step-8.jpg\/v4-460px-Update-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Update-Excel-Step-8.jpg\/v4-728px-Update-Excel-Step-8.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Du findest es in Programme-Ordner.
    • Excel für macOS kann keine XML-Daten von einer anderen Quelle importieren, aber du kannst Dateien mit XML-Tabellen öffnen. [2]
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3b\/Be-Politically-Correct-Step-2-Version-2.jpg\/v4-460px-Be-Politically-Correct-Step-2-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3b\/Be-Politically-Correct-Step-2-Version-2.jpg\/v4-728px-Be-Politically-Correct-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    [3]
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ef\/Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg\/v4-460px-Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg\/v4-728px-Add-Grid-Lines-to-Your-Excel-Spreadsheet-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Dies öffnet ein Finder-Fenster.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c5\/Convert-CSV-to-XLS-Step-5.jpg\/v4-460px-Convert-CSV-to-XLS-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c5\/Convert-CSV-to-XLS-Step-5.jpg\/v4-728px-Convert-CSV-to-XLS-Step-5.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Suche dafür nach dem Ordner, in dem sie abgelegt ist, und klicke dann auf den Dateinamen.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/81\/Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg\/v4-460px-Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg\/v4-728px-Pick-a-Good-Gaming-Mouse-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":334,"bigWidth":728,"bigHeight":529,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Der Inhalt der XML-Datei wird angezeigt.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7e\/Use-a-Computer-Mouse-Step-4-Version-2.jpg\/v4-460px-Use-a-Computer-Mouse-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7e\/Use-a-Computer-Mouse-Step-4-Version-2.jpg\/v4-728px-Use-a-Computer-Mouse-Step-4-Version-2.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\/cf\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg\/v4-460px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cf\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg\/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-3.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a8\/Use-Excel-Step-34.jpg\/v4-460px-Use-Excel-Step-34.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/Use-Excel-Step-34.jpg\/v4-728px-Use-Excel-Step-34.jpg","smallWidth":460,"smallHeight":258,"bigWidth":728,"bigHeight":408,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/78\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg\/v4-460px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg\/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-5.jpg","smallWidth":460,"smallHeight":341,"bigWidth":728,"bigHeight":540,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2f\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg\/v4-460px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2f\/Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg\/v4-728px-Convert-Excel-to-CSV-on-PC-or-Mac-Step-7.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Die XML-Datei wird jetzt als CSV-Datei auf deinem Mac 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

Referenzen

  1. ↑ https://support.office.com/en-us/article/Import-XML-data-6eca3906-d6c9-4f0d-b911-c736da817fa4#_showdevelopertab
  2. ↑ https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/import-xml/805f11b3-fead-4217-80fb-244e52c389e7
  3. ↑ https://www.techwalla.com/articles/how-to-convert-xml-to-csv-on-a-mac

Über dieses wikiHow

In anderen Sprachen
Diese Seite wurde bisher 19.300 mal abgerufen.

War dieser Artikel hilfreich?

Werbeanzeige