MMPlugs Logo

Docs / Import from a CSV

Import from a CSV

Import from a CSV

If your data already lives in a spreadsheet, you don't have to retype it. MMTable accepts CSV files via drag-and-drop or browse-and-upload.

Import a CSV

  1. Export your spreadsheet as CSV. In Excel: File → Save As → CSV UTF-8. In Google Sheets: File → Download → Comma-separated values.
  2. Open MMTable in the editor. Drag the CSV file onto the editor area, or click Import → CSV in the toolbar and pick the file.
  3. MMTable parses the file: the first row becomes the header row, the rest become data rows. The editor updates immediately.
  4. Adjust column types and formatting as needed.
  5. Click Save.

CSV format requirements

  • UTF-8 encoded. Most modern spreadsheet apps default to UTF-8 — if you see  or boxes where accented characters should be, re-export specifically as "UTF-8".
  • Comma-delimited. Tab and semicolon delimiters aren't supported by the free importer.
  • Fields containing commas or quotes should be quoted with double-quotes per RFC 4180. Spreadsheet apps handle this automatically.
  • First row is treated as headers. If your CSV doesn't have headers, add a stub header row before importing or use the column-resize handle to rename columns later.

Limits

The browser-side parser handles files up to a few megabytes comfortably. For larger imports, split the CSV or use the remote CSV data source in Pro, which streams server-side.

About leading = in cells

If a CSV cell starts with =, +, -, or @, the cell value is preserved as-is when stored. Cells exported back out from MMTable later are auto-prefixed with a single quote so Excel/Sheets treats them as text rather than executing them as live formulas. This protects against CSV-injection when someone else opens an exported file.