How To Share Your Third-Party Excel Product Mapping With Your Team

How To Share Your Third-Party Excel Product Mapping With Your Team

In this article, you will learn how to share your third-party Excel product mapping so that your team members can automatically map their products & import.


This article applies to MeasureSquare 8.

Background on Importing 3rd Party Excel files

MeasureSquare 8 allows you to import your products from third parties, such as QFloors/QPro, that allow you to export products to a Microsoft Excel sheet. In the even that the exported Excel sheet doesn't match Measure Square's product database format, you will need to use our Import 3rd Party Excel File feature in order to make it compatible with Measure Square. If you are not familiar with this feature, please click the article link below.

MeasureSquare 8 allow users to save this profile mapping so that they can import their third-party products repeatedly without needing to set the mapping all over again. This step is also covered in the previously linked video at the 0:59 timestamp.

Sharing 3rd Party Excel Import Profiles with Others

For users who are part of a larger team, profile mappings can be shared so that the entire organization can simply select the profile and import products without need to set the mapping. This means time savings and product consistency not only for individuals, but across all members of a team. To do this, please follow these steps:

1. Right-click Product/Services, then go to Import/Export > Import 3rd Party Excel




2. Click Export Current Profile and download the mapping Profile as a .m2prdmap file. Send this file to your team members.




3. Your team can import the .m2prdmap file in MeasureSquare 8 and proceed to import their products.

    • Related Articles

    • How to import Products from a File, M2 Cloud, and QBO in MeasureSquare CRM?

      In this article, we will show you how to import Products from an Excel File, the Cloud, and from Quickbooks Online (QBO) in MeasureSquare CRM. Importing products to the Products module is used to keep all your product data in one centralized ...
    • How do I Map or Import a 3rd party Excel File to My MeasureSquare Database?

      In this article, you will learn how to use import products from a custom or 3rd-party Excel file into your product database in MeasureSquare 8. This applies to MeasureSquare 8, Build 8941.
    • How to Export your Products & Price Books to Excel

      In this article, we will show you how to export your product list and price book as an Excel (.xlsx) file. Exporting Products Step 1: Go to Products module Step 2: Click on the three-dots and select Export to Excel Exporting Price Books Step 1: Go to ...
    • How to Import Contacts in MeasureSquare CRM

      In this article, we will cover how to import contacts into MeasureSquare CRM via CSV/XLS/XLSX, as well as QBO, Google, and Outlook. This article applies to MeasureSquare CRM. Steps to import contacts via CSV, XLS, and XLSX Step 1. From the homepage, ...
    • How to Import Projects into MeasureSquare CRM

      In this article, we will show you how to mass import your projects into MeasureSquare CRM using an Excel file. You can easily import all your project data to the CRM using an Excel file via the Import Projects tool. Here are the following steps: Step ...