Google Sheets
Importing CSV files to Google Sheets
Use Google Sheets as a data repository for your Miro data. Work with separate worksheets for CSV file import or build a master worksheet by appending many CSV files with a shared format. You can, for example, build a master worksheet for all tasks in your project for an extended period of time, where you will always be able to find a particular task and go back to the original Miro board item by following the backlink.
Open Google Sheets and create a new, blank spreadsheet.
Click on File in the menu, and then choose Import.
In the Import window, select the Upload tab and select your file from your device
In the Import file settings dialog, choose Insert new spreadsheet or Replace spreadsheet under the Import location options, depending on your preference.
Leave Detect automatically as default under Separator type which will correctly identify the CSV format.
Click on the Import data button.
You will notice a new File imported successfully. Open now option appear in the window. Click on Open now to open the new data sheet.
Freeze the header row
To make working with you data easier, we recommend freezing the first row of the sheet with the column titles.
Select the first row
Select View -> Freeze -> 1 row
Appending CSV Data to an Existing Google Sheet table
Open a master table with existing data
Select File -> Import
Select the CSV file under the Upload tab
In the Import file window, under the Import location drop down menu, select Append to current sheet
Click on the Import data button
Last updated
