{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Meta","Please Turn on Macros"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":17,"n_cols":29,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,24,2,25],[1,26,1,27],[1,28,1,29],[1,1,1,2],[1,3,1,4],[1,18,1,19],[1,24,1,25],[2,26,2,27],[2,28,2,29],[5,17,5,21],[3,1,3,4],[1,20,1,21],[1,22,1,23],[2,18,2,19],[2,20,2,21],[2,22,2,23],[1,6,1,7]]}
[]
[null,"1. Copy \nyour data into the \ncolumns below, \nstarting in row 8",null,"2. Fix\nall errors in \nthe yellow cells",null,null,"3. Add\nto QuickBooks\nand review",null,null,null,null,null,null,null,null,null,null,"Hidden Link","1. Copy \nyour data into the \ncolumns below, \nstarting in row 8",null,"2. Fix\nall errors in \nthe yellow cells",null,"3. Add\nto QuickBooks\nand review",null,"1. Copy\nyour data into the \ncolumns below, \nstarting in row 8\n\n\n•  Use the coach tips for specific instructions.\n•  You can’t rename, add, resize, or move columns.\n•  Copy one column at a time.\n•  Your column titles may not match ours exactly.\n•  You might have data for which there is no column in this spreadsheet . Add it manually later.",null,"2. Fix \nall errors in \nthe yellow cells\n\n\n•  Scroll over the red triangles  to see the error.",null,"3. Add\nto QuickBooks \nand review\n\n\n\n•  You can’t return to QuickBooks until you close the formatted spreadsheet.\n•  Remember the location where you save it.\n•  Make a note of file name, e.g. Import_Customers1.xls."]
[null,"Messages:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Important:\nrecords with errors were not added.",null,"1. Fix\nremaining errors in \nthe yellow cells",null,"2. Add \nto QuickBooks\nand review",null,"Important:\nrecords with errors were not added\n\n\n\n•  This error file only includes records that were not added to QuickBooks due to errors.\n•  The rest of your records were already added to QuickBooks.\n•  Follow Steps 1 and 2 to fix the errors.\n•  Then add these remaining records to QuickBooks.",null,"1. Fix\nremaining errors in \nthe yellow cells",null,"2. Add\nto QuickBooks \nand review\n\n\n\n•  Remember the location where you saved it.\n•  Make a note of file name, e.g. Import_Customers1-errors.xls."]
[]
[null,"Example Data:"]
[null,"Acme, Inc.","Ms.","Kristy","P.","Abercrombie","Kristy P. Abercrombie","5647 Cypress Hill Rd.",null,"Bayshore","CA","94326","415-555-6579",null,"415-555-9602","aaber@samplename.com","4-1382-72","Do Not enter data in these columns."]
["!","Company Name","Mr./Ms.","First Name","M.I.","Last Name","Display As *","Street 1","Street 2","City","State","Zip","Phone","Fax","Alternate Phone","E-mail","Account Number","Address Line 1","Address Line 2","Address Line 3","Address Line 4","Address Line 5"]
["","Company 1","Mr.","First 1","M 1","Last 1","Company 1","St 1",null,"City 1","CA",90001,"111-111-1111","Fax 1",null,"Email 1",10001,"First 1 M 1 Last 1","Company 1","St 1","","City 1, CA 90001"]
["","Company 2","Mr.","First 2","M 2","Last 2","Company 2","St 2",null,"City 2","CA",90002,"111-111-1112","Fax 2",null,"Email 2",10002,"First 2 M 2 Last 2","Company 2","St 2","","City 2, CA 90002"]
["","Company 3","Mr.","First 3","M 3","Last 3","Company 3","St 3",null,"City 3","AZ",90003,"111-111-1113","Fax 3",null,"Email 3",10003,"First 3 M 3 Last 3","Company 3","St 3","","City 3, AZ 90003"]
["","Company 4","Mr.","First 4","M 4","Last 4","Company 4","St 4",null,"City 4","AZ",90004,"111-111-1114","Fax 4",null,"Email 4",10004,"First 4 M 4 Last 4","Company 4","St 4","","City 4, AZ 90004"]
["","Company 5","Mr.","First 5","M 5","Last 5","Company 5","St 5",null,"City 5","MO",90005,"111-111-1115","Fax 5",null,"Email 5",10005,"First 5 M 5 Last 5","Company 5","St 5","","City 5, MO 90005"]
["","Company 6","Mr.","First 6","M 6","Last 6","Company 6","St 6",null,"City 6","TX",90006,"111-111-1116","Fax 6",null,"Email 6",10006,"First 6 M 6 Last 6","Company 6","St 6","","City 6, TX 90006"]
["","Company 7","Mr.","First 7","M 7","Last 7","Company 7","St 7",null,"City 7","TX",90007,"111-111-1117","Fax 7",null,"Email 7",10007,"First 7 M 7 Last 7","Company 7","St 7","","City 7, TX 90007"]
["","Company 8","Mr.","First 8","M 8","Last 8","Company 8","St 8",null,"City 8","SC",90008,"111-111-1118","Fax 8",null,"Email 8",10008,"First 8 M 8 Last 8","Company 8","St 8","","City 8, SC 90008"]
["","Company 9","Mr.","First 9","M 9","Last 9","Company 9","St 9",null,"City 9","NY",90009,"111-111-1119","Fax 9",null,"Email 9",10009,"First 9 M 9 Last 9","Company 9","St 9","","City 9, NY 90009"]
["","Company 10","Mr.","First 10","M 10","Last 10","Company 10","St 10",null,"City 10","NY",90010,"111-111-1120","Fax 10",null,"Email 10",10010,"First 10 M 10 Last 10","Company 10","St 10","","City 10, NY 90010"]

{"sheet":"Meta","index":1,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Balloon Shape Names for each column"]
["AutoShape 46091","AutoShape 46072","AutoShape 46073","AutoShape 46074","AutoShape 46075","AutoShape 46076","AutoShape 46077","AutoShape 46078","AutoShape 46079","AutoShape 46080","AutoShape 46081","AutoShape 46082","AutoShape 46083","AutoShape 46084","AutoShape 46085","AutoShape 46086","AutoShape 46087"]

{"sheet":"Please Turn on Macros","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["You must enable macros to use this template. To enable macros, make sure your macro security settings are set properly, change them if necessary, and then close and re-open this workbook."]
["Excel 2000, 2002, and 2003 users\n  Step 1. Confirm security level\n    1. Go to the Excel Tools menu, click Macro, then click Security. \n    2. If the security level is set to:\n       • Very High: Click any option except Very High, then Click OK to save the new settings.\n       • High, Medium, or Low: Leave the option selected as is, then click OK to close the window. \n    3. Close this workbook.\n\n  Step 2. Enable macros\n    1. Re-open this workbook. \n    2. If you selected any setting except Low, you’ll be prompted to enable macros.  \n    3. Click Enable Macros.\n    4. Depending on your Excel version and security settings, click Always trust macros from this publisher \n        to trust the macros in this workbook in the future."]
["Excel 2007 users\n  If you see a security alert like the one pictured here,"]
[]
["    1. Click the Enable Content button and then click one of the following:\n       • Enable this content\n       • Trust all documents from this publisher"]
["  If you don't see an alert, \n    1. From the Developer tab on the Ribbon, click Macro Security in the Code group.\n    2. Click one of the following options:\n       • Enable all macros \n       • Disable all macros except digitally signed macros\n       • Disable all macros with notification\n    3. Click the OK to save the settings.\n    4. Close this workbook.\n\n  The next time you open this workbook, a security alert like the one above will appear."]