How to Prepare My CSV File for Importing Clients Into SOUS

How to Prepare My CSV File for Importing Clients Into SOUS

Learn best practices for importing clients from a CSV file into your SOUS account— These tips should help you avoid import errors, partial imports, and frustration.

Remove any unnecessary information

Our importer will run through every column and every row of your file during the import process, even if you only plan to map some of the items to fields in your account.

Before removing any information from your master file, create a copy of it first then work from the copy.

Columns

Only include columns you wish to map to fields during the import process and delete any columns you don't need

Rows

Remove all empty rows and rows that do not contain an email address (contacts who do not have a unique email address in the file will be skipped by the importer)

Use proper field formatting

Depending on how certain fields are formatted, you may receive an incorrect format error or an unexpected result during the import process. This is especially common for contacts who have missing or incorrectly formatted email addresses. To avoid this:

  • Email address fields
    Make sure all email addresses in your file are spelled correctly and are properly formatted.
  • Required fields
    When importing, you can apply the default value for all empty required fields (i.e. First Name, Email). If you do not apply the default value or provide a value in the CSV file, the Import File button will be unavailable in Step 4.

You can also use the sample CSV file attached to this article to set you on the right path for formatting your import fields.


    • Related Articles

    • How to Import Contacts Into SOUS From a CSV File

      If you were maintaining client information before subscribing to SOUS, you can import them all using a CSV file. Before you begin The import tool only works with CSV files Each contact in your file must have a first name and email address Learn how ...
    • How Do I Save My Spreadsheet as a CSV File?

      The instructions below use Excel, however most spreadsheet programs (like Google Sheets, for example) will follow a similar process. Open your spreadsheet and click “File” and then “Save As.” Select “CSV (Comma delimited) (*.csv)” from the Save as ...
    • SOUS User Guide

      Welcome to SOUS, your go-to software for your personal chef business. This guide will walk you through the process of setting up and using SOUS to organize your contacts & events efficiently. Getting Started Before you begin, make sure you have an ...
    • Who owns the data / information / clients?

      You do! Any clients or event information is 100% owned by you. SOUS & Chefpreneur doesn't have permission to use that information or contact your clients for any reason. SOUS is just a tool for YOU to deliver YOUR services!
    • SOUS payments versus Card limits

      Many cards have daily or transaction limits that can prevent clients from making payments over a certain amount. This can be frustrating, especially when it comes to a significant purchase or payment. Fortunately with SOUS, we have ACH (Automated ...