Short, focused explanations for converting files, fixing formatting issues, and choosing the right spreadsheet format.
How to Convert CSV to Excel Using a Pre-Formatted Template To convert CSV to Excel using a template, build a formatted workbook once — headers, colors, column widths, […]
How to Map CSV Columns to the Right Excel Columns on Import To map CSV columns to the right Excel columns on import, use Power Query: load the […]
How to Keep Special Characters and Symbols When Converting CSV to Excel To keep special characters when converting CSV to Excel, import the file with the correct encoding […]
How to Convert CSV to Excel Automatically with a VBA Macro To convert CSV to Excel automatically with a VBA macro, write a macro that opens the CSV […]
How to Convert CSV to Excel on a Mac (Excel and Numbers) To convert CSV to Excel on a Mac, open the CSV in Excel for Mac with […]
How to Open a Pipe-Delimiter CSV in Excel (Pipe-Separated Files) To open a pipe-delimiter CSV in Excel, import it with Data > From Text/CSV and set the delimiter […]
How to Open a Tab-Delimiter CSV in Excel (TSV Files) To open a tab-delimiter CSV in Excel, use Data > From Text/CSV and set the delimiter to Tab […]
How to Convert CSV to Excel for QuickBooks To convert CSV to Excel for QuickBooks, open the CSV in Excel, shape it into the exact column layout QuickBooks […]
How to Convert CSV to Excel for Mailchimp To convert CSV to Excel for Mailchimp, open the CSV in Excel, clean it up — standard headers, one email […]
How to Convert CSV to Excel With Images To convert CSV to Excel with images, import the CSV into Excel first, then add the pictures in Excel itself […]