How to combine multiple IMPORTDATA formulas in Google Sheets

Excelify.io
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(“https://domain.com/path/to/file1.csv"); importdata("https://domain.com/path/to/file2.csv")}

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

=UNIQUE({importdata(“https://domain.com/path/to/file1.csv"); importdata("https://domain.com/path/to/file2.csv")})

What are the limitations?

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

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

Excelify.io

Written by

Shopify App to Bulk Import Export Update Migrate your Store