We have released CSV Import+Export, a simple tool for importing CSV data into Excel and for exporting an Excel worksheet to CSV.
CSV Import+Export is able to import CSV data to a worksheet using a user-specified encoding, delimiter, and newline sequence. It can also export a worksheet to CSV with those configurable options. Although Excel can natively import CSV files, it cannot export using custom formats, so CSV Import+Export fills in this missing feature.
To download CSV Import+Export for free on Excel 2016+ and Excel Online, click “Get It Now” on our AppSource page: https://appsource.microsoft.com/en-us/product/office/WA200000025.
- Open Excel and go to Insert | My Add-ins (or Office Add-ins)
- Under the Store tab, search for “CSV Import+Export” and click the Add button
We hope this tool will help with CSV-Excel workflows. Feel free to comment to this post with any feedback or questions about this add-in.