Web apps love exporting CSV files, but they don't always play nice with Excel. Leading zeros disappear, dates break, and text fields merge together. Most people waste time fixing these problems ...

The inspiration behind building the appThis happened recently during a board meeting at my company. A department reported that they were manually processing Excel data arriving in numerous ...

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether. We don’t open foreign files with Microsoft Excel—or do we? When importing a .txt or ...

Download a large dataset from just about anywhere and there’s a good chance it’ll available as a CSV file, which you can then open in just about any spreadsheet or database. And if you don’t have ...