web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Import Data in crm dyn...
Microsoft Dynamics CRM (Archived)

Import Data in crm dynamics via excel csv file

(0) ShareShare
ReportReport
Posted on by Haseeb Jamshed 360

I have to import data in MSCRM of more than 2.5 gb in MSCRM dynamics. Is there any way to Import the records without splitting the file in to 8 or 32 mb? Can some one suggest third party tool for it?

Thanks in advance,

Haseeb Jamshed

*This post is locked for comments

I have the same question (0)
  • Royal King Profile Picture
    Royal King 27,686 on at

    Try with Scribe or Kingswaysoft SSIS Toolkit

    https://openmind.scribesoft.com/html/insight_download

    http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-crm

  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    Rajkumar Rajaraman on at

    Hi Haseeb,

    You can try to follow the instructions from the below mentioned link:-

    blogs.msdn.com/.../default-file-size-limit-for-the-crm-2011-data-import-wizard-and-how-to-modify-it.aspx

    Regards,

    R.Rajkumar

    "Please mark my answer as verified if you found it helpful"

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Haseeb,

    CRM 2011 we have change the import file size to 80 MB and tested for 78 MB which is working fine.

    Update ServerSettingsProperties set IntColumn = 80 where columnname=’ImportMaxAllowedFileSizeInMB’

    Thanks

    Vamsi Krishna J

  • Community Member Profile Picture
    Community Member on at

    Hi Haseeb,

    We have a CRM migration tool that allows you to import data into CRM, both on-premise and online using the bulk import functionality which CRM provides.

    This supports multiple table mappings per migration project, defining multiple data sources, and when you are done running your import in development, you can clone the connections into a new environment , for example SIT, UAT or PROD and re-run your import against there when ready. No coding required, so essentially anyone with BA / DB schema knowledge can use this tool to perform migration imports.

    http://www.splsolutions.com.au

    Vijay Mani | CRM Support engineer

  • Community Member Profile Picture
    Community Member on at

    Hi,

    I believe that you've already imported data successfully, just wanna drop my suggestion here in case of someone else struggles the same issue.

    You can import data from CSV or Excel automatically using Trujay.

    However, there is a set of requirements for CSV files:

    • The file contains the Column “id” or “Id” that contains the unique value
    • Separator character is a comma ( , )
    • The file can be downloaded from Dropbox, Google Drive, One drive or Computer Hard drive
    • The file type (extension) is .CSV. Please Note! If you use Windows OS make sure that the file name has an extension .CSV right within the title FILENAME.CSV
    • The file size is less than 1 Gb

    As for migration from Excel, you can find requirements for successful data import here.

    And one more thing. You can migrate from Excel directly in case every data module is in a separate file yet not on sheets in a single doc.

    You may run CSV to MSCRM or Excel to MSCRM Sample import for free or schedule a call with Trujay specialists for more info.

    Sincerely.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans