---
title: Import Table Data from CSV
description: "If you have an existing table on another website, turn the table data into CSV file (or **JSON**) and import it into Ninja Tables. - First, go to the Ninja Tables dashboard and click the**Import Table**button (or the \"Import\" option…"
url: "https://www.ninjatables.com/docs/import-table-data-from-a-csv/"
updated: "2025-06-02"
category: Advanced Mode (Classic Table Builder) / Import / Export
---

# Import Table Data from CSV

If you have an existing table on another website, turn the table data into CSV file (or **JSON**) and import it into Ninja Tables.

- First, go to the Ninja Tables dashboard and click the**Import Table**button (or the "Import" option on the left menubar). Now, press the **Choose File**button.

![](https://ninjatables.com/wp-content/uploads/2022/09/import-button-01-scaled.webp)

- Choose the **CSV / JSON** file you want to upload.

![](https://ninjatables.com/wp-content/uploads/2022/09/02.webp)

- Click the **Import** button, and then you’re good to go!

**Ninja Tables** is going to do the rest for you. Your data will be automatically uploaded.

You can also use the "Import-Export" tab at the top of a table to import tables.

![](https://ninjatables.com/wp-content/uploads/2022/09/03-scaled.webp)

## Table Data Import for MS-Excel

If you have any issue with CSV data imports, such as having blank values in your cell, in case you use MS-Excel, export the CSV as MS-DOS Comma Separated Value (CSV).

![import table from ms-excel](https://ninjatables.com/wp-content/uploads/2023/01/import-table-data-from-CSV-2.png)
Export As MS-DOS comma-separated (.csv) format

Ninja table supports only comma-separated CSV and JSON.

If your CSV file is not **Comma Separated**& is in another format,there is a trick for converting it to make it Comma-Separated-CSV,

- First, go to the **Google Spreadsheet → File →**click on **Import**& then a pop-up will appear.

![make a csv](https://ninjatables.com/wp-content/uploads/2023/01/import-table-data-from-CSV-3.png)
Import File

- Click on the **Upload**button & then upload the CSV file.

![upload csv](https://ninjatables.com/wp-content/uploads/2023/01/import-table-data-from-CSV-4-1024x456.png)
Upload button

- Set the column name as table Column Key, and then **download**it as Comma-Separated-CSV and import it to the existing Ninja Tables.