Web Applications Stack Exchange
Web Applications Stack Exchange

Questions tagged [csv]

Comma-separated values - a simple file format that stores tabular data (numbers and text) in plain-text form.

37 questions
166
votes
4 answers

How to paste a comma separated string over multiple cells in Google Sheets?

Say I have a string of: l,f,x,a,s,f I would want to paste this every comma-separated value over 6 adjacent cells. How would I do it?
user3046061
  • 1,777
  • 2
  • 10
  • 5
55
votes
6 answers

How to export a filtered set of rows from a Google Spreadsheet?

Is it possible, when exporting a Google Spreadsheet into a CSV, to apply this operation only to filtered set of rows? I need to get in CSV exactly the rows which are visible on the sheet after a filter is applied to it.
Stan
  • 659
  • 1
  • 5
  • 7
20
votes
2 answers

Pull CSV data from URL to Google Spreadsheet

I have a site which allows authenticated users (read: in-house users) to download certain data from the site in CSV format, e.g. http://example.com/activities.csv . Can I create a Google Spreadsheet which pulls its data directly from that URL? (The…
pjmorse
  • 303
  • 1
  • 4
  • 10
16
votes
1 answer

How to use "split text to columns" when pasting in Google Sheets?

I have some CSV data in the clipboard that I'm trying to paste into a Google sheet (Chrome, Windows 7). There isn't really a direct paste option for CSV data (like the "Paste Unformatted Text" option in OpenOffice), but I noticed that sometimes a…
Jason C
  • 417
  • 1
  • 3
  • 20
13
votes
1 answer

Export all sheets in a spreadsheet to csv in Google Apps

Is there a way to export all sheets in a google spreadsheet to csv as individual files ?
Michael
  • 489
  • 2
  • 4
  • 12
10
votes
1 answer

How can specific columns of a Google spreadsheet be exported as CSV?

I have a Google spreadsheet with 10 columns of data. I would like to export columns A, C, E, F as csv. I do not need to export the entire spreadsheet. Can this be done? I do not mind using Google script.
curious
  • 265
  • 2
  • 4
  • 8
9
votes
2 answers

IMPORTDATA Google Sheet CSV on Google Drive

So I'm starting to really get into utilizing Google Drive to streamline my many personal projects. One of the things I'd love to do is figure out how to download CSV files onto my Google Drive, and have Google Sheets automatically do an =IMPORTDATA…
Jonathan Doe
  • 171
  • 1
  • 2
  • 8
7
votes
2 answers

Google Spreadsheets CSV Encoding not UTF-8?

I was assuming that Google spreadsheet exports UTF-8 encoded CSVs. However, this does not seem to be the case — my German Umlauts, etc. (äüöß, etc.) are not recognized, i.e., when opening the file in XLS. Here is an example file: Link
Kay
  • 203
  • 1
  • 2
  • 8
7
votes
2 answers

What's the biggest .csv file you can import into a Google Sheets?

I'm trying to upload/import a 7 MB .csv file to Google Sheets without much luck. What's the largest file size that you can import?
leeand00
  • 2,233
  • 6
  • 25
  • 37
4
votes
3 answers

How to escape a double-quote in a TSV file for import into a Google Sheets?

How does one specify a cell to contain exactly one double-quote character in a TSV file so that it will be handled correctly when imported (as a spreadsheet) into Google Sheets? (Note: when importing the file, Tab rather than Automatic must be…
kjo
  • 439
  • 2
  • 8
  • 20
4
votes
2 answers

No force-reload tip on Google Sheets?

So I'm running nightly tasks to generate some custom statistics for my site and copy the statistics in .csv format to separate server via SCP. Then I use these .csv files in Google Sheets to display them in table format. The problem is, though, that…
Eimantas
  • 243
  • 2
  • 7
4
votes
1 answer

Comma-separated values analysis and pivot tables in Google Spreadsheets

I have an issue with comma-separated values analysis and pivot tables in Google Spreadsheets. What if I have the following dataset: Facebook, Github Developer No answer Developer Github, MSDN Developer Facebook, Github …
Sully
  • 43
  • 1
  • 5
2
votes
2 answers

Parsing JSON, XML or CSV with IFTTT?

I'd like to create an IFTTT action that allows triggers based upon a certain electricity price threshold. This Xively feed can return the current price in either JSON, XML, or CSV formats. Xively's API reference is here. Is there any IFTTT…
glenviewjeff
  • 1,088
  • 2
  • 11
  • 27
2
votes
1 answer

Import a CSV file from a URL to Google Sheets and update it periodically

I'm looking to pull data from a CSV file that gets update regularly into a Google spreadsheet that I can format the way I want. I know how to import the CSV as a one time thing but I don't know how to get it to update the data once it changes in the…
MrCarter
2
votes
1 answer

Can I get all contributions by users and export them in a csv file in MediaWiki?

From my MediaWiki site, I would like to get all the contributions by users in the last month in a csv file format. Is there any extension for this? Can I query the database and get this information?
Leena
  • 29
  • 1
1
2 3