This tutorial shows importing a CSV file into Google Sheets on Debian Linux 8.0, but the steps should be fairly similar on any operating system into any spreadsheet
order-id,order-item-id,asin,order-status,purchase-date,last-update-date,payments-date,buyer-email,buyer-name,buyer-phone-number,seller-sku,product-name,quantity-purchased,quantity-shipped,item-price,item-price-currency,item-tax,item-tax-currency,shipping-price,shipping-price-currency,shipping-tax,shipping-tax-currency,ship-service-level,ship-name,ship-address-1,ship-address-2,ship-address-3,ship-city,ship-state,ship-postal-code,ship-country,ship-phone-number,is-prime 111-4362111-7839111,11189801004111,B00I7V9AAA,Shipped,2015-09-01T14:11:25Z,2015-09-04T05:00:15Z,,firstname.lastname@example.org,Denta Pen,01635 550999,TAB10KGVAR,WATER SOFTENER SALT TABLETS 10KG 2 packs large saving,1,1,15.00,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Team,"C/o Pen Den","The Pen, Street",,NEWBURY,Berks,RG,GB,01111 550999,false 111-5111111-9405111,11148644444111,B00J5PHAAA,Shipped,2015-09-01T23:04:05Z,2015-09-04T05:03:31Z,,email@example.com,H BROWN,02081237999,HYD25TABx2,2 X 25KG Hydrosoft Tablets,1,1,26.44,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Tyler,Road,,,Richmond,Surrey,TWEH,GB,02111237111,false 111-1612111-5829111,11182146780111,B008JY9AAA,Shipped,2015-09-02T06:59:14Z,2015-09-04T05:16:47Z,,firstname.lastname@example.org,Giles,07799400999,HYD25TAB,"Hydrosoft Salt Tablets, 25 Kg",1,1,14.38,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,P,Oakridge,Street,,upper basildon,,R8NT,GB,07111400111,false 111-9025111-4252111,11161995009111,B008JY9AAA,Shipped,2015-09-02T08:21:08Z,2015-09-04T05:16:47Z,,email@example.com,Annette,07958647999,HYD25TAB,"Hydrosoft Salt Tablets, 25 Kg",1,1,14.38,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Annette,House,"Halstead Road, Aldham",,COLCHESTER,Essex,COP,GB,07111647111,false 111-2483111-7225111,11183372110111,B008JY9AAA,Shipped,2015-09-02T08:33:10Z,2015-09-04T05:16:46Z,,firstname.lastname@example.org,Mark,07977257999,HYD25TAB,"Hydrosoft Salt Tablets, 25 Kg",2,2,28.76,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Mark,Road,,,LONDON,,SE,GB,07111257111,false 111-6443111-9948111,11100074384111,B00K243AAA,Shipped,2015-09-02T08:54:48Z,2015-09-04T05:16:47Z,,email@example.com,Mrs Mary,07981691999,BLK8HARVx6,"Harvey's Salt Blocks - 6 Pack, 12 Blocks",1,1,34.30,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Brian,Tootswood,,,BROMLEY,Kent,BR2,GB,07111691111,false
Open your spreadsheet application and select File > Import ...
Select to upload a file.
Browse to and select the file on your computer.
Choose to create a new spreadsheet and designate comma as the field delimiter.
Once the file is uploaded/processed, open it
Enable auto-filtering to begin searching, sorting, filtering your order history!
+1 (706) 622-8846
© 2015-2019 The Moore Collective, LLC