Importing and Exporting Data

Overview

Memoreru tables support CSV import and exporting data as CSV or Excel. 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

1. Open the table's detail page
2. Click the menu button ("...") in the upper right
3. Select "Import" — a "CSV Import" dialog opens
4. Choose the CSV file you want to import
5. Review and adjust the column mapping
6. On the preview screen, check how many rows will be created and how many will be updated
7. Click the "Execute 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
• A single import can bring in up to 5,000 rows (going over this shows an error and asks you to split the file into smaller imports)

Example CSV:

Column Mapping

Match each CSV column to a column in your table.

Tips:

• Columns with matching names are mapped automatically
• Columns that don't match can be assigned manually to an existing column from the dropdown
• Choose "Skip" for any column you don't want to bring in — it won't be imported

Whether Rows Are Created or Updated Depends on the Import Key

Whether imported data creates new rows or updates existing ones is decided automatically by whether "Use as import key" is turned on for a column in the table's column settings.

• On: Rows whose value in that column matches existing data are updated; rows with no match are created
• Off: Every row is created as new

The preview screen, shown before you execute the import, tells you how many rows will be created and how many will be updated — check it matches what you expect before running the import.

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, that row fails validation and is not imported. Add the option to the table first, then import again
• Multi-select options: When a cell holds several values, any value that doesn't match an existing option is silently dropped with no warning — the rest of the matching values are still imported
• Empty cells: Empty cells in the CSV are imported as empty cells in the table

---

Getting Data Out

Three Ways to Get Data Out

Memoreru tables offer three ways to take data out, depending on what you need.

Export as CSV

1. Open the table's detail page
2. Click the menu button ("...") in the upper right
3. Select "Export" — the CSV file downloads right away (there is no format-selection screen)

If the table has more than 1,000 rows, a confirmation dialog appears before the download starts.

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

Download as Excel

Outside the "..." menu, a separate toolbar near the top of the screen has an icon-only "Download" button. Clicking it downloads the table directly as an Excel file (.xlsx).

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

Copy the Table

If you want to paste the whole table straight into Excel or a spreadsheet, use the "Copy Table" button (the clipboard icon) in the toolbar. Clicking it copies the table's contents to your clipboard, and pasting it into Excel or similar tools keeps the columns and rows intact.

---

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:

1. Export the spreadsheet as a CSV file
2. Create a new table in Memoreru (or use the AI assistant to design it)
3. Import the CSV and check the column mapping
4. Check the row counts on the preview screen, then execute the import

Use Case 2: Regular Data Backups

Periodically export or download 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

Take exported or downloaded data into other tools and workflows.

---

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. Checking the create/update counts on the preview screen makes it easy to tell whether the mapping is doing what you expect.

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 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: It can. If "Use as import key" is turned on in the table's column settings, rows whose value matches an existing row are overwritten with the new data. If it's off, every row is added as new data. If you don't want existing data changed, check the import key setting before importing.

Q4: Is there a row limit for import or export?

A: CSV import is limited to 5,000 rows per import — going over this shows an error, so split your CSV into smaller batches. There's no row limit for export, but exporting a table with more than 1,000 rows shows a confirmation dialog first.