Important: Please read the Qt Code of Conduct -

[Solved] Get errors when exporting data to CSV files

  • I am writing a small application to export data to CSV files. And this is the code that I used

    QString fileName = QFileDialog::getSaveFileName(
    tr("Save As"),
    tr("Comma Separated Values (.csv);;All Files (.*)"));

    if (fileName.isEmpty()) return;
    else {
    QFile file(fileName);
    if (! {
    QMessageBox::information(this, tr("Unable to open file"), file.errorString());

    // Write content to *.csv file
    QTextStream stream(&file);

    // Print header
    stream << "ID\tUsername\tAddress";


    Then I run the application, a dialog appears to save CSV file. But when I open the CSV file that I have just saved, I got 2 following error warnings

    ! 1)!


    ! 2)!

    This is the data in the CSV file

    ! data in CSV file)!

    As you see, I intend to display 3 fields such as ID, Username and Address in 3 columns but all data is in a column.

    Could you explain me that why I got 2 above messages and how can I display each field (ID, Username and Address) in each column?

    Thanks in advance!

    P/S: Currently I am using Microsoft Excel 2013.

  • Step one: Don't be afraid to use a text editor (the really old one) to take a look into the file yourself. You'll see first hand if everything is fine in there, or at least "as intended".

    Step two: When importing a csv-file, you have to give some settings - e.g. the field delimiter, which not necessarily has to be a tab (\t)!

    I think you are just using a bad format here. I would try something like this, because that's how I know it:
    @stream << ""ID";"Username";"Address"";@

  • @thEClaw: Thanks for your help! Now I can solve my issues. I am very happy!

Log in to reply