RemNote gives you several ways to import a table into your knowledge base.
Importing a table from a file
If your table is saved on your computer, importing the file directly is the most reliable route, and the one to use when a table is too long to paste comfortably.
Go to Settings > Import and choose CSV / Excel. Drag your file onto the upload area, or click Browse for spreadsheet to pick it out. RemNote accepts .csv, .tsv, and .xlsx files.
RemNote will automatically create a Simple Table where the first row of the file becomes the table's header row, and every row after it becomes a row of the table. If you import a spreadsheet of amino acids whose first row reads Amino Acid, Three-letter Code, One-letter Code, you get a table with those three column headers and one amino acid per row, laid out the way the spreadsheet had it.
Creating a table by pasting
For a table you can already see on screen rather than one saved as a file, pasting is quicker than going through Settings. RemNote recognizes tabular data as you paste it and builds a table out of it for you.
Open your spreadsheet in any application (e.g., Excel, Google Sheets, ChatGPT).
Select and copy the rows and columns you want to import.
Place your cursor where you'd like the table to appear in your RemNote document.
Paste with Ctrl+V (or Cmd+V on Mac).
RemNote will automatically create a Simple Table from the pasted data, preserving the row and column structure.
Tip: This works with any tab-separated or table-formatted data, not only spreadsheets. Tables copied from web pages, Google Sheets, Excel, and AI assistants such as ChatGPT or Gemini are all recognized.
Pasting into an existing table
You can also paste tabular data directly into an existing Simple Table or Advanced Table:
Copy the data from your source.
Select cells in your existing table where you want to add your data.
Paste using Ctrl+V (or Cmd+V on Mac).
The pasted data will fill in cells starting from the selected position, following the row and column structure of the copied content.
Turning a screenshot into a table
Sometimes a table cannot be copied at all: it is a photo of a whiteboard, a figure inside a PDF, or a screenshot from a slide deck. In that case, paste the image into your notes, open the three-dot (...) menu, and select AI Convert to Text. RemNote reads the text out of the image and builds a table from it.
Exporting a table
Export works in the other direction, for when you need a table in a spreadsheet, a script, or a document outside RemNote.
Click the gear icon in the top-right corner of the table, select Export, and choose CSV (.csv) or Excel (.xlsx).
Note: Exporting is available on Advanced Tables. If the table you want to export is a Simple Table, convert it first: click the gear icon, choose the conversion option, and Export becomes available.
Tables are also included when you export a whole document or knowledge base as Markdown. That is the route to take when the table is one part of a larger set of notes rather than the thing you are after; see Exporting Notes for the full list of formats and what each one keeps.