Want to bulk update customer and supplier information in your company file? If you wanting to make bulk changes to your customer or supplier details (for example, to change the default form assigned or add custom information), see Bulk update customer and supplier cards

1. Open your company file.
2. Go to the File menu and choose Import/Export Assistant. The Import and Export Assistant appears.
3. Select Export data then click Next.
4. In the Export field, select Cards from the drop-down list.
5. Select the type of cards you want to export and click Next. The Format step appears. 
6. Leave the default format options and click Next. The Select Fields step appears. The fields in the left panel are the fields you can export.
   

7. Select the fields you want to export. Learn more about the characteristics of all import and export fields.
   You can export all fields (click Add All) or just those you want to change (select a field in the left panel and click Add). The selected field are added to the list of fields to be exported in the panel on the right. You need to select at least one required import field (indicated with a caret ^).

   UI Text Box
   size medium type note
   Required fields If you want to import this data back into your company file, you'll need to export at least one field type that has a caret ^ indicator. We recommend using the Co./Last Name field as it's easy to identify who the card belongs to.

8. Click Export. The Save As window appear.

9. Specify where you want to save the file. To keep it simple, save the file to your desktop and leave the default file name (such as CUST.TXT).
10. Click Save.

Update your data in a spreadsheet

You can update your data in a spreadsheet or other software that can open a text file (such as Windows Notepad). The instructions below explain how to open the file in Microsoft Excel. If you need more information about how to open or update information in your editing software, see the help for that product.

1. Open Microsoft Excel and go to File > Open.
2. In the Files of type field, select All Files (*.*) and locate and open the exported text file. The Text Import Wizard appears. 
3. Step through the wizard and review the options. As your card file doesn't include any formulas or dates, you shouldn't need to make any changes.
4. Click Finish. The data will be displayed and you can now edit the cells as required.
   There's so much you can do in Excel, that we really can't guide you here. If you get stuck, see the Excel help.
5. When you finish editing, click Yes to the message to save it as a text file. You can only import text files into AccountRight.