CSV to SQL converter
Your csv
CREATE TABLE IF NOT EXISTS csv_data (OrderID TEXT, CustomerName TEXT, OrderDate TEXT, TotalAmount TEXT, Status TEXT);
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0001', 'Customer 1', '2024-12-01', '389.02', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0002', 'Customer 2', '2024-11-20', '20.04', 'Pending');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0003', 'Customer 3', '2024-11-27', '498.39', 'Pending');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0004', 'Customer 4', '2024-11-21', '251.87', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0005', 'Customer 5', '2024-11-16', '240.1', 'Completed');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0006', 'Customer 6', '2024-11-23', '43.15', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0007', 'Customer 7', '2024-11-07', '369.8', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0008', 'Customer 8', '2024-11-30', '368.72', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0009', 'Customer 9', '2024-11-10', '246.83', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0010', 'Customer 10', '2024-11-28', '106.9', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0011', 'Customer 11', '2024-12-05', '319.15', 'Pending');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0012', 'Customer 12', '2024-11-16', '168.51', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0013', 'Customer 13', '2024-11-15', '200.49', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0014', 'Customer 14', '2024-11-30', '405.95', 'Pending');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0015', 'Customer 15', '2024-11-25', '425.73', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0016', 'Customer 16', '2024-11-15', '110.33', 'Completed');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0017', 'Customer 17', '2024-11-12', '447.4', 'Cancelled');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0018', 'Customer 18', '2024-11-14', '229.0', 'Pending');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0019', 'Customer 19', '2024-11-30', '180.65', 'Pending');
INSERT INTO csv_data (OrderID, CustomerName, OrderDate, TotalAmount, Status) VALUES ('ORD0020', 'Customer 20', '2024-11-28', '325.33', 'Pending');
See also: