Importing from CSV

Reflect supports importing your data from various sources, as long as it follows a particular format which we will describe in this tutorial.

Motivating Example: Events

Suppose you’ve been logging your events for the last few days, months, or years, and you’d like to have this data in Reflect to correlate with all of your other metrics. Reflect has a CSV import tool that can help you with this task.

As an example, here is what your data may look like:

You can import this data by first pressing  at the top left of the Reflect tab to view the sidebar menu, then pressing  to navigate to the Settings page.

In the Settings page, scroll down until you see Import Reflections. Click and choose your CSV file for import.

As you can see, the import tool has inferred the date column of the CSV. All imported data needs a date column to differentiate when your metrics were recorded. If the CSV tool can’t detect a date column, your data can’t be imported. Please reach out to us if this happens! We want to support as many date and time formats as possible.

If there are multiple date columns, for example one for when you start an activity and one for when it ends, you can select which of these is used for the Reflection recorded date.

Next, you can select what the types are your columns are. For importing data, we currently support Yes/No, Numbers, and Text.

Once you’ve selected the type of each metric and given your imported data a Reflection name, click Import at the top right of the importer tool. After the import has finished, you can go to the History tab and find your historical data.

As you can see from the imported data, where there were empty values in the CSV, the importer tool created a Reflection with the corresponding values empty.

Repeated Imports

Suppose you have more event data you want to import at a later time. When you try to import a CSV matching what was imported before, the import tool recognizes this and lets you import Event reflections again by selecting Events in the Available templates dropdown.