# How do I export and merge my Salesflare data in one place?

Can I export all of my data (accounts, import, and opportunities) from Salesflare together?

You can [export all of your data](/en/articles/633823-how-do-i-export-my-salesflare-data) from Salesflare by clicking on the 3 dot menu on each page.

![](/assets/9e750fccd19f70a5fc01c592.gif)

The Excel or CSV file will contain an export of all related data. Just delete the columns you don't need and merge them together as we’ll explain below.

<a id="h_7caf25d66e"></a>
# How do I merge the data together?

<a id="h_f9469de5c0"></a>
## Step 1:

Create a new Excel workbook. For example, I have made a new workbook named “[VLOOKUP-sample](https://downloads.salesflare.com/resources/VLOOKUP-sample.xlsx)” here.

<a id="h_1cc1453433"></a>
## Step 2:

Copy all the sheets you want to merge (accounts, contacts, and opportunities) into the new workbook you created. The easiest way to do it :

*   Right-click on the bottom of the exported sheet
    
*   Click on “Move or Copy”
    
*   Choose the workbook you want to move it to
    
*   Click “Okay”
    

**_Note:_** _Usually, one account can have multiple opportunities and contacts, so, it is best to merge accounts into opportunities or contacts. That way you have a different row for each opportunity or contact. In this example, I will show you how to merge contacts and accounts_

<a id="h_46ea8e443e"></a>
## Step 3:

Delete the columns that are not needed (helps you keep it clean)

<a id="h_40e8a6708e"></a>
## Step 4:

We use a VLOOKUP formula for merging the data, in which we use the **account id** to find matching data (as it is unique and also present in all three sheets).

**_Note_**: _If you are using another value than the account id, like the account name, always make sure to move that data to the first column. You can only do a VLOOKUP based on the first column of a range_

<a id="h_3975b8f007"></a>
## Step 5:

Copy the headings of columns from accounts you want to merge into contacts.

![](/assets/77140f281e74bb2e93a0a58e.gif)

_Example of the Accounts headings being copied into the Contacts sheet_

<a id="h_7d4f5ffd08"></a>
## Step 6:

Use the VLOOKUP formula shown below for merging the data (here is [a sample file](https://downloads.salesflare.com/resources/VLOOKUP-sample.xlsx) for your reference)

**`=VLOOKUP($A2,Accounts!$A$1:$H$4,MATCH(Contacts!H$1,Accounts!$A$1:$H$1,0),FALSE)`**

![](/assets/5243cb43da1bbecf0af960f1.gif)

_Example of using VLOOKUP to merge Accounts into the Contacts sheet_

<a id="h_27e72f35de"></a>
## Step 7:

Use the $ sign to avoid the cell reference from changing

![](/assets/746e7db1f86fb06c063a095b.gif)

_Example of the use of "$" on all the cell references and lookup ranges_

Voila! 🪄 Repeat the same process for opportunities or any other data you want to merge.

[Download a Sample Workbook Here](https://downloads.salesflare.com/resources/VLOOKUP-sample.xlsx)