using System;

using System.Collections.Generic;

using System.Linq;

using System.Xml;

using System.Xml.Linq;

using System.Net;

​

public class Program

{

    public static void Main(string[] args)

    {

        var doc = XDocument.Parse(Xml);        

​

        var addresses = Addresses(doc);

​

        WriteToExcel(addresses);

    }

​

    private static IEnumerable<Address> Addresses(XContainer doc)

    {

        XNamespace ns = "https://mws.amazonservices.com/Orders/2013-09-01";

​

        return from address in doc.Descendants(ns + "ShippingAddress")

               select new Address

               {

                   Name = (string) address.Element(ns + "Name"),

                   AddressLine1 = WebUtility.HtmlDecode((string) address.Element(ns + "AddressLine1")),

                   AddressLine2 = (string) address.Element(ns + "AddressLine2"),

                   City = (string) address.Element(ns + "City"),

                   StateOrRegion = (string) address.Element(ns + "StateOrRegion"),

               };

    }

​

    private static void WriteToExcel(IEnumerable<Address> addresses)

    {

        // open and write to Excel here, you can loop through the addresses:

​

        foreach (var address in addresses)

        {

            Console.WriteLine(address.Name.ToUpper());

            Console.WriteLine(address.AddressLine1);

            Console.WriteLine(address.AddressLine2);

            Console.WriteLine(address.City);

            Console.WriteLine(address.StateOrRegion);

            Console.WriteLine("---");

        }

    }

​

    const string Xml = @"<ListOrdersResponse xmlns=""https://mws.amazonservices.com/Orders/2013-09-01"">

<ListOrdersResult>

    <NextToken>M1JyahCtnbyaJqJYLDm0ZIfVkJJPpovR78ndw9jqj1Q/69u0e9w5/rQzazHyYVyLqBXdLk4iogxpJASl2BeRe8j0Nx3CIFZQQMZu4ky1kPOeXaRUvtI0tSJ0wMvlylZkWQWPqGlbsnPaEpJjLWtrc+QJ10Z22+qvY/7NeGX36M2lPNv+vCtnKbuZIF9n45mtnrZ4AbBdBTfK25ICwjklgZC1Ikmk90PCwrOwRyEF9TC5HmwX5IAmwKfxnqm3JqvZfwylPI5qZH51NMrpM18PB5GesRwkZOQCT2ijH+OaBgLthhfBGj6DwqJZsZEQ+rF525news0zC1z2PvV1ggto2Jcae56fKGloAreSIoDY6+Vu4dey78hEtutyjMqWzuEhtk8n/YPwqr6cgigTv6iG1zzBuIzaoIZ5Q2QZkesSbBJRVhUbQn8uebbKT14gSEgJXREjaOhXHEOu88CBt+gncOCR1k9eFxFwh3b1o15VFoq4DX+xmmNRmA==</NextToken>

    <CreatedBefore>06/27/2015 00:00:00</CreatedBefore>

    <Orders>

        <Order>

            <AmazonOrderId>102-0657116-1777031</AmazonOrderId>

            <PurchaseDate>06/25/2015 19:48:25</PurchaseDate>

            <LastUpdateDate>06/25/2015 20:18:42</LastUpdateDate>

            <OrderStatus>Unshipped</OrderStatus>

            <FulfillmentChannel>MFN</FulfillmentChannel>

            <SalesChannel>Amazon.com</SalesChannel>

            <ShipServiceLevel>Std Cont US Street Addr</ShipServiceLevel>

            <ShippingAddress>

                <Name>dan hendricks</Name>

                <AddressLine1>THE BOTIQUE TAPES</AddressLine1>

                <AddressLine2>330 MAIN ST</AddressLine2>

                <City>LUBBOCK</City>

                <StateOrRegion>TX</StateOrRegion>

                <PostalCode>07345-1742</PostalCode>

                <CountryCode>US</CountryCode>

                <Phone>2738953644</Phone>

            </ShippingAddress>

            <OrderTotal>

                <CurrencyCode>USD</CurrencyCode>

                <Amount>52.00</Amount>

            </OrderTotal>

            <NumberOfItemsShipped>0</NumberOfItemsShipped>

            <NumberOfItemsUnshipped>1</NumberOfItemsUnshipped>

            <PaymentExecutionDetail />

            <PaymentMethod>Other</PaymentMethod>

            <MarketplaceId>ATVPDKIKX0DER</MarketplaceId>

            <BuyerEmail>ted101@marketplace.amazon.com</BuyerEmail>

            <BuyerName>dan hendricks</BuyerName>

            <ShipmentServiceLevelCategory>Standard</ShipmentServiceLevelCategory>

            <ShippedByAmazonTFM>False</ShippedByAmazonTFM>

            <OrderType>StandardOrder</OrderType>

            <EarliestShipDate>06/26/2015 02:00:00</EarliestShipDate>

            <LatestShipDate>06/30/2015 01:59:59</LatestShipDate>

            <EarliestDeliveryDate>07/01/2015 02:00:00</EarliestDeliveryDate>

            <LatestDeliveryDate>07/08/2015 01:59:59</LatestDeliveryDate>

            <IsBusinessOrder>False</IsBusinessOrder>

            <IsPrime>False</IsPrime>

            <IsPremiumOrder>False</IsPremiumOrder>

        </Order>

        <Order>

            <AmazonOrderId>103-6846365-0842605</AmazonOrderId>

            <PurchaseDate>06/26/2015 11:06:16</PurchaseDate>

            <LastUpdateDate>06/26/2015 11:36:33</LastUpdateDate>

            <OrderStatus>Unshipped</OrderStatus>

            <FulfillmentChannel>MFN</FulfillmentChannel>

            <SalesChannel>Amazon.com</SalesChannel>

            <ShipServiceLevel>Std Cont US Street Addr</ShipServiceLevel>

            <ShippingAddress>

                <Name>bob dylan</Name>

                <AddressLine1>130 CHERRY LANE</AddressLine1>

                <City>MIAMI</City>

                <StateOrRegion>FLORIDA</StateOrRegion>

                <PostalCode>83420-9595</PostalCode>

                <CountryCode>US</CountryCode>

                <Phone>3076595976</Phone>

            </ShippingAddress>

            <OrderTotal>

                <CurrencyCode>USD</CurrencyCode>

                <Amount>43.00</Amount>

            </OrderTotal>

            <NumberOfItemsShipped>0</NumberOfItemsShipped>

            <NumberOfItemsUnshipped>1</NumberOfItemsUnshipped>

            <PaymentExecutionDetail />

            <PaymentMethod>Other</PaymentMethod>

            <MarketplaceId>ATVPDKIKX0DER</MarketplaceId>

            <BuyerEmail>jfkdkl@marketplace.amazon.com</BuyerEmail>

            <BuyerName>Matt dylan</BuyerName>

            <ShipmentServiceLevelCategory>Standard</ShipmentServiceLevelCategory>

            <ShippedByAmazonTFM>False</ShippedByAmazonTFM>

            <OrderType>StandardOrder</OrderType>

            <EarliestShipDate>06/29/2015 02:00:00</EarliestShipDate>

            <LatestShipDate>07/01/2015 01:59:59</LatestShipDate>

            <EarliestDeliveryDate>07/02/2015 02:00:00</EarliestDeliveryDate>

            <LatestDeliveryDate>07/09/2015 01:59:59</LatestDeliveryDate>

            <IsBusinessOrder>False</IsBusinessOrder>

            <IsPrime>False</IsPrime>

            <IsPremiumOrder>False</IsPremiumOrder>

        </Order>

        <Order>

            <AmazonOrderId>109-5667692-9305063</AmazonOrderId>

            <PurchaseDate>06/26/2015 15:33:15</PurchaseDate>

            <LastUpdateDate>06/26/2015 16:03:34</LastUpdateDate>

            <OrderStatus>Unshipped</OrderStatus>

            <FulfillmentChannel>MFN</FulfillmentChannel>

            <SalesChannel>Amazon.com</SalesChannel>

            <ShipServiceLevel>Std Cont US Street Addr</ShipServiceLevel>

            <ShippingAddress>

                <Name>susie orman</Name>

                <AddressLine1>2452 POEF CREEK RD</AddressLine1>

                <City>NEW YORK</City>

                <StateOrRegion>NY</StateOrRegion>

                <PostalCode>28538-8554</PostalCode>

                <CountryCode>US</CountryCode>

                <Phone>8782827332</Phone>

            </ShippingAddress>

            <OrderTotal>

                <CurrencyCode>USD</CurrencyCode>

                <Amount>135.00</Amount>

            </OrderTotal>

            <NumberOfItemsShipped>0</NumberOfItemsShipped>

            <NumberOfItemsUnshipped>1</NumberOfItemsUnshipped>

            <PaymentExecutionDetail />

            <PaymentMethod>Other</PaymentMethod>

            <MarketplaceId>ATVPDKIKX0DER</MarketplaceId>

            <BuyerEmail>sdafgeg@marketplace.amazon.com</BuyerEmail>

            <BuyerName>Susie orman</BuyerName>

            <ShipmentServiceLevelCategory>Standard</ShipmentServiceLevelCategory>

            <ShippedByAmazonTFM>False</ShippedByAmazonTFM>

            <OrderType>StandardOrder</OrderType>

            <EarliestShipDate>06/29/2015 02:00:00</EarliestShipDate>

            <LatestShipDate>07/01/2015 01:59:59</LatestShipDate>

            <EarliestDeliveryDate>07/02/2015 02:00:00</EarliestDeliveryDate>

            <LatestDeliveryDate>07/09/2015 01:59:59</LatestDeliveryDate>

            <IsBusinessOrder>False</IsBusinessOrder>

            <IsPrime>False</IsPrime>

            <IsPremiumOrder>False</IsPremiumOrder>

        </Order>

    </Orders>

</ListOrdersResult>

<ResponseMetadata>

    <RequestId>519992f0-701c-4211-9f3d-3c73b520c626</RequestId>

</ResponseMetadata></ListOrdersResponse>";

​

}

​

public class Address

{

    public string Name { get; set; }

    public string AddressLine1 { get; set; }

    public string AddressLine2 { get; set; }

    public string City { get; set; }

    public string StateOrRegion { get; set; }

}

​