mappl.io documentation
  • GETTING STARTED
    • Getting started
    • How to install the app
    • Your first spatial table
    • Access templates
  • WORKING WITH VISUAL DATA
    • Categorize items using nested shape hierarchies
    • Categorize items by using row and column labels
    • Categorize items by color
    • Tag items using shapes
    • Use native Miro tags
    • Label sticky note clusters
    • Use connector lines
    • Practical tips
  • RESULTS TABLE OUTPUT
    • Results table overview
    • Make changes to the table
    • Filter
    • Sort
  • EXPORT
    • CSV export
    • Notion
    • Airtable
    • Coda
    • Excel
    • Google Sheets
Powered by GitBook
On this page
  • Creating a New Excel Worksheet from a CSV File:
  • Appending CSV Data to an Existing Excel Table
  1. EXPORT

Excel

Importing CSV files to Excel

PreviousCodaNextGoogle Sheets

Last updated 2 years ago

Use Excel 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.

Creating a New Excel Worksheet from a CSV File:

The precise steps vary in different versions of Excel, so below we list the general steps that should be followed.

  1. Open Excel and create a new workbook.

  2. Click on the "Data" tab in the ribbon.

  3. Choose Get Data and then select Text/CSV.

  4. Select a previously saved CSV file from the results table.

  5. In the "Text Import Wizard", review the data settings and then click Transform Data

  6. Find Home ribbon that opens, select Use first row as headers

  7. Click on the Close & Load button to close the window to view the imported data in your worksheet.

Appending CSV Data to an Existing Excel Table

New CSV data can be appended to an existing table in a number of ways in Excel. Below we only list the simplest approach, which involves creating a new table and copying and pasting the data. Consult Excel documentation about more advanced methods such as combining CSV files form the same folder or using macros to achieve the same goal.

  1. Add the CSV data to a new Excel worksheet by following the steps in the previous section.

  2. Select all data in the worksheet excluding the title row and Copy the data

  3. Go the the Worksheet containing your master table, click on the first empty cell below the last row with data and Paste the data into place.