Estimated reading time: 3 minutes

There are specific types of cells in XLSX documents that can be transformed into new cards or database records.

👉 Your document must not contain merged cells or columns, neither filters applied to cells or columns.

Formats that can be imported into field types

Assignee

Text with the user's username, email (lower case only), or ID.

If you'd like to add multiple values to a field, use a comma to separate them.

E.g. John Doe, mary-pipefy, 127765, [email protected].

Attachment

Not supported.

Vertical/Horizontal Checklist

Text with the option of the field. Each option must be separated by commas.

CPF

Eleven numbers following the pattern: 000.000.000-00.

CNPJ

Fourteen numbers following the pattern: 000.000.00/0000-00.

Date

The cell should be formatted as a date (DD/MM/YYYY or MM/DD/YYYY depending on the language in your Pipefy settings)

Date Time and Due Date

The cell should be formatted as a datetime.

Currency

The cell should be formatted as currency.

Label

Text with the label's name or ID. If you want to add more than one label, separate them using commas. Ex. "Bug, Story".

Email

Text in a valid email format ([email protected], lower case only).

Number

Numbers with no formatting.

Short/Long Text

Text with no format.

Vertical/Horizontal Radio

Text with the option of the field.

Phone number

When adding phone numbers, insert the country code (you don't need to put "+" in front of the number).

Statement

Not supported.

Dropdown Select

Text with the option of the field.

Time

The cell should be formatted as time with the format 00:00:00 PM.

ID

Not supported.

Connection Field

ID of the Card or Table record. The importer app supports one connected card/record per connection field.


Did this answer your question?