When you save the file, select "Save as type," but then choose "All Files" and type ".csv" at the end of the file name. This tells your computer how to read the file and avoids Notepad ...

To give you an example, let's suppose that I wanted to create a table containing the name, description and vendor (company) associated with each process that I read in from the .CSV file.

From the drop-down box, choose "QBO" as the file format to save the document in, then type a name for the new file and click "Save." The CSV file is converted into the QuickBooks QBO format.

Image: GettyImages/Edwin Tan What you’ll need How to install csvkit sudo apt-get install csvkit -y How to convert an XLS file to CSV in2csv clients.xlsx > clients.csv less clients.csv Our CSV ...