All Questions
20
questions
1
vote
2
answers
1k
views
How can I export data without "Save As..."?
I have some data in an xls file. I want to export it to csv. I don't want to save the file as csv, I just want to export it so I don't have to then go back and "Save As..." the original ...
1
vote
0
answers
197
views
Jira -- export tempo timesheet (grid view) to Excel
Jira: How do you export tempo timesheet (grid view) to Excel -- either .csv or an ordinary excel file.
I am using Microsoft Edge browser, and there is no easy link available (such as Export).
I ...
0
votes
1
answer
882
views
How to export/update CSV file through Excel Macro?
Thanks in advance for any help!
I have a file that produces an output table that also contains a unique key for the set of data. I want to be able to export this data into a CSV file.
That is easy ...
0
votes
0
answers
1k
views
Set Custom Path While Exporting in VBA
I am using this post's accepted answer for one my exports.
Based on the answer, it saves my exported .csv file in my C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART.
However, I need this ...
1
vote
0
answers
333
views
Office Excel 2011 for Mac : when exporting an excel sheet to csv, around 25000 empty csv lines get added
so when saving as windows csv and press save i get the actual data:
1,1,2,
then i get around 25'000 lines:
,,,
,,,
,,,
,,,
,,,
,,,
....
when i do the same with libre office i get only the data, no ...
1
vote
0
answers
117
views
Locked between MailChimp and European Windows for CSV export?
I have a CSV export for our application that is being used by end users (not tech-savvy).
For some European regional settings Excel expects a semicolon ; for delimiting (comma is used for decimals).
...
0
votes
0
answers
2k
views
Losing decimal places when exporting to csv
I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus ...
6
votes
4
answers
33k
views
excel: export csv file with japanese character
In my excel file, the Japanese character is shown correctly,
while when I export it as csv,
the character become question marks
How should I output so that the character can be shown correctly?
2
votes
2
answers
24k
views
Removing commas from CSV file
I created an Excel .XLSX file, reformatted the columns from currency to numbers with 2 decimals and no thousands separator, then exported to a .CSV file, then to a .TXT file.
Once I did that, the ...
1
vote
1
answer
1k
views
How to export full data from excel as a csv using macro?
I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data?
Here's my code:
Sub CSVFile()
Dim My_filenumber As Integer
Dim ...
27
votes
2
answers
171k
views
Excel save-as CSV options -- possible to change comma to pipe or tab instead?
Is there a way to tell Excel which delimiter to use when producing a CSV, e.g. tab or pipe?
2
votes
1
answer
3k
views
Reversing Excel's Text Import Wizard for CSV Export
I have a CSV file that I want to import to excel, edit, and save back as CSV.
The problem that I encounter is with Text Import Wizard: I open a new Excel file, then Data > From Text, and in The text ...
5
votes
1
answer
8k
views
How to export Excel with Hindi script to CSV file?
I would like to know how to export an excel spreadsheet which contains, say a table of Hindi(for that matter any non-english) script words into a CSV file? I tried 'Save As' --> comma delimited, but ...
1
vote
1
answer
2k
views
Having formatting problems when exporting table from phpMyAdmin
I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.
...
22
votes
5
answers
38k
views
How do I export only visible cells from Excel to CSV?
I am running Excel 2010. At the top of my spreadsheet I have about 10 hidden rows.
When I export to CSV, how do I export only visible cells?
38
votes
9
answers
207k
views
How to export selected columns into csv file
I want to export specific number of columns from excel into .csv file. I have around 10 columns like lname, fname, phone, address, email and so on. What should I do to export only certain columns like ...
2
votes
3
answers
22k
views
Cyrillic export from Excel to CSV
I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document.
I use Save As » CSV in order to make a CSV file, but it is not ...
20
votes
2
answers
100k
views
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited) file types in excel 2010? They are all listed as a save file type, but ultimately are Comma Separated Value files.
2
votes
1
answer
2k
views
Excel: preserve italics in CSV export?
I'm looking for a way to preserve italicized text when exporting from XLSX to CSV. I know CSV doesn't support styled text, but I'm wondering if anyone knows of a workaround. For instance, does Excel ...
1
vote
1
answer
285
views
Merging cells in Excel 2007 because the web exporter is a punk
I have to use a web site to export data in XLS format, to be converted to CSV, to be dumped into a MySQL database.
My problem is that this POS exporter treats carriage returns in the original data as ...