Is it possible to export an excel file to CSV with Excel online?
Is it possible to export an excel file to CSV with Excel online?
I know it is no problem to do it using the desktop but cannot find the equivalent function in the online version.
microsoft-excel
asked Aug 1 '16 at 9:25
JohnJohn
14815
add a comment |
Is it possible to export an excel file to CSV with Excel online?
I know it is no problem to do it using the desktop but cannot find the equivalent function in the online version.
microsoft-excel
asked Aug 1 '16 at 9:25
JohnJohn
14815
I found one online method to convert Excel file to CSV Please try it and hope it works for you. convertio.co/xls-csv
– SolveProblem
Aug 1 '16 at 11:01
for the record I have tried with Google Drive and it did not work because my file is to large to be read in Google Sheets... seems I'll have to install Excel on my machine
– John
Aug 1 '16 at 11:04
You can delete it from there. It's not paid. I tried converting some of my images and it worked. So you can try it.
– SolveProblem
Aug 1 '16 at 11:05
I am providing you offline steps to convert excel to csv : support.office.com/en-us/article/…
– SolveProblem
Aug 1 '16 at 11:08
add a comment |
Is it possible to export an excel file to CSV with Excel online?
I know it is no problem to do it using the desktop but cannot find the equivalent function in the online version.
microsoft-excel
asked Aug 1 '16 at 9:25
JohnJohn
14815
Is it possible to export an excel file to CSV with Excel online?
I know it is no problem to do it using the desktop but cannot find the equivalent function in the online version.
microsoft-excel
microsoft-excel
asked Aug 1 '16 at 9:25
JohnJohn
14815
asked Aug 1 '16 at 9:25
JohnJohn
14815
asked Aug 1 '16 at 9:25
JohnJohn
14815
asked Aug 1 '16 at 9:25
JohnJohn
14815
asked Aug 1 '16 at 9:25
JohnJohn
14815
14815
I found one online method to convert Excel file to CSV Please try it and hope it works for you. convertio.co/xls-csv
– SolveProblem
Aug 1 '16 at 11:01
for the record I have tried with Google Drive and it did not work because my file is to large to be read in Google Sheets... seems I'll have to install Excel on my machine
– John
Aug 1 '16 at 11:04
You can delete it from there. It's not paid. I tried converting some of my images and it worked. So you can try it.
– SolveProblem
Aug 1 '16 at 11:05
I am providing you offline steps to convert excel to csv : support.office.com/en-us/article/…
– SolveProblem
Aug 1 '16 at 11:08
add a comment |
I found one online method to convert Excel file to CSV Please try it and hope it works for you. convertio.co/xls-csv
– SolveProblem
Aug 1 '16 at 11:01
for the record I have tried with Google Drive and it did not work because my file is to large to be read in Google Sheets... seems I'll have to install Excel on my machine
– John
Aug 1 '16 at 11:04
You can delete it from there. It's not paid. I tried converting some of my images and it worked. So you can try it.
– SolveProblem
Aug 1 '16 at 11:05
I am providing you offline steps to convert excel to csv : support.office.com/en-us/article/…
– SolveProblem
Aug 1 '16 at 11:08
I found one online method to convert Excel file to CSV Please try it and hope it works for you. convertio.co/xls-csv
– SolveProblem
Aug 1 '16 at 11:01
I found one online method to convert Excel file to CSV Please try it and hope it works for you. convertio.co/xls-csv
– SolveProblem
Aug 1 '16 at 11:01
for the record I have tried with Google Drive and it did not work because my file is to large to be read in Google Sheets... seems I'll have to install Excel on my machine
– John
Aug 1 '16 at 11:04
for the record I have tried with Google Drive and it did not work because my file is to large to be read in Google Sheets... seems I'll have to install Excel on my machine
– John
Aug 1 '16 at 11:04
You can delete it from there. It's not paid. I tried converting some of my images and it worked. So you can try it.
– SolveProblem
Aug 1 '16 at 11:05
You can delete it from there. It's not paid. I tried converting some of my images and it worked. So you can try it.
– SolveProblem
Aug 1 '16 at 11:05
I am providing you offline steps to convert excel to csv : support.office.com/en-us/article/…
– SolveProblem
Aug 1 '16 at 11:08
I am providing you offline steps to convert excel to csv : support.office.com/en-us/article/…
– SolveProblem
Aug 1 '16 at 11:08
add a comment |
3 Answers
3
active
oldest
votes
To answer and close this question:
Check Office Help https://support.office.com/en-us/article/Differences-between-using-a-workbook-in-the-browser-and-in-Excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6:
"Workbooks in other formats, such as .csv format, are generally not supported in Excel Online."
Looks like there is no way around an offline conversion.
answered Mar 1 '18 at 11:09
almsalms
1265
add a comment |
I teach college and one of the assignments I give to student in exploring files and structure is to output a spreadsheet I supply as .xls as a .csv file, then examine how the conversion process surrounds data containing commas with quotation marks so as not to confuse the "data" commas from the data delimiting commas. A student ran into this same problem and claimed that he couldn't do the assignment since he used the online version of Excel. In my case the "cure" was simple--the course is designed to also explore free alternative software and an upcoming assignment is to download and install LibreOffice from www.libreoffice.com and try it out, comparing it to MS-Office. I suggest that you do the same. The LibreOffice "Calc" spreadsheet program is quite capable and easily converts a spreadsheet to .csv format with a "save as." LibreOffice is available free for Windows PC and Macs.
answered Apr 19 '18 at 6:03
user896580user896580
211
add a comment |
Although it is not possible directly, the answer is
Yes, by semi-manual process, using the clipboard and plain text editor.
Follow these steps:
- Select a range to export in Excel online.
- Press Ctrl+C to copy it into the clipboard.
- Paste clipboard content into Notepad++ editor.
- Press Ctrl+H to open Replace window
- Replace all
"with""in Extended mode (if none were present, 0 replacements is OK). - Replace all
twith","in Extended mode. - Replace all
rnwith"rn"in Extended mode. - Add
"to start of the file. - Add
"to end of the file. - Save your result with csv extension.
Your CSV file is now ready.
Explanation:
- Steps 1-3 produce TSV content (Tab-separated values) in text editor.
- Step 5 doubles any double quotes (
") in the content because""is their valid expression in CSV file. - Steps 6-9 surround the values by quotes and separate them by commas instead of tabs.
answered Apr 19 '18 at 6:49
miroxlavmiroxlav
7,40352569
This is rather Windows-centric, but the basics work the same on other platforms. I was able to copy/paste an Excel sheet into Emacs on a Mac and ended up with tab-delimited data. This is already valid TSV, though if you want to save as CSV, obviouslys/"/""/g;s/(^|$)/"/g;s/t/","/gwith further requirements if the data contains multi-line fields as verbosely instructed (but not really explained) in this answer.
– tripleee
Jan 3 at 7:53
@tripleee – Thank you for the comment, I added the explanation. I believe the steps are quite readable for most standard editors (hopefully even on Macintosh). For my understanding of Emacs (user base of which is coming from old mainframe computers) Emacs part is not needed in the answer because any such user is proficient enough to do the conversion right away instead of searching the internet. :) But maybe short awk script can be more useful outside Windows platform to shift depenency from Emacs to standard tool.
– miroxlav
Jan 3 at 15:42
You don't need a mainframe to appreciate a decent editor, but this should work fine for any editor. There are existing tools for converting TSV to CSV so just the copy/paste and save really needs to be manual.
– tripleee
Jan 3 at 15:52
Perhaps I should add that just cmd-C didn't work, I had to pay tribute to Microsoft's bold and intelligent UI designers by clicking open the Home tab on the top bar abomination and find the symbol which represents "copy" (it's an icon with like two documents on top of each other).
– tripleee
Jan 4 at 7:04
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1107315%2fis-it-possible-to-export-an-excel-file-to-csv-with-excel-online%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
To answer and close this question:
Check Office Help https://support.office.com/en-us/article/Differences-between-using-a-workbook-in-the-browser-and-in-Excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6:
"Workbooks in other formats, such as .csv format, are generally not supported in Excel Online."
Looks like there is no way around an offline conversion.
answered Mar 1 '18 at 11:09
almsalms
1265
add a comment |
To answer and close this question:
Check Office Help https://support.office.com/en-us/article/Differences-between-using-a-workbook-in-the-browser-and-in-Excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6:
"Workbooks in other formats, such as .csv format, are generally not supported in Excel Online."
Looks like there is no way around an offline conversion.
answered Mar 1 '18 at 11:09
almsalms
1265
add a comment |
To answer and close this question:
Check Office Help https://support.office.com/en-us/article/Differences-between-using-a-workbook-in-the-browser-and-in-Excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6:
"Workbooks in other formats, such as .csv format, are generally not supported in Excel Online."
Looks like there is no way around an offline conversion.
answered Mar 1 '18 at 11:09
almsalms
1265
To answer and close this question:
Check Office Help https://support.office.com/en-us/article/Differences-between-using-a-workbook-in-the-browser-and-in-Excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6:
"Workbooks in other formats, such as .csv format, are generally not supported in Excel Online."
Looks like there is no way around an offline conversion.
answered Mar 1 '18 at 11:09
almsalms
1265
answered Mar 1 '18 at 11:09
almsalms
1265
answered Mar 1 '18 at 11:09
almsalms
1265
answered Mar 1 '18 at 11:09
almsalms
1265
1265
add a comment |
add a comment |
I teach college and one of the assignments I give to student in exploring files and structure is to output a spreadsheet I supply as .xls as a .csv file, then examine how the conversion process surrounds data containing commas with quotation marks so as not to confuse the "data" commas from the data delimiting commas. A student ran into this same problem and claimed that he couldn't do the assignment since he used the online version of Excel. In my case the "cure" was simple--the course is designed to also explore free alternative software and an upcoming assignment is to download and install LibreOffice from www.libreoffice.com and try it out, comparing it to MS-Office. I suggest that you do the same. The LibreOffice "Calc" spreadsheet program is quite capable and easily converts a spreadsheet to .csv format with a "save as." LibreOffice is available free for Windows PC and Macs.
answered Apr 19 '18 at 6:03
user896580user896580
211
add a comment |
I teach college and one of the assignments I give to student in exploring files and structure is to output a spreadsheet I supply as .xls as a .csv file, then examine how the conversion process surrounds data containing commas with quotation marks so as not to confuse the "data" commas from the data delimiting commas. A student ran into this same problem and claimed that he couldn't do the assignment since he used the online version of Excel. In my case the "cure" was simple--the course is designed to also explore free alternative software and an upcoming assignment is to download and install LibreOffice from www.libreoffice.com and try it out, comparing it to MS-Office. I suggest that you do the same. The LibreOffice "Calc" spreadsheet program is quite capable and easily converts a spreadsheet to .csv format with a "save as." LibreOffice is available free for Windows PC and Macs.
answered Apr 19 '18 at 6:03
user896580user896580
211
add a comment |
I teach college and one of the assignments I give to student in exploring files and structure is to output a spreadsheet I supply as .xls as a .csv file, then examine how the conversion process surrounds data containing commas with quotation marks so as not to confuse the "data" commas from the data delimiting commas. A student ran into this same problem and claimed that he couldn't do the assignment since he used the online version of Excel. In my case the "cure" was simple--the course is designed to also explore free alternative software and an upcoming assignment is to download and install LibreOffice from www.libreoffice.com and try it out, comparing it to MS-Office. I suggest that you do the same. The LibreOffice "Calc" spreadsheet program is quite capable and easily converts a spreadsheet to .csv format with a "save as." LibreOffice is available free for Windows PC and Macs.
answered Apr 19 '18 at 6:03
user896580user896580
211
I teach college and one of the assignments I give to student in exploring files and structure is to output a spreadsheet I supply as .xls as a .csv file, then examine how the conversion process surrounds data containing commas with quotation marks so as not to confuse the "data" commas from the data delimiting commas. A student ran into this same problem and claimed that he couldn't do the assignment since he used the online version of Excel. In my case the "cure" was simple--the course is designed to also explore free alternative software and an upcoming assignment is to download and install LibreOffice from www.libreoffice.com and try it out, comparing it to MS-Office. I suggest that you do the same. The LibreOffice "Calc" spreadsheet program is quite capable and easily converts a spreadsheet to .csv format with a "save as." LibreOffice is available free for Windows PC and Macs.
answered Apr 19 '18 at 6:03
user896580user896580
211
answered Apr 19 '18 at 6:03
user896580user896580
211
answered Apr 19 '18 at 6:03
user896580user896580
211
answered Apr 19 '18 at 6:03
user896580user896580
211
211
add a comment |
add a comment |
Although it is not possible directly, the answer is
Yes, by semi-manual process, using the clipboard and plain text editor.
Follow these steps:
- Select a range to export in Excel online.
- Press Ctrl+C to copy it into the clipboard.
- Paste clipboard content into Notepad++ editor.
- Press Ctrl+H to open Replace window
- Replace all
"with""in Extended mode (if none were present, 0 replacements is OK). - Replace all
twith","in Extended mode. - Replace all
rnwith"rn"in Extended mode. - Add
"to start of the file. - Add
"to end of the file. - Save your result with csv extension.
Your CSV file is now ready.
Explanation:
- Steps 1-3 produce TSV content (Tab-separated values) in text editor.
- Step 5 doubles any double quotes (
") in the content because""is their valid expression in CSV file. - Steps 6-9 surround the values by quotes and separate them by commas instead of tabs.
answered Apr 19 '18 at 6:49
miroxlavmiroxlav
7,40352569
This is rather Windows-centric, but the basics work the same on other platforms. I was able to copy/paste an Excel sheet into Emacs on a Mac and ended up with tab-delimited data. This is already valid TSV, though if you want to save as CSV, obviouslys/"/""/g;s/(^|$)/"/g;s/t/","/gwith further requirements if the data contains multi-line fields as verbosely instructed (but not really explained) in this answer.
– tripleee
Jan 3 at 7:53
@tripleee – Thank you for the comment, I added the explanation. I believe the steps are quite readable for most standard editors (hopefully even on Macintosh). For my understanding of Emacs (user base of which is coming from old mainframe computers) Emacs part is not needed in the answer because any such user is proficient enough to do the conversion right away instead of searching the internet. :) But maybe short awk script can be more useful outside Windows platform to shift depenency from Emacs to standard tool.
– miroxlav
Jan 3 at 15:42
You don't need a mainframe to appreciate a decent editor, but this should work fine for any editor. There are existing tools for converting TSV to CSV so just the copy/paste and save really needs to be manual.
– tripleee
Jan 3 at 15:52
Perhaps I should add that just cmd-C didn't work, I had to pay tribute to Microsoft's bold and intelligent UI designers by clicking open the Home tab on the top bar abomination and find the symbol which represents "copy" (it's an icon with like two documents on top of each other).
– tripleee
Jan 4 at 7:04
add a comment |
Although it is not possible directly, the answer is
Yes, by semi-manual process, using the clipboard and plain text editor.
Follow these steps:
- Select a range to export in Excel online.
- Press Ctrl+C to copy it into the clipboard.
- Paste clipboard content into Notepad++ editor.
- Press Ctrl+H to open Replace window
- Replace all
"with""in Extended mode (if none were present, 0 replacements is OK). - Replace all
twith","in Extended mode. - Replace all
rnwith"rn"in Extended mode. - Add
"to start of the file. - Add
"to end of the file. - Save your result with csv extension.
Your CSV file is now ready.
Explanation:
- Steps 1-3 produce TSV content (Tab-separated values) in text editor.
- Step 5 doubles any double quotes (
") in the content because""is their valid expression in CSV file. - Steps 6-9 surround the values by quotes and separate them by commas instead of tabs.
answered Apr 19 '18 at 6:49
miroxlavmiroxlav
7,40352569
This is rather Windows-centric, but the basics work the same on other platforms. I was able to copy/paste an Excel sheet into Emacs on a Mac and ended up with tab-delimited data. This is already valid TSV, though if you want to save as CSV, obviouslys/"/""/g;s/(^|$)/"/g;s/t/","/gwith further requirements if the data contains multi-line fields as verbosely instructed (but not really explained) in this answer.
– tripleee
Jan 3 at 7:53
@tripleee – Thank you for the comment, I added the explanation. I believe the steps are quite readable for most standard editors (hopefully even on Macintosh). For my understanding of Emacs (user base of which is coming from old mainframe computers) Emacs part is not needed in the answer because any such user is proficient enough to do the conversion right away instead of searching the internet. :) But maybe short awk script can be more useful outside Windows platform to shift depenency from Emacs to standard tool.
– miroxlav
Jan 3 at 15:42
You don't need a mainframe to appreciate a decent editor, but this should work fine for any editor. There are existing tools for converting TSV to CSV so just the copy/paste and save really needs to be manual.
– tripleee
Jan 3 at 15:52
Perhaps I should add that just cmd-C didn't work, I had to pay tribute to Microsoft's bold and intelligent UI designers by clicking open the Home tab on the top bar abomination and find the symbol which represents "copy" (it's an icon with like two documents on top of each other).
– tripleee
Jan 4 at 7:04
add a comment |
Although it is not possible directly, the answer is
Yes, by semi-manual process, using the clipboard and plain text editor.
Follow these steps:
- Select a range to export in Excel online.
- Press Ctrl+C to copy it into the clipboard.
- Paste clipboard content into Notepad++ editor.
- Press Ctrl+H to open Replace window
- Replace all
"with""in Extended mode (if none were present, 0 replacements is OK). - Replace all
twith","in Extended mode. - Replace all
rnwith"rn"in Extended mode. - Add
"to start of the file. - Add
"to end of the file. - Save your result with csv extension.
Your CSV file is now ready.
Explanation:
- Steps 1-3 produce TSV content (Tab-separated values) in text editor.
- Step 5 doubles any double quotes (
") in the content because""is their valid expression in CSV file. - Steps 6-9 surround the values by quotes and separate them by commas instead of tabs.
answered Apr 19 '18 at 6:49
miroxlavmiroxlav
7,40352569
Although it is not possible directly, the answer is
Yes, by semi-manual process, using the clipboard and plain text editor.
Follow these steps:
- Select a range to export in Excel online.
- Press Ctrl+C to copy it into the clipboard.
- Paste clipboard content into Notepad++ editor.
- Press Ctrl+H to open Replace window
- Replace all
"with""in Extended mode (if none were present, 0 replacements is OK). - Replace all
twith","in Extended mode. - Replace all
rnwith"rn"in Extended mode. - Add
"to start of the file. - Add
"to end of the file. - Save your result with csv extension.
Your CSV file is now ready.
Explanation:
- Steps 1-3 produce TSV content (Tab-separated values) in text editor.
- Step 5 doubles any double quotes (
") in the content because""is their valid expression in CSV file. - Steps 6-9 surround the values by quotes and separate them by commas instead of tabs.
answered Apr 19 '18 at 6:49
miroxlavmiroxlav
7,40352569
edited Jan 3 at 15:43
answered Apr 19 '18 at 6:49
miroxlavmiroxlav
7,40352569
answered Apr 19 '18 at 6:49
miroxlavmiroxlav
7,40352569
answered Apr 19 '18 at 6:49
miroxlavmiroxlav
7,40352569
7,40352569
This is rather Windows-centric, but the basics work the same on other platforms. I was able to copy/paste an Excel sheet into Emacs on a Mac and ended up with tab-delimited data. This is already valid TSV, though if you want to save as CSV, obviouslys/"/""/g;s/(^|$)/"/g;s/t/","/gwith further requirements if the data contains multi-line fields as verbosely instructed (but not really explained) in this answer.
– tripleee
Jan 3 at 7:53
@tripleee – Thank you for the comment, I added the explanation. I believe the steps are quite readable for most standard editors (hopefully even on Macintosh). For my understanding of Emacs (user base of which is coming from old mainframe computers) Emacs part is not needed in the answer because any such user is proficient enough to do the conversion right away instead of searching the internet. :) But maybe short awk script can be more useful outside Windows platform to shift depenency from Emacs to standard tool.
– miroxlav
Jan 3 at 15:42
You don't need a mainframe to appreciate a decent editor, but this should work fine for any editor. There are existing tools for converting TSV to CSV so just the copy/paste and save really needs to be manual.
– tripleee
Jan 3 at 15:52
Perhaps I should add that just cmd-C didn't work, I had to pay tribute to Microsoft's bold and intelligent UI designers by clicking open the Home tab on the top bar abomination and find the symbol which represents "copy" (it's an icon with like two documents on top of each other).
– tripleee
Jan 4 at 7:04
add a comment |
This is rather Windows-centric, but the basics work the same on other platforms. I was able to copy/paste an Excel sheet into Emacs on a Mac and ended up with tab-delimited data. This is already valid TSV, though if you want to save as CSV, obviouslys/"/""/g;s/(^|$)/"/g;s/t/","/gwith further requirements if the data contains multi-line fields as verbosely instructed (but not really explained) in this answer.
– tripleee
Jan 3 at 7:53
@tripleee – Thank you for the comment, I added the explanation. I believe the steps are quite readable for most standard editors (hopefully even on Macintosh). For my understanding of Emacs (user base of which is coming from old mainframe computers) Emacs part is not needed in the answer because any such user is proficient enough to do the conversion right away instead of searching the internet. :) But maybe short awk script can be more useful outside Windows platform to shift depenency from Emacs to standard tool.
– miroxlav
Jan 3 at 15:42
You don't need a mainframe to appreciate a decent editor, but this should work fine for any editor. There are existing tools for converting TSV to CSV so just the copy/paste and save really needs to be manual.
– tripleee
Jan 3 at 15:52
Perhaps I should add that just cmd-C didn't work, I had to pay tribute to Microsoft's bold and intelligent UI designers by clicking open the Home tab on the top bar abomination and find the symbol which represents "copy" (it's an icon with like two documents on top of each other).
– tripleee
Jan 4 at 7:04
This is rather Windows-centric, but the basics work the same on other platforms. I was able to copy/paste an Excel sheet into Emacs on a Mac and ended up with tab-delimited data. This is already valid TSV, though if you want to save as CSV, obviously
s/"/""/g;s/(^|$)/"/g;s/t/","/g with further requirements if the data contains multi-line fields as verbosely instructed (but not really explained) in this answer.– tripleee
Jan 3 at 7:53
This is rather Windows-centric, but the basics work the same on other platforms. I was able to copy/paste an Excel sheet into Emacs on a Mac and ended up with tab-delimited data. This is already valid TSV, though if you want to save as CSV, obviously
s/"/""/g;s/(^|$)/"/g;s/t/","/g with further requirements if the data contains multi-line fields as verbosely instructed (but not really explained) in this answer.– tripleee
Jan 3 at 7:53
@tripleee – Thank you for the comment, I added the explanation. I believe the steps are quite readable for most standard editors (hopefully even on Macintosh). For my understanding of Emacs (user base of which is coming from old mainframe computers) Emacs part is not needed in the answer because any such user is proficient enough to do the conversion right away instead of searching the internet. :) But maybe short awk script can be more useful outside Windows platform to shift depenency from Emacs to standard tool.
– miroxlav
Jan 3 at 15:42
@tripleee – Thank you for the comment, I added the explanation. I believe the steps are quite readable for most standard editors (hopefully even on Macintosh). For my understanding of Emacs (user base of which is coming from old mainframe computers) Emacs part is not needed in the answer because any such user is proficient enough to do the conversion right away instead of searching the internet. :) But maybe short awk script can be more useful outside Windows platform to shift depenency from Emacs to standard tool.
– miroxlav
Jan 3 at 15:42
You don't need a mainframe to appreciate a decent editor, but this should work fine for any editor. There are existing tools for converting TSV to CSV so just the copy/paste and save really needs to be manual.
– tripleee
Jan 3 at 15:52
You don't need a mainframe to appreciate a decent editor, but this should work fine for any editor. There are existing tools for converting TSV to CSV so just the copy/paste and save really needs to be manual.
– tripleee
Jan 3 at 15:52
Perhaps I should add that just cmd-C didn't work, I had to pay tribute to Microsoft's bold and intelligent UI designers by clicking open the Home tab on the top bar abomination and find the symbol which represents "copy" (it's an icon with like two documents on top of each other).
– tripleee
Jan 4 at 7:04
Perhaps I should add that just cmd-C didn't work, I had to pay tribute to Microsoft's bold and intelligent UI designers by clicking open the Home tab on the top bar abomination and find the symbol which represents "copy" (it's an icon with like two documents on top of each other).
– tripleee
Jan 4 at 7:04
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1107315%2fis-it-possible-to-export-an-excel-file-to-csv-with-excel-online%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I found one online method to convert Excel file to CSV Please try it and hope it works for you. convertio.co/xls-csv
– SolveProblem
Aug 1 '16 at 11:01
for the record I have tried with Google Drive and it did not work because my file is to large to be read in Google Sheets... seems I'll have to install Excel on my machine
– John
Aug 1 '16 at 11:04
You can delete it from there. It's not paid. I tried converting some of my images and it worked. So you can try it.
– SolveProblem
Aug 1 '16 at 11:05
I am providing you offline steps to convert excel to csv : support.office.com/en-us/article/…
– SolveProblem
Aug 1 '16 at 11:08