Quick summary
To import Google Sheets into Notion, you first download your spreadsheet as a CSV file, then use Notion's built-in Import feature to upload and map the CSV columns into a fully structured Notion database.
Steps
- Open the Google Sheets file you want to import, then click File in the top menu.
- Hover over Download in the dropdown menu to expand the export options.
- Select Comma Separated Values (.csv) to download the spreadsheet as a CSV file.
- Open Notion and navigate to your workspace, then click + Add a page or + New page in the left sidebar.
- Click the three-dot menu in the top-right corner of the new page.
- Select Import from the dropdown menu.
- Click Choose a file and upload the CSV file from your device.
- Click Map CSV headers to match your spreadsheet columns with the correct Notion fields.
- Review the imported content, make any needed edits, then click Import CSV to complete the upload.
- Your Google Sheets data is now live in Notion as a database.
