How to combine multiple IMPORTDATA formulas in Google Sheets
Apr 5 · 1 min read

Joining several IMPORTDATA can have many benefits, including getting around IMPORTDATA size limit.

1. Combine multiple IMPORTDATA functions in one formula separated by a semi-colon and closed in curly braces.

={importdata(“"); importdata("")}

2. Insert the array into =UNIQUE formula to get rid of duplicate headers and any possible duplicate values in both CSV files.

=UNIQUE({importdata(“"); importdata("")})

What are the limitations?

In a single document, you can combine up to 50 combined calls of IMPORTDATA.

______________________ Author: Renars Rudzitis Bulk Import Export Update Migrate app for Shopify

Written by

Shopify App to Bulk Import Export Update Migrate your Store