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 ...
- 5,183
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 ...
- 243
0
votes
1
answer
879
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 ...
- 1
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 ...
- 101
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 ...
- 347
1
vote
0
answers
116
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).
...
- 1,531
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 ...
- 33
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?
- 165
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 ...
- 11
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?
- 871
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 ...
- 23
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 ...
- 51
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.
...
- 797
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?
- 221