Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

learn more… | top users | synonyms (1)

0
votes
1answer
610 views

Automatically format cells as currency from .CSV when importing into Excel

When I import a .CSV file into Excel, how do I get all cells which contain a number to be formatted as currency? Currently, if the value for the cell contains the dollar sign ($), it becomes formatted ...
0
votes
1answer
41 views

Is there a way to update automatically a worksheet based on a link which provided a file for download

I have created a web app which allows the user to download a csv file just by copying the link into a browser. Afterwards the user can open this file with excel. Because the csv file might change ...
0
votes
2answers
3k views

Removing Line Breaks From CSV for Proper Excel Import

So I've created a batch script that outputs some text to a CSV. When I open the CSV in Notepad, it looks like this, which is how I want it. 173030,8,2793,2821244 173032,1,2793,2820692 173033,1,2793,...
1
vote
2answers
1k views

How to prevent Excel to round a number at opening? [duplicate]

I have a question regarding Excel. We generate automatically a CSV file everyday, containing stuff looking like : column1;column2;...;columnx text;date;text;249316479917397279 The issue is that the ...
0
votes
2answers
61 views

How does libreoffice express a linebreak when saving a csv?

I’m attempting to save a CSV using LibreOffice Calc to be imported to a MySQL database. Saving it as a CSV is pretty straightforward in LibreOffice but I don’t know how the resulting document ...
0
votes
1answer
441 views

Parse csv file and for each object set as a variable

What I'm trying to do is parse a csv file that has server names and ipaddresses and assign these to variables I then run commands using each set of variables. So if the cvs file, test.csv, looks like ...
0
votes
1answer
103 views

How to add double quotes around data in tables using Calc

I am trying to load my data into a CRM, but am having a lot of trouble. The data simply wont load at the same time, but all the files work fine individually. Support advised that I make sure I'm using ...
2
votes
1answer
2k views

How do I suppress the “file format and extension of MyFile.csv” do not match."?

I'm opening a lot of csv files using Excel recently and am repeatedly receiving the warning:- The file format and extension of MyFile.csv do not match. The file could be corrupted or unsafe. ...
0
votes
2answers
37 views

need help in editing data in csv file

I am in need of editing the date data in csv. I will explain with an example. I am using WPS presentation software for reading and editing csv files. If the above is not possible in that, i can ...
1
vote
0answers
274 views

MySQL csv excel greek characters

I developed an application using Bottle web framework and Python, to import some data into MySQL database. Most of the data where in Greek characters. On my application side, i didn't any further ...
1
vote
1answer
479 views

WMIC |more has extra rows when .csv opened in Excel

I am trying to output the name and version of each program installed on my system to a .csv file. I could do something more complicated with VBScript, but would prefer to keep this very simple to ...
2
votes
1answer
74 views

LibreOffice Calc/Spreadsheet – Delete unusual characters from cells so that I can export a valid CSV file

I received a spreadsheet for work and it has cells that are full of line breaks and excessive whitespace. Unfortunately, I need to export the spreadsheet to CSV format and these two are breaking the ...
0
votes
0answers
99 views

Anki fails to import from .csv file

I have created an custom note type containing 3 fields: Character, Pinyin and Definition. I have a .csv file containing a few entries. The fields are comma-delimited. Here's what I am presented when ...
1
vote
0answers
13 views

Undoing excel default / automatic delimiting [duplicate]

I have a large data export that is going through the end user for spot-checking. The data was formatted with tab delimiter, as it contains a lot of prices and measurements containing commas. The ...
0
votes
1answer
58 views

Have a very large fixed width .txt file, have column widths for the records to guide me, and need .CSV out of it [closed]

The text file is a tax roll off the tax assessor website, and it is 2.63 GB. Every program that I have tried, including UltraEdit, Convert XLS, didn't find anything helpful in excel because we're ...
1
vote
0answers
154 views

Properly extracting from an array

I have a CSV with one column, numbers formatted as 111-0000, that I'm reading in to process one at a time. I'm trying to import the column of information from the CSV, but I'm having trouble figuring ...
0
votes
1answer
854 views

Automate spreadsheet (Excel/CSV) workflow

I'm looking for a tool or process to help automate repetitive workflow tasks that require with an Excel or CSV file to be in a specific format. For example, we work with vendors that send us a list ...
2
votes
1answer
203 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
1
vote
2answers
468 views

Why doesn't my Python script save the file when I use Task Scheduler?

I have a Python script that uses csv.writer to create a csv file. This works fine when I run it from the command line, but no file is created when I run the script using Windows Task Scheduler. The ...
0
votes
1answer
105 views

Remove a specific string common in multiple lines in a CSV file using shell script

I have a CSV file which contains 65000 lines (size approximately 28 MB). On each of the lines they have a path in the beginning in the format of: c:\abc\bcd\def\123\456. Now let's say the path c:\abc\...
1
vote
1answer
92 views

Windows Batch to read TXT and parse lines to CSV

I've made a good deal of headway by searching this site and learning the ridiculous language that is Windows batch scripting, but frankly I'm stuck. The sample below is from our lab's old radiometer ...
0
votes
0answers
95 views

Create Xbox Music Playlist from excel list (csv)

I created a few playlists in Excel (just the artist & song title) that I wanted to Import into Xbox Music. Unfortunately the only way I could find was to search for each song indivdually and then ...
0
votes
1answer
145 views

Mail Merge comparison between fields

I have a meeting merge document which is populated from a CSV file with data entered online from a facilitator. I am unable to work out how to do multiple conditions, there are a maximum of 10 clients ...
1
vote
1answer
82 views

csv file formatting issue in excel

I have a csv file when opened in notepad looks like this: sep=, ProgramXX, PXXXXX, .... IDXXXXX, XYZXXXXX, .... This should open well formatted as csv file in excel program but what I see is this: ...
0
votes
0answers
48 views

Export specific results of Access 2010 query determined by checkbox

I am working on a planning tool which provides information about how long particular tasks should take. Everything was working as expected but I have just been informed that the user would like to ...
0
votes
0answers
13 views

Styling multiple files on Libre Office Calc [duplicate]

Here's what I do now: Get CSV file from extrenal source Open it in Calc Apply style (set colors, fonts, etc.) Export as PDF Is it possible to get rid of step 3? Somehow loading data to already ...
0
votes
2answers
176 views

PowerQuery to parse fixed width csv

I have fixed width csv.txt, e.g. Martin Junger 12 John Wing 124 To load it with PowerQuery this syntax is used: let Source = Csv.Document(File.Contents("C:\csv.txt"),null,";...
1
vote
0answers
277 views

Excel 2010 - Merge multiple connections into single worksheet

I have an Excel workbook containing several worksheets. Each worksheet has an external connection to a unique .csv file that is updated several times a day from different PCs. This is done so that ...
1
vote
1answer
81 views

Right click a csv file to read in RStudio?

I would like the ability to right click on a .csv file and read it in RStudio (an IDE for the statistical language R). When I say "read it in RStudio" I mean open up RStudio with the line dat<-read....
0
votes
2answers
2k views

Autoload CSV for batch printing labels (Brother P-touch Editor v5.1)

My goal is to automatically print shipping labels for an e-commerce website based on periodically created .csv-files. I have the .csv-files ready. I also have the shipping label template ready in P-...
0
votes
2answers
200 views

How to remove rows that match?

I have a csv file with list of people (first name, last name, email) and then later on I will get a list of people in another csv file that unsubscribed ( only one column with email). Q: How can I ...
1
vote
1answer
72 views

Manually editing Excel worksheet, need my edits to save as written in .csv without reformatting back

Here is my issue: I have exported about 2000 records from a database to manually clean up the dates attached to them. (It appears that someone exported these records before, then re-imported them ...
4
votes
3answers
3k 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?
0
votes
0answers
111 views

Excel 2013 keeps removing commas from CSV at save

I'm working with data exports in CSV format. Excel originally opens the files correctly. However, I've been merging in some missing data that my original queries missed (adding four rows of additional ...
5
votes
3answers
18k views

Excel adds double quotes on csv export [duplicate]

I am experiencing a weird unknown behavior in excel. The sheet I want to export to a csv file consists of 4 columns with data like this: site.aspx|de|lblChanges.Text|some text that will be used ...
0
votes
2answers
4k 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 ...
2
votes
1answer
267 views

Create an animated plot of data points from csv

I have a large CSV File containing some data points [~3MB, example data] as a series of coordinates. I want to create an animated plot of point where the point is moving acoording to the given ...
1
vote
1answer
415 views

Using the with cURL command-line tool on Mac, What can I do to this script to ask it to fetch stock data which comes back WITHOUT commas?

cd documents/quoteUpdate while true do curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=sl1c1p2pt1" echo UPDATED: date sleep 10 done
0
votes
1answer
713 views

How to display US format date time in csv file in UK format in Excel 2010?

I have a Windows Performance Monitor csv file that I want to view in Excel and produce charts from. The first column in the csv file is in US datetime format. e.g. "01/12/2015 10:54:44.043" which ...
0
votes
2answers
253 views

Unable to get accurate record count of a csv file

I have a .csv file that has some values formatted as paragraphs with line breaks or sometimes bullet points. "STAT","ID","DESC" "UPD", "1", "Updated" "CHG", "2", "Changed" "UPD", "3", "Updated. ...
1
vote
4answers
2k views

How do I stop Excel from converting value 0503E000 to 5.03E+02 automatically?

Excel converting value 0503E000 to 5.03E+02 in any cell automatically in CSV I tried to convert it to text number and general but after i save it and reopen it again it goes back to 5.03E+02 How do I ...
0
votes
1answer
243 views

How do you export an Excel file to CSV with rows have differing number of columns?

I have text file with a header, master, detail, footer record. The types of rows all have a different amount of columns. When I export to CSV, it exports all data and puts in fillers to the longest ...
1
vote
1answer
14k views

How to enable the 'Save and Open' option in Internet Explorer

I've recently upgrade to Internet Explorer 11 and now when I try to download/open a *.csv file from the internet I get the following options in IE. The Save and Open option is disabled/greyed out. ...
-2
votes
1answer
394 views

Automate alignment of columns in CSV

I often work with CSV files, that other people will work with in a text editor. I want to have nice alignment of columns, e.g.: Height, Age, Whatever 11, 12, 13 For large files, this is ...
0
votes
1answer
127 views

Does Acrobat XI Pro Win ESD support fillable form fields from a CSV?

At work I had an old version of Adobe Acrobat Pro, version 9, which I used combined with some Actionscript and batch actions to fill in form fields using a csv file and finally outputting to one pdf ...
0
votes
1answer
471 views

Create CSV file from Excel with delimiter other than comma?

Is there a way to create a CSV file from an Excel one, but with a delimiter other than comma? I tried changing Windows parameters. In Windows Control Panel -> Click, Language & Region -> formats ...
1
vote
2answers
201 views

Formatting of output .csv file generated by a software

I've been using a software which gives the output in .csv format automatically. In my .csv output file "." is used as a decimal separator. In my colleague's computer, the same software outputs the ....
12
votes
3answers
22k views

How to convert Excel file with multiple sheets to a set of CSV files?

I have an Excel file with 20 sheets on it. Is there a way to quickly convert the file into 20 CSV files - one for each sheet? I can do it manually of course, but I'll have to be processing these ...
0
votes
1answer
12 views

How to export Outlook Express group

I need to export an Outlook Express group, but it doesn't seem to have an option for that? Is there any workaround? I've tried using the options to export but they export the whole address book.
1
vote
1answer
732 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 ...