OBINTUSACADEMY
HOME CONTACT SERVICES PRIVACY
COMPUTER BASICS MS-PACKAGES
Excel - How To Convert Excel To CSV

MICROSOFT EXCEL

MODULE ONE

Prerequisite Introduction to Microsoft Excel Getting Started MS Excel Environment Title Bar Quick Access Toolbar Search Account Name Buttons Menu Tab Ribbons Dialog Box Launcher Name Box Insert Function Formula Bar Worksheet Area Worksheet Navigation Creating New Sheet Status Bar Worksheet View Format Zoom Slider MS Excel File Tab Entering Data Saving Your Workbook Opening Saved Workbook Copy, Delete and Hiding Sheet Closing Entire Workbook

MODULE TWO

Cells, Rows and Columns Resizing Rows and Columns Inserting Data Select, Delete and Move Data Copy, Paste and Cut Find and Replace Checking Spellings Inserting TextBox Inserting Symbols Inserting Special Characters Zooming Undoing and Redoing Changes

MODULE THREE

Mini Toolbar Setting Fonts Text Decoration Setting Text Case Text Alignments Text Orientation Increase and Decrease Indentation Wraping Text Merging Cells Cells Borders Cells Shades Copy Formatting Insert and Delete Worksheet Format Worksheet, Cells, Rows and Columns

MODULE FOUR

Insert Tables Insert Pictures Insert Shapes and Smart Art Insert Screenshots Insert Icons Insert 3D-Models Using Add-ins Insert Charts 3D Maps Creating Sparklines Insert WordArt

MODULE FIVE

Addition Subtraction Multiplication Division Using Formulas Using Functions Quick Functions

MODULE SIX

Fill Handling Sorting Filtering References (Relative and Absolute) Conditional Formatting Applying Styles

MODULE SEVEN

Page Themes Page Colors Page Fonts Page Effects Page Header and Footer Page Numbering Page Margins Page Orientation and Size Print Area Page Breaks Setting Background Print Titles Preview and Print Share Workbook Freezing Panes Range Data Validation Excel Templates MS Excel Shortcuts Conclusion

HOW TO

Excel How-To Send Email Separate Text Date and Time Format Macro Thesaurus Insert Comments Password Workbook Count Characters Count Words Add and Remove Hyperlinks Insert PDF in Excel Editing and Formatting Restrictions How to Compare Columns How to Compare Worksheets Add Signature in Worksheet Calculate Age Calculate Mean Calculate Median Calculate Standard Deviation Find the Mode Add and Remove Commas How to Remove Filter Convert Excel to CSV Excel to PDF Excel to Ms-Word Document Excel to Picture Formats Duplicate Rows and Columns Hide and Unhide Rows and Columns Rows and Columns Conversion How to Remove Gridlines Create Graphs Insert Check Box Add and Remove Watermark Logical Operators Logical Functions Text Functions Square Symbol Pi Symbol Selecting Different Columns Creating QR Code Creating Bar Code Insert Bullet Points Generate Random Numbers Combine Two Columns Wrap Text Create Dropdown List

How To Convert Excel To CSV

PREVIOUS NEXT

In this tutorial I am going to be showing you step by step on how you can convert an excel worksheet file to a csv file. CSV file stands for Comma Separated Values file. This type of file format is used for various individual and organizational purposes.

  • CONVERTING EXCEL TO CSV
  • Step 1 - Go to where the excel file you want to covert to csv file is located on your computer system. Click on it and from the options displayed click on Open to open the worksheet
    • csv
  • Step 2 - Now, in the image below this is the file I will be converting to csv file. You can get any csv file follow up with this tutorial. But if you don't have any, just continue and see how it is done.
    • csv
  • Step 3 - Now click on the File tab, which will open the home window. Click on Save As option from the first column option. Then in the second column, click the Browse button.
    • csv
  • Step 4 - Excel will open your file explorer save as section. Now click on the Save as type selection box.
    • csv
  • Step 5 - A list of different file option types will be displayed. Note that there are three CSV file type in the list of options. Just click on the first one from the top. CSV - UTF-8 (Comma delimited) (*.csv)
    • csv
  • Step 6 - The file format in the Save as Type selection field will be changed. Now click on the Save button to successfully save the file as CSV.
    • csv
  • Step 7 - You will tile notice just below the ribbon, giving you a quick prompt of possible data loss. Just click on the close icon as shown in the image below.
    • csv
  • Step 8 - Notice that the file name in the title bar no longer carries the extension name of the normal excel file, but its now .csv
    • csv
  • Step 9 - Now if you go to your computer system where both files are saved, you will clearly see the difference between a csv file and a normal excel file worksheet thumbnail as shown in the image below.
    • csv

Alright, so now we have known how to convert excel file to csv file. What if we want to convert the csv file back to excel normal file format, how do we do this?

  • CONVERTING CSV TO EXCEL
  • Step 1 - Go to where the excel file you want to covert from csv to excel file is located on your computer system. Select the file. Right click on the file and from the list of options displayed go to Open With option. From the sub-list of options displayed, click on the Excel.
    • csv
  • Step 2 - Now your csv file will be opened in Excel as shown in the image below.
    • csv
  • Step 3 - Now click on the File tab, which will open the home window. Click on Save As option from the first column option. Then in the second column, click the Browse button.
    • csv
  • Step 4 - Excel will open your file explorer save as section. Now click on the Save as type selection box where the file format name is shown.
    • csv
  • Step 5 - A list of different file option types will be displayed. Click on the first option which is Excel Workbook (*.xlsx)
    • csv
  • Step 6 - The file format in the Save as Type selection field will be changed. Now click on the Save button to successfully save the file in normal excel format.
    • csv
  • Step 7 - After saving, now if you look at the file name in the title bar, it now changes to the normal excel format.
    • csv
  • Step 8 - Go to your computer system where both files are saved, you will clearly see the difference between a normal Excel file and a csv file thumbnail as shown in the image below.
    • csv
PREVIOUS NEXT
ADVERTISEMENTS

LEARNING IS A CONTINOUS PROCESS - PRACTICE MAKES PERFECT