{"id":5893,"date":"2001-09-03T12:00:12","date_gmt":"2001-09-03T12:00:12","guid":{"rendered":"http:\/\/www.teoalida.com\/cardatabase\/?p=5893"},"modified":"2025-03-02T13:01:31","modified_gmt":"2025-03-02T13:01:31","slug":"mysql","status":"publish","type":"post","link":"https:\/\/www.teoalida.com\/cardatabase\/mysql\/","title":{"rendered":"File formats: Excel, CSV, SQL, XML, JSON"},"content":{"rendered":"\n
\n

When I started car database project in 2003, I intended them for visualization in Excel, so I made all files colorful and with borders that separate models. But since starting selling in 2012, I realized that most customers import it in their SQL database, so the enhancements for Excel visualization are useless, but they prove how much CARE I spend developing car databases. Over years I optimized Excel files also for machine reading beside reading with human eyes.<\/p>\n\n\n\n

So far most customers told me that providing Excel is sufficient<\/strong> and can be easily converted in other formats if necessary. One customer told me that MySQL and MsSQL are different, others wanted XML or JSON… in the end how many formats I need to provide? CSV and SQL are hard to visualize for checking and updating, so I hope that Excel format is the best compromise.<\/p>\n\n\n\n

Starting from 2015 I provide CSV and SQL by default for small databases<\/strong> (Car Models List, Car Nameplates List, Year-Make-Model) at no extra charges (pay once and receive 3 file formats). I can provide for bigger databases at request.<\/p>\n\n\n\n

Following website redesign in March 2020<\/strong> I made space to put multiple links to sample on homepage so I decided to add CSV and SQL for big databases too<\/strong> if they have good sales volume.<\/p>\n\n\n\n

Anyone can convert XLS to SQL:<\/strong> open .XLS file, do the necessary changes in Excel > save as > choose CSV format > go in your website cPanel or XAMPP > phpMyAdmin > import CSV file. Watch video!<\/strong><\/p>\n\n\n\n