Grape
Download
Help center
Writing and the editor3 min readUpdated November 18, 2026

Import and export CSV files in a table

Fill an empty table view from an Airtable, Notion or spreadsheet CSV file, each column given a type, and save a table as a CSV file, on desktop and mobile.

An empty table view can take in a CSV file, the format Airtable, Notion, Google Sheets, Numbers and Excel export tables in. Each row of the file becomes a row of the table, and each column a column, the way Import from Anki fills a flashcard deck. Once the table has rows, it saves as a CSV file for a spreadsheet or another app. Both work on desktop and on mobile, on every plan, Free included, and on a board too.

Table view is in Beta, so it starts off. Turn it on first: open Settings, go to Note Apps and switch on Table view. See Choose which apps show in your notes.

Export your table

  • Airtable. Open the view you want, click its name at the top and choose Download CSV. Only the rows and fields the view shows are in the file, so pick a view that shows them all.
  • Notion. Open the database as a full page, open the three dots at the top right, choose Export and pick Markdown & CSV. Notion downloads a ZIP file. Open it and the database is the .csv file inside, named after it. When there are two, take the one ending in _all: it holds every row, not only the ones the view shows.
  • Google Sheets. File, Download, Comma Separated Values.
  • Numbers. File, Export To, CSV.
  • Excel. File, Save As, CSV UTF-8. Unicode Text works too.

Import on desktop

Put a table in the note, or go to one you have: type /table and choose Table view, see Use table view. Open the dots at the end of the table's row, choose Import CSV under Layout and pick the file. Its rows go in at once. ⌘Z on Mac or Ctrl+Z on Windows and Linux takes the whole import back. Import CSV is there while the table has no rows; once it has some, the dots offer Export CSV in its place.

Import on mobile

Put the file where your phone can reach it, such as iCloud Drive, Google Drive or the Files app. In the note, tap the dots at the end of the table's header, or hold the header, and choose Import CSV. On the table's own screen, Import CSV is in the dots at the top right. Pick the file and its rows go in. The undo button at the top of the note takes the whole import back.

What comes in

The table takes the file as it is:

  • The name. A table still named Table is named after the file, without the view's name Airtable adds or the id Notion adds. A table you named keeps its name.
  • The headers. The file's first column gives each row its name, and its header names the Name column.
  • Status. A column named Status becomes the table's Status, and its names the board's columns in place of To do, Doing and Done, so a Notion board grouped by Status comes in ready to show as a board. Done or Complete goes last, where a board keeps the column that counts as done. A file with no Status column leaves Status out, the way a table that is not a board does.

How the types are chosen

A CSV file does not say what type a column is, so Grape reads the values of each new column and picks the type all of them fit:

  • checked, Yes and No, the way Airtable and Notion write a ticked box, make a Checkbox
  • plain numbers make a Number
  • dates make a Date, with or without a time, though the time is not kept
  • web addresses make a Link
  • names separated by commas that come up again and again, like genres or tags, make a Multi-select
  • a handful of names repeated down the column, like a stage or a priority, make a Select, each name an option with a color of its own
  • anything else stays Text, exactly as it was written

A column with even one value that does not fit a type stays Text, so no value is changed into something else. If Grape picked a type you would rather not have, open the column's header and change its Type, see Sorting the rows in Use table view.

What stays behind

  • Formulas, lookups and rollups come across as the values they worked out, since that is what the file holds. Grape works out formulas from Notion and Airtable too: add a Formula property and paste the formula in.
  • People come across as their names in a Text column. A Person property holds people the note is shared with, so a file cannot fill one.
  • Attachments come across as their names and links in a Text column. Airtable's links stop working after a few hours, so download a file you need and add it to the row's card.
  • Views, filters, sorts, groups, colors and column widths are not in a CSV file. Sort or group the table again in Grape, see Use table view.
  • The pages of a Notion database are the Markdown files of the same export, not part of the CSV. Bring them in with Import Markdown files.

Limits

A table holds up to 1,000 rows and 30 properties, and a cell up to 2,000 characters. A file can be up to 20 MB. When a file holds more, what fits comes in, and a message counts the rows and columns left out and the long values cut short. Nothing is said when all of it came in.

Save a table as a CSV file

Once a table has rows, its dots offer Export CSV in place of Import CSV.

  • On desktop, choose Export CSV in the dots at the end of the table's row. The save panel opens on your Downloads folder with the file named after the table: pick where it goes and save it.
  • On mobile, choose Export CSV in the table's dots in the note, or in the dots at the top right of its own screen. The share sheet opens with the file named after the table: save it to Files, send it, or open it in another app.

The file holds the table as it shows it: Name, Status while the table shows it, and every property, in the table's order, with the rows in the table's order, its sort and the rows you moved included. A grouped table writes its rows as one list, without the groups. A checkbox is written as Yes or No, a date as 2026-11-18, the options of a Select or Multi-select by name with commas between them, people and files by name, and a formula as what it works out to. A card's notes and comments stay out of it. A value that starts like a spreadsheet formula, with = or + for example, gets a ' in front, so opening the file in Excel or Google Sheets runs nothing. Excel, Numbers, Google Sheets, Airtable and Notion all open it, and Import CSV brings it back into an empty table with its columns.

The rows travel with the table: everyone the note is shared with sees them, and they sync with the note.

Did this not help? Contact us with the version you are on and what you were trying to do.

Try It While the Guide Is Open

Grape is free to install and needs no account, so you can follow along in the real app.