How to convert a .CSV (comma-separated variables) database into a .XLS (Excel spreadsheet):
(1) Open Microsoft Excel.
(2) Select 'Data' from the top toolbar.
(3) Select 'Import External Data' and then 'Import Data'.
(4) Select your .CSV file from the file-list.
You should now see your data at the bottom of the 'Text import wizard screen':
(5) The 'Text-import wizard' should already be set to 'delimited'- if it isn't tick that option (Delimited - Characters such as commas or tabs separate each field), then click 'next'.
(6) Step 2 - You now need to specify the database delimiters, as this is a .CSV (comma separated variable) you need to select 'Comma'. And unselect 'Tab'
You should now be able to see your data has been organized into relevant columns.
(7) Click 'next'.
(8) Step 3 - You are now able to select the data format for each column of your database, this should automatically be set to 'General' and unless you have specific format requirements, click 'finish' to proceed.
(9) Finally you must decide whether to import your data into an existing worksheet or to import it into a new worksheet.
If you choose existing worksheet you may then choose where within your existing worksheet to place the data. (this can be done either with the mouse or by entering a range of cells).
If you choose to import into a new worksheet the data will be positioned from cell A1 onwards
(1) Open Microsoft Excel.
(2) Select 'Data' from the top toolbar.
(3) Select 'Import External Data' and then 'Import Data'.
(4) Select your .CSV file from the file-list.
You should now see your data at the bottom of the 'Text import wizard screen':
(5) The 'Text-import wizard' should already be set to 'delimited'- if it isn't tick that option (Delimited - Characters such as commas or tabs separate each field), then click 'next'.
(6) Step 2 - You now need to specify the database delimiters, as this is a .CSV (comma separated variable) you need to select 'Comma'. And unselect 'Tab'
You should now be able to see your data has been organized into relevant columns.
(7) Click 'next'.
(8) Step 3 - You are now able to select the data format for each column of your database, this should automatically be set to 'General' and unless you have specific format requirements, click 'finish' to proceed.
(9) Finally you must decide whether to import your data into an existing worksheet or to import it into a new worksheet.
If you choose existing worksheet you may then choose where within your existing worksheet to place the data. (this can be done either with the mouse or by entering a range of cells).
If you choose to import into a new worksheet the data will be positioned from cell A1 onwards
You should now see your imported .CSV spreadsheet within Excel.
CSV is a great cross-platform portable format.
ReplyDeleteThanks!!!
ReplyDeleteIt worked. Thanks...!!
ReplyDeleteThank you very much for this. Seriously appreciated.
ReplyDelete