Importing and Exporting Data

Overview

Memoreru tables support CSV import and export to CSV, JSON, and Excel formats. You can bring data from existing spreadsheets into Memoreru, or take your Memoreru data to other tools.

CSV Import

What is Import?

CSV import lets you bring data from Excel, Google Sheets, or other tools into a Memoreru table all at once.

How to Import

Open the table's detail page
Click the menu button ("...") in the upper right
Select "Import CSV"
Choose the CSV file you want to import
Review and adjust the column mapping
Click the "Import" button

CSV File Format

Prepare your CSV file in the following format before importing.

Requirements:

File format: .csv
Character encoding: UTF-8 (recommended)
Row 1: Column names (header row)
Row 2 onward: Data rows

Example CSV:

Title,Author,Year,Genre,Rating
Atomic Habits,James Clear,2018,Self-help,5
Deep Work,Cal Newport,2016,Productivity,4
The Phoenix Project,Gene Kim,2013,Business,5

Column Mapping

Match each CSV column to a column in your table.

CSV Column	Table Column	Notes
Title	title (text)	Auto-mapped
Author	author (text)	Auto-mapped
Year	year (number)	Check data type
Genre	genre (select)	Added as new options
Rating	rating (number)	Check data type

Tips:

Columns with matching names are mapped automatically
You can also add unmatched columns as new table columns
Choose whether to append to existing data or replace it

Things to Watch Out For

Type mismatches: If a text value is found in a number-type column, that cell will be left blank. Check your CSV before importing
Select options: If a CSV value does not match an existing option, it is automatically added as a new option
Empty cells: Empty cells in the CSV are imported as empty cells in the table

Exporting Data

What is Export?

Export writes your table data to a file. Use it for analysis in other tools or as a backup.

How to Export

Open the table's detail page
Click the menu button ("...") in the upper right
Select "Export"
Choose the export format (CSV / JSON / Excel)
The file downloads automatically

Comparing Export Formats

Format	Extension	Best for
CSV	`.csv`	Excel, Google Sheets, importing into other databases
JSON	`.json`	Processing data programmatically, API integration
Excel	`.xlsx`	Opening directly in Excel, formatted review

Format Details

CSV

id,Title,Author,Rating
1,Atomic Habits,James Clear,5
2,Deep Work,Cal Newport,4

Opens in any spreadsheet app
Easy to process programmatically
Does not include formatting or colors

JSON

[
  {
    "id": 1,
    "Title": "Atomic Habits",
    "Author": "James Clear",
    "Rating": 5
  },
  {
    "id": 2,
    "Title": "Deep Work",
    "Author": "Cal Newport",
    "Rating": 4
  }
]

Preserves data types
Well-suited for programmatic processing
Useful for API integration

Excel

Open and edit directly in Excel
Cell formatting is preserved
You can add formulas and pivot tables

Practical Use Cases

Use Case 1: Migrate from an Existing Spreadsheet

Use this when you want to move customer data, inventory, or other data from Google Sheets or Excel into Memoreru.

Steps:

Export the spreadsheet as a CSV file
Create a new table in Memoreru (or use the AI assistant to design it)
Import the CSV
Confirm the column mapping and you are done

Use Case 2: Regular Data Backups

Periodically export your data and keep a local backup.

Recommended frequency:

Small datasets: once a month
Critical data: once a week

Use Case 3: Integrate with Other Tools

Export data to use it in other tools and workflows.

Destination	Format	Use
Excel	CSV or Excel	Advanced calculations and charts
Google Sheets	CSV	Team collaboration
Python / pandas	CSV or JSON	Data analysis
Other databases	CSV	Data migration
AI tools	CSV	Analysis and visualization

Tips and Tricks

1. Check your CSV before importing

Open the CSV in a text editor or spreadsheet app and verify it is formatted correctly. Pay attention to:

The header row (column names) is on row 1
Number columns do not contain extra symbols like $ or ,
Dates are in a consistent format (e.g., 2025-04-01)

2. Test with a small sample first

Before importing a large dataset, test with 10–20 rows to confirm everything maps correctly.

3. Filter with a View before exporting

If you only need a subset of your data, use a View to filter rows first, then export from the View for a clean result.

FAQ

Q1: What should I do if I get an error during import?

A: Check the character encoding of your CSV file. Saving as UTF-8 (without BOM) resolves most errors. CSVs created in Excel are often saved as Shift-JIS (Windows) or similar encodings — convert to UTF-8 before importing.

Q2: Can I export images and file attachments?

A: Images and file attachments are not included in CSV, JSON, or Excel exports. Columns of type image or file are exported as URLs or filenames (as text strings).

Q3: Will importing overwrite my existing data?

A: No. Importing appends new rows to the existing data. Existing rows are not overwritten or deleted.

Q4: Is there a file size limit for exports?

A: There is no enforced size limit, but exporting very large tables (tens of thousands of rows) may take some time to complete.