How to Import Data from Excel or CSV Files into Document Studio

Published in: Document Studio

Document Studio runs inside a Google Spreadsheet but if your data source is somewhere else, maybe a Microsoft Excel spreadsheet or a MySQL database or Salesforce CRM, you can still use that data with Document Studio.

First, you need to export the data from your external data source into a CSV file. Then open your Google Spreadsheet, go to File > Import, choose the upload tab and then select your CSV file from the desktop.


On the next screen, choose “Replace Current Sheet” as the Import action so that CSV data gets imported into the currently active sheet.

Next, choose the separator character or use the default option and let Google Sheets automatically detect it for you.


Your CSV data will now be imported into Google Sheets and ready for merging with Document Studio.

Published in: Document Studio

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
Amit Agarwal

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch