Questions tagged [csv]
Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.
991
questions
3
votes
2
answers
3k
views
Notepad++ replace doesn't work for Regular Expression
EDIT
Proof that it should work: http://regexr.com?30pf2
I'm trying to replace all occurrences of , that are not within quotes with a ~
20,72275,Epidurography,1
21,72285,X-Ray C/T Spine Disk,1
22,...
3
votes
5
answers
27k
views
Comma separated values (literally, not csv) in the same cell in excel, put in individual cells
I have a column of cells in excel which contain mails, some only contain one mail as they should but others, have more than one email per cell in this format:
[email protected], [email protected], three@...
3
votes
2
answers
5k
views
Convert XLS to CSV in Unix
Is there an easy to compile plain C XLS (Excel sheet(s)) to CSV (or other text delimited format) converter for Linux or the BSDs that doesn't rely on Perl and installing a bunch of module perl modules ...
3
votes
2
answers
15k
views
Adding Header to CSV file using Powershell
I have a CSV file and data in CSV file looks like below its vertically formatted. that file is not having headers i want to add header to that file. when i tried to add using below powershell script ...
3
votes
1
answer
401
views
How to trim down PowerShell output in .csv file to write only the Release ID of a Windows 10 OS?
This script work but the output to the .csv in the release id field is everything associated with the registry key. All I want in the field is the release id number (1909, 1809, 1709). How to I edit ...
3
votes
2
answers
2k
views
How do I clean ~500,000 records in Excel 2010 without crashing my PC?
I have to remove large chunks of information from tables in .xlsx files using Excel 2010. Every method I have tried so far has produced no results, either crashed or I've killed it after waiting for a ...
3
votes
2
answers
4k
views
Sublime text 3, multiline select, how to go to a specified characted (on all lines)?
I have a CSV like this
id,name,city
1,John,New York
10,Peter,Los Angeles
223,Joseph,London
I'm in multiline select mode. I obtained the multiline cursor by selecting all the rows I needed and ...
3
votes
1
answer
7k
views
How to `cut` (extract a subset of columns) a CSV file that contains quoted strings`
I have a CSV file and want to discard a couple of columns. So let's say this is a sample file:
column a, column b, column c
value a, value b, value c
value a, "quoted, b", value c
And now let's ...
3
votes
1
answer
2k
views
How to link csv file in Libreoffice 5
In previous versions of Libreoffice Calc, it was straightforward to import and link csv files through [Import] -> [Sheet from file...], as per the instructions on this page. This allowed me to refresh ...
3
votes
1
answer
7k
views
How to import csv file from url into Google Docs (Drive)
I have a CSV file on a server, available via http.
I want to import this into Google Docs to analyse it.
Is there a way to do it directly?
Trying to do it via iPad, no PC.
Trying to avoid the ...
3
votes
3
answers
2k
views
Manually "draw" data for chart, output to CSV [closed]
I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...
3
votes
1
answer
451
views
How to return in a cell all the matching values present in a column?
Suppose I have the following data:
A
B
1
idx1
VAL1
2
idx2
VAL2
3
idx3
VAL3
4
idx4
VAL1
5
idx5
VAL4
6
idx6
VAL1
7
idx7
VAL1
8
idx8
VAL2
9
idx9
VAL5
10
idx10
VAL3
For each "VAL[n]" ...
3
votes
1
answer
3k
views
Split cells by uppercase and lowercase words in excel
I've got a CSV file with contacts inside that I want to import in an online contacts list.
Unfortunately, the CSV file has one single column for the full name, and does not differentiate "First Name"...
3
votes
1
answer
721
views
Excel - Text transformation keeping Roman Numerals uppercase
I have a CSV file that is exported from another program with one of the columns being the title. The data in the original program is all uppercase for the title field so when it exports, the title ...
3
votes
3
answers
31k
views
How can I make Excel save a .csv using commas and quotes?
I am trying to save file as a .csv, however, Excel is not using the standard comma separator and quotes. Here is an example of what I want:
"0","70","0","4/29/2012 12:00","13311250""1","70","0","4/30/...
3
votes
2
answers
258
views
Which delimiter allows major spreadsheet programs to open CSV files by double-clicking?
I'm writing an iOS 8 app that allows you to export data to be sent as an email attachment. Currently, I'm exporting the data to a CSV file with 7 columns and x number of rows. When I first created it, ...
3
votes
7
answers
11k
views
Delete empty column from csv file with bash script
Looking for some way to look at a csv file and delete columns including the header that have no values in the subsequent lines that follow.
Perhaps if I wanted to delete column Test03 from below ...
3
votes
1
answer
7k
views
CSV files cant store special characters?
I have read several other questions on this subject but none have an answer which fixes my problem.
I have an execel file which is in russian and I need to convert it to CSV without it losing any of ...
3
votes
1
answer
3k
views
How to display/monitor the tail of a growing CSV file in tabular format?
I am looking for a way to display an open, "live" CSV file under Windows 7. For example, I have a proprietary program running that is generating log data in CSV format. I'd like to keep an eye on what ...
3
votes
1
answer
1k
views
Word 2007 prompts twice for "Opening this document will run the following SQL command" for Mail Merge
I am trying to figure out why my mail merge in the a Word document is prompting me twice for seemingly two different data sources. Both prompts look like the following:
.
The first prompt points ...
3
votes
3
answers
2k
views
How to visualize/graph a massive dataset?
I have a CSV file of data collected using Performance Monitor. It collected CPU usage at 5 second intervals for two weeks.
I need to be able to graph or visual the data in a way that'll help me ...
3
votes
1
answer
6k
views
Removing the last tab of a line in a file
I have a text file which consists of tab delimted fields terminated with a CR/LF. Before the CR/LF an extra tab has been inserted effectively creating a blank field at the end of every line.
I would ...
3
votes
1
answer
194
views
Powershell - Combine two CSVs with 1 CSV Dynamic
I have created a Powershell script to send alerts based on network status' found by running a Python script to check Uplink status. The Python script creates a CSV and my Powershell script selects the ...
3
votes
3
answers
6k
views
Combine multiple CSV files by column, not by row
I have ~100 CSV files that I want to combine into one single Excel spreadsheet (everything in one tab, not in separate tabs). These CSV files are identical in format: each contains 4,000 rows and 2 ...
3
votes
1
answer
11k
views
Dbeaver export result set to multiple CSV files
I'm using the latest version of DBeaver on Mac, querying against a remote MSSQL database and I've got a query that results in 24 million rows. I need to get this data into CSV format, but rather than ...
3
votes
1
answer
1k
views
Find common columns (same column name/header but different positions) from two or more excel worksheets
I have excel worksheets (csv format) from different clients, where first row of all worksheets contain the column names. However, the order and number of columns in each worksheet can be different. ...
3
votes
4
answers
14k
views
cannot find any saved .csv files
I did search through many of the .csv realated topics that the search returned so I hope this is an appropriate new question...
I am trying to setup an excel spreadsheet using a .csv file as the data ...
3
votes
1
answer
3k
views
Regex to find commas, excluding commas inside a string demarcated by double quotes
I would like to manipulate a closed .csv file without opening it through a button on an Excel AddIn. I am able to complete all the steps but am having a problem with finding a regex that would ...
3
votes
4
answers
13k
views
Convert a JSON file to CSV or XLS (Excel) format
I have a number of JSON files which my old charting system will not accept as a data format for import. Is there an easy way to convert these to CSV or XLS?
3
votes
2
answers
19k
views
Import CSV file into Exchange Mail Contacts using powershell without duplicates
The Problem: A good number of people's info was added to my "Mail Contact" list in Exchange Management Console, but not all.
Summary: I'm attempting to add a list of several hundred people ...
3
votes
4
answers
16k
views
Batch script to append record to csv files
I have a bunch of stock data in csv's that I am backtesting trading strategies on. The problem is that my strategy buys the open market price if a signal was found yesterday, unfortunately my data is ...
3
votes
2
answers
4k
views
How to combine multiple rows of data of a single customer in a cell as comma separated values?
I have a PIVOT table report like the one below:
Customer Name Category Date Met
-----------------------------------
Customer 1 Core 9
10
Customer 2 ...
3
votes
1
answer
5k
views
How to add time duration column total from Skype Call History CSV file in Excel 2010?
How to add time duration column total from Skype Call History CSV file in Excel 2010?
These are my exact steps on how to set up my Excel spreadsheet.
How to import Skype Call History CVS in Excel ...
3
votes
2
answers
7k
views
Getting Excel to handle CRLF's correctly in CSV
I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...
3
votes
0
answers
945
views
When importing CSVs, does Excel have a limit of 32,767 characters or 32,758 characters?
According to the documentation, Excel has a limit of 32,767 characters per cell.
However, when I save a CSV file that looks like this:
"Cell with exactly 32,767 characters........","...
3
votes
0
answers
111
views
Excel csv-import into table referenced by name
I have a worksheet called raw_data where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv.
However if I try to create a table on another ...
3
votes
2
answers
2k
views
Finding why there is a difference in size for a CSV file with the same content
Situation:
I run a macro to format an excel file, and save the formatted excel file as a .xlsx, the file size is 37 KB. I copy the content and save it into a new file, 30 KB.
Issue:
I want to know ...
3
votes
1
answer
2k
views
How to Disable Auto-Formatting of All Column Values when opening CSV Files in Microsoft Excel [duplicate]
How can I stop Microsoft Excel from auto formatting data when imported from a csv/text file? Specifically, I want it to treat all of the values as text.
The files come to me as tab delimited text ...
3
votes
2
answers
10k
views
Formatting date in excel for csv upload
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to ...
3
votes
1
answer
269
views
Outlook 2007 export contacts including list info
I want to export all contacts in outlook 2007 for import to gmail. Many of the contacts are members of various distribution lists, but there are no info in the exported csv-file as to which ...
3
votes
0
answers
761
views
How to setup a CSV web datasource
In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
3
votes
1
answer
1k
views
Free or Open Solution for Storing and Charting CSV data [closed]
I'm presently storing CSV files, combining them, opening them in open office, creating pivot tables and then generating charts from the spreadsheet.
I've looked at OOBase, but appending csv files to ...
3
votes
2
answers
1k
views
Convert tab separated to a human readable aligned column headers
Let's say I have a spreadsheet with the following example data:
I need to display this in plain text but still human readable.
When saved in a tab separated format (tsv) it will output something ...
2
votes
3
answers
9k
views
Splitting a 7 million row CSV by a specific column
How would I go about splitting a very large (7 million rows) CSV file into several different sheets/files by a specific numerical column. It should split into about 10 different files.
2
votes
2
answers
6k
views
Remove every line breaks following carriage return (^M) and join the lines
edit: Now that I got answers, I marked one by @KamilMaciorowski that fits better to the title as an answer, but this answer by @oliv actually were better suited to my actual need to my primary purpose....
2
votes
2
answers
5k
views
Best way to search for a string (text) in >10 large CSV files (250mb each)
I am wondering what's the best way or tool to search for a specific text or string in more than 10 large .csv files. Each file is 250mb in size.
My idea was to write a powershell script, since I ...
2
votes
2
answers
4k
views
Notepad++ Regex Help in cleaning up file
I've got a csv file (the column separator is "<;>" ,the text delimiter is the double quote and the row separator "crlf") of more than 18000 lines.
However,many of the data contained within the ...
2
votes
3
answers
2k
views
How to set field seperator in Emacs csv-mode?
Can I set the field seperator(s) for the current buffer in Emacs 23?
2
votes
3
answers
229
views
Generate an alphabetic index from a spreadsheet
I have a text file of lecture topics from my physics class that looks like this:
1/14,Galilean relativity,Einsteinian relativity,Minkowski space,Henri Poincare,,
1/16,Lorentz transformations,Velocity ...
2
votes
1
answer
1k
views
Clean up CSV based on another CSV
I have a csv file named master.csv, which has the following columns
link, name
And another csv file called details.csv, which has the following columns
link, name, price, desc
I want to match ...