FAQ: How to keep formulas and import data into same Excel sheet?

This article will help you understand how you can keep formulas and import your data into the same Excel sheet.

Table of contents

1. How Coupler.io works
2. What Coupler.io team recommends
3. Review our example
4. Where to find the Cell address

1. How Coupler.io works

Yes, Coupler.io always overwrites all data starting from the top-left cell specified.

2. What Coupler.io team recommends

That is why we recommend our users to keep all calculations (incl. formulas) on the left side of your imported data set.

We've chosen this approach for some technical reasons.

1. We believe that the way Coupler.io does it now is the most balanced solution in terms of functionality (giving the way to keep import and calculations in the same sheet) and performance (on the large sets of data).
2. In addition, it is safer in case if the number of columns in your data set grows. Otherwise, new columns might override your calculations on the right side.

3. Review our example

Below is an example where we imported data to an Excel sheet and left the first column and first row empty. After that, we used formulas to populate the first column with the total amount for sold entities: Qty Sold x Price per item (C column x D column) and first row to calculate total sales amount - as the sum of values in A column. The importer was configured to use Cell address = B2, so after data was inserted we got calculated values of sales per product and total:

4. Where to find the Cell address field

The Cell address field can be easily found under the Destination settings:

Please email us at contact@coupler.io to share your thoughts about this approach: whether it sounds reasonable to you, as it is indeed very important for us to understand your use case.