Manual data imports just got a lot less manual. Our AI-assisted bulk import tool automatically matches labels and detects errors. This must-try time saver is an essential tool if you have dozens, hundreds or perhaps thousands of records to import into a new or existing tinyEmail audience.
Uploading records to a new audience
This step shows you how to bulk upload records to a new audience with a CSV file.
Go to the tinyEmail dashboard and click Audience on the side menu. Click the Add new button and select Upload file.
In the popup window:
Enter a unique name for the new audience.
Check the box to confirm that you have permission to send email messages to these contacts.
Download the sample CSV file from the Upload new audience popup window. You could use Excel to open the CSV file (and convert the data to save the column structure), but honestly, it's a whole lot easier to use Google Sheets.
Open Google Sheets and use the Import feature to load the CSV file from your device.
Add records to the sheet. Each row is one record. Be sure to enter a value for each required field. (see below)
Rename the file. (optional)
Download the file to your device as a CSV (File > Download > CSV).
Here are the required fields. Each field must have a value.
Country, City, Address 1, Address 2
Uploading the file
On the Bulk Add Customers page, click the Upload data from file button. Locate the CSV file on your device and import the document. tinyEmail uploads the records. Now, you're ready to map fields.
The next page displays a table for each column in the CSV file. Each table has a data label (e.g. Email) and three sample records (e.g. email addresses). Your job is to confirm the content in the table (e.g. email addresses) matches the column label (e.g. Email).
If the content matches the label, click the Confirm mapping button.
If the content does not match the label, click the label field and select the correct label on the drop-down menu.
Repeat the steps for each table (e.g. First Name, Last Name, etc.). When the mapping work is complete, click the Review button at the bottom of the page.
The next page shows your records and errors, if any. The AI looks for duplicates, incorrect data formats, and inconsistent information and highlights the cells. Hover the mouse on a highlighted cell to see the error.
To filter the table, check the box to show rows with errors.
Some errors (like a badly formed email address or missing address) can be fixed directly on this page. Double-click a cell and change the value (or add a missing value).
Some errors cannot (like a duplicate record) be fixed on this page. In those cases, click the X in the corner to close the window, go back to the CSV file, and fix the errors. Upload the file again and restart the import process.
When the records are error-free, the AI displays the All rows pass validation! message. Click the Upload button.
Confirming the upload
To see the upload results, click the Audience link on the side menu. Scroll down the page and locate the new audience. tinyEmail adds a Manual tag to the audience row.
Click the audience name to see a list of subscribers and engagement data once you start using the audience.
Uploading records to an existing audience
You can use the bulk import tool to import new subscribers to an existing manual audience. This is a useful feature if you don't want to create a new audience. Another use case is when you create a new audience, but the CSV file has some errors. You decide to import the records without errors (using the Upload Rows Without Errors button) and come back later to finish the import after updating the CSV file.
To upload to an existing manual audience:
Open the Audience page.
Locate an audience and click the three-dot icon.
Select Add Subscribers.
Your bulk import work is complete!