Integrations

CSV Import

The CSV import feature allows you to migrate data from other systems. It can handle up to 200,000 records at a time.

You can import CSV (Comma Separated Value) files. If you have an Excel file, you can convert it to a CSV file at the following link.

Importing CSV

Importing CSV files in Blue is a straightforward process. Each column in your CSV file corresponds to a default or custom field in Blue.

To start, you must be the Project Administrator of the project where you want to import data. Click on the project settings icon (gear icon) and select "Import"

CSV Import 1

The Import Feature is available under Project Settings for Project Administrators

In the screenshot above, you can also see another option called "Download CSV Template". This is extremely useful if you have already created your custom fields in your Blue project because you can download a CSV file that includes columns for all of your custom fields! This is great when you want to ensure that you have the precise structure for your CSV before importing.

Next, simply drag and drop your CSV file into Blue:

CSV Import 2

Drag and drop to upload your data

Depending on your file size, this may take a few seconds for you to upload and for Blue to analyse. Once Blue has analysed the data, you will see a preview of the first ten rows of your data:

CSV Import 3

You can then map each column in your CSV to a field in Blue.

CSV Import 4

Feeling Stuck? Get help!

We understand that no matter how easy we make it, importing data can sometimes be tedious, especially if it's your first time. If you want our team to assist you in uploading your data and matching your fields, simply email us at [email protected]

CSV Import 5

Once the mapping is complete, click "Import" and your data will be imported. The typical import speed in Blue is 10,000 to 15,000 records per minute.

Supported Fields & Formats

FieldImport SupportExpected Format (Import)
Title✅Text
Description✅Text
Tags✅Text, Text
List✅Text
Start Date✅MM DD YYYY
Due Date✅MM DD YYYY
Single Line Text✅Text
URL✅Text
Currency✅Number
File❌N/A
Country❌N/A
Date✅MM DD YYYY
Formula❌N/A
Single Select✅Text
Multiple Line Text✅Text
Phone Number✅Text
Email✅Text
Multiple Select✅Text, Text
Location✅Latitude, Longitude
Star Rating✅Number
Checkbox❌N/A
Number✅Number
Percent✅Number
Unique ID❌N/A
Reference❌N/A
Lookup❌N/A
Time Duration❌N/A

Accepted Date Formats

Blue supports a wide variety of date formats for import. Here are all supported formats:

  • Unix Timestamps:
    1511648546 (seconds)
1620021848429 (milliseconds)
1620024872717915000 (nanoseconds)
  • RFC Standards:
    RFC 3339: 2021-05-01T01:17:02.604456Z
RFC 2822: Wed, 02 Jun 2021 06:31:39 GMT
  • Database Formats:
    PostgreSQL: 
2019-11-29 08:08-08
2019-11-29 08:08:05-08
2021-05-02 23:31:36.0741-07
  • Common Formats:
    Year-Month-Day: 
2021-04-30 21:14
2021-02-21
2021-Feb-21

Month/Day/Year:
3/31/2014 22:05
04/02/2014 03:00:51

Day-Month-Year:
12 Feb 2006, 19:17
03 February 2013
  • Time Zones:
    2014-04-26 13:13:43 +0800
2017-11-25 13:31 PST
2021-02-21 UTC
  • Natural Language:
    May 6 at 9:24 PM
September 17, 2012 at 10:09am PST
October 7, 1970
  • International Formats:
    Chinese: 2014年04月08日
Japanese: 2014/04/08 22:05
  • Time Only:
    01:06:06
4:00pm PST
6:00 AM UTC

All dates will be converted to UTC timezone during import. Time components are optional - if not provided, time will default to 00:00:00 UTC.

Zapier

You can send data to Zapier via Blue Webhooks.

CSV Export

Download data from Blue into a CSV file for storage and analysis outside Blue.