Talk to us
Status:

Support Center

Tips on optimizing your spreadsheet for importing data

Note: This action is only available to Admin Users.

Importing your spreadsheets is typically very simple, but can be a little complicated depending on the scope of your import. Whatever that scope may be, the below tips may be helpful when planning your next import. 


Advanced importing

   

Avoiding formulas

Many times your spreadsheet of data will contain formulas and calculations. We recommend using a fresh spreadsheet without any formulas for importing data. If you have a spreadsheet that uses formulas or data linking to generate your outputted data, just copy all of your data on your spreadsheet and paste into a new sheet without the formulas.

Note: Use CMD+A or Ctrl+A to select all contents in your spreadsheet, and CMD+C or Ctrl+C to copy all all contents in your spreadsheet. After that, you can paste the content into a new spreadsheet, making sure to paste the values only. 

Formatting dates 

For the best chance of success when bringing it date information from your spreadsheet into Pipedrive, we suggest making sure that any date field in your spreadsheet is properly formatted as a date in Excel.

While fields formatted as plain text may also work, we still suggest formatting as a date, as that provides the most consistent success when attempting to bring in that information.

Note: If you receive an error when attempting to import a spreadsheet, the issue may stem from your spreadsheet: while there is no maximum limit on the number of columns in the spreadsheet, the maximum file size is limited to 50mb, with a maximum limit of 50,000 rows within the spreadsheet.