Export to Excel redesign, what you need to know

Have you ever exported to excel to find that some of the column formats that were exported did not match the type of record in CRM?

Well in the Spring Release Update 1 this has been fixed. So what’s new?

The Redesign

  • The export dialog has gone, you choose via the dropdown how you want to export the data i.e. to excel online, static or dynamic
  • What you see in the view is what is exported
  • No more warning messages, file format is set to XLSX
  • The column names and view column widths are used to pre format the excel sheet
  • The tab name is the same as the view name
  • All pages are exported
  • The data is always importable no more separate process, the same file is used
  • Export and import limit updated to 100k and 32mb

The New Mapping

The table below details the new CRM data format mapping to Excel.

datamapping

** Excel does not native data type to show date + time in one cell, as a result, only date is visualized in Excel for a date-and-time data.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s