Knowledge Base

Mapping in Pipedrive
How to format your columns in excel

How can I format dates to import into Pipedrive?

Jenny Takahara, November 2, 2023
Note: This action is only available to admin users.

Pipedrive supports multiple date formats and configurations. When importing your own dates into any date-specific field, there are a few things to take into consideration:

  • How are you entering your data? 4/04/2016 or 2016/04/04 for example.
  • How is the column in your spreadsheet formatted? Date, General, or Text for example.

The image below shows you an import that was done using several different formatting techniques and how they showed up in Pipedrive.

Study the image to see how your dates will turn out:

Mapping in Pipedrive

Once you import your spreadsheet, if Pipedrive can identify the format of your dates without any confusion, no action is needed. If Pipedrive can't identify the format of your dates, it will prompt you to specify your spreadsheet's formatting.

How to format your columns in excel

Spreadsheets can have their cells formatted for special types of data. Often, you may receive a spreadsheet that's already formatted, or you may have to format your own data. Here's how to edit the format of your columns in Excel:

Right-click the head of your column > Format Cells > Choose your desired format.

Was this article helpful?



Related articles

Got any questions?

Contact us