8.1 Adding and Managing CSV Data

To add and manage CSV data in AI2SQL using the copy-paste method, follow the steps outlined in the checklist below:

  1. Navigate to the "Query CSV" section: Access the "Query CSV" section from the main menu of the AI2SQL platform.

  2. Paste CSV data: Click the "Paste CSV Data" button and paste your CSV data into the provided input field. Click "Upload" to add the data to your AI2SQL account.

  3. Review the imported CSV data: After importing your CSV data, AI2SQL will display a preview of the data. Carefully review the data to ensure that it has been correctly processed.

  4. Rename columns: If necessary, you can rename the columns of your CSV data. Click the column header and edit the name as needed.

  5. Save changes: Save your changes by clicking the "Save" button. This will ensure that your imported CSV data is ready to be queried.

  6. Query the CSV data: Once you have added and configured your CSV data, you can use AI2SQL's natural language querying capabilities to ask questions about the data, just like you would with a database table.

Note: If you encounter any issues or need further assistance, please don't hesitate to contact our support team support@ai2sql.io. We are here to help and ensure that you have the best experience using AI2SQL.

Last updated