📋 How to import leads to Pipefy from a spreadsheet

📋 How to import leads to Pipefy from a spreadsheet
Userlevel 3

Spreadsheets may be common, but they aren’t the ideal tool to keep track of business opportunities since they can quickly become outdated and are difficult to control.

 

To mitigate these issues, you can import all your leads into a pipe or a database inside Pipefy where they can be effortlessly found, updated, and managed through your sales process.

 

Here is a quick guide:

  • Click on Tools → Apps, and select Importer app. Click on enable to activate it. It will appear in your pipe's header.

 

1wW_t_CXPsq8uWd1BAsNe6fqYAv_zODdgKtvLPcvWTi7wbZ0-AIdJXSDGaTKZpr0UIEKoeMseyFYUquHQoKKcOGU6gPBB7RU1Ls6YGfsoU73JreDnMOiemlUS2rNBezcxK7eBr2tb_OEdExo6g

 

  • Click on the Importer app icon to open it up. Then, choose if you want to import your spreadsheet to a pipe or a database.
     

  • In New Import, drag and drop or select your spreadsheet from your file folder (it must be an .xlsx file). The next step is to combine its columns with the pipe's or database's fields and start importing.

 

Need a detailed tutorial? Get more information below.

 

 

Prepare your spreadsheet

 

The first step is to make sure your spreadsheet has the same information as your pipe/database.

 

Then, go to your pipe/database and open its form. Check its fields and if there are any set as mandatory. If there is, your spreadsheet must contain a column with the same information, with all its lines filled, otherwise the importing won't work.

 

Here is an example:

 

In this Sales CRM process, the start form has 3 fields:

  • Company name (mandatory)

  • Contact name

  • Preferred contact method (mandatory)

 

 

PvrrVl2mFncff0TMWjV5CbHQOAmMv9kdxVdoqW29cxyv5Mf0Vi9iVccJ4BMx0XPE1Aq5CGZI9VR2RSpD-Nj2cJbKcQefFF6O8LJ3KKlTop7kI03sfLCgdtabn8KS50NdV1AKqE_1qKBRB2EgiA

 

 

This means the spreadsheet will have to look like this:

 

 

xf47PaMIRe1ksCuIiSKUABUg2PwEyu5iIaMFo4nJfhCe6mmcrXUZPRuXsr2ex8jZ8lZcKFox9ptfM3evSiVKFrBC28OclG2yu7_MoYtWfPRIE3F7FAxlryDt0y7rO1WPipmNhLte6JIUEkojfw

 


 

📌 If your spreadsheet has different data fields, you can edit your start form to match fields to columns. Just keep in mind this action won't affect previous cards/records.

 

It's also important to set up your spreadsheet cells for the Importer app. It can't contain any blank fields between columns, any filters applied, or any merged cells.

 

Also, remember to check the field type in Pipefy. For example, if the form has a numeric or currency field, the corresponding information in the spreadsheet cannot contain letters.

 

Pay close attention to phone numbers, zip codes, and ID numbers so that there isn't any incorrect information in them. Email addresses must also be in email format.

 

To import due dates, assignees, or labels, ensure your pipe has those fields first.

 

 


 

 

 

Enable the Importer app

 

When you're ready to go, click on Tools, in the pipe's header, and select the option Apps.

 

 

 

QHoAZk0rS-AeDayFMlKxk_XvKp8qTxf4vqtUY3D_1mViQ-8ZFCgSIcNcKBJNzJe3Hua_t65Zc-a4D1MZXbefJdS3Pv6pI0kCZm2wpaPD-5ncrrFr7DAmHqNJoQOk1-6j_7wgfYBiKzDvy0qGCA

 

 

Search for the Importer app, and click on it.

 

 

Rn5TOs2K7bDCfDEg3YJlN5fN_iSWegBxVAau2_JFJIGs5ZomcHgUpjpVe6S_GOhOwppkjdNOJSwCZHCiuTHqoY8A8IJtd3SvhkzPTTbR7rUidRxn6eaUQT1EbDaNAjIW_Ndn4_Wl7IVjuM3cNg

 

 

Click on enable to activate it.

 

kBWMBEAhlXM7jVPMvbKkOZen7w8VL74uE83hU1J25U8J6Q_Q4dKcVNNwSpjFycN9GLx52lSOAXI2m4Hq4vfSH3pTQkzKYWDAbVwzkXsp8ite60TISHv67hYSSQ4jhVnICZ3exszTg3sXTT2b6A

 

 

Now you'll find an Importer app icon in your pipe's header.

 

 

qTtcdJtTflVqsOyGy-xcIf2EOYkGsqxfFhGQRFdqKoMR8r7uUUQMrebSpj9kP1-DRKC9bc6p4dKeiffNUDJVFw_PEO10Q8IpKOUFDx1gqhLHyUSEm52pXiA15VclIqO6F9x2VvwiivM4x-IKPw

 

 

 

Importing leads to Pipefy

Click on the Importer app icon to open it up, then choose where you want to import your leads: to a pipe or database.

If it's to a database, make sure you've created one before, and connect it with your pipe.

 

 

nnu7MESVC6-nM3kgv39WYa663witonO4OqbIVhSc5TAAaXp1KmASn7aStuzBCfouqZUA21E0zax8tZLl25zK_Et8ktAu7N3pIZXfOWiA9ZITRIclQMPPS7C_TTZ4qs1naMjkex6u6_aIb2z3tQ

 

Then, go to New Import, where you'll drag and drop your spreadsheet or upload it from your computer.

 

📌 Remember: it must be a .xlsx file.

 

TIFaanXlPoz2Mv9J6DaDxfGkEeWD-Px_pf7MaOmcyWYG9sb8MdsVIKRiyhTTYtYE-D65-M4exjKhhwdw3Wsd46Cdw5JqpLFHV246b7n1OlQOcgQvDQJEF9uku1JeRj17A50BzBEFwHZ-M9u0QA

 

 

Let's match the spreadsheet columns to the pipe's or database's form fields. Select one of the options, or skip if there isn't any match.

 

EFKIk2uKuMBoC9Bo76ep2v67vbqSRK7XTcQX4XUY-tgfYy_KWYPwrYpgb5SyMtjU_X_JEj7Nw9tafagzv7BuP_gtP9v1VKtfVki87hjw9WMenJoLMTlomZnFL55yKijtpp0mNbwGQpf36OvoIw

 

 

Click on Import cards/records to start transferring data from your spreadsheet to Pipefy.

 

You'll receive an email when it's complete and ready to use, or if there were any errors.

 

 

Take free courses in Pipefy's Academy to improve your process management skills, and don't forget to join our Community where you have access to our knowledge base.

 

 

Related articles:


2 replies

Userlevel 7
Badge +13

Hi

Excellent tutorial!

Thanks for share.

Userlevel 7
Badge +6

Very good! thanks for the tutorial!

Reply